DatabaseDeveloper

SQL Server Management Studio (SSMS) 18.0 now Generally Available

SQL Server Management Studio v18.0 is now generally available and is the latest version that provides support for almost all feature areas on SQL Server 2008 through to 2019 preview.

If you have a preview of SSMS 18.0 installed, you will need to uninstall before you can install SSMS 18.0 GA. SSMS 18.0 will also not replace an older version of SSMS but will run side by side with it.

image

Release Highlights

Here is a brief list of is new in SSMS 18.0.

  • Support for SQL Server 2019. SSMS 18.0 is the first release to be fully aware of SQL Server 2019 (compatLevel 150).
  • SSMS 18.0 is based off the Visual Studio 2017 Isolated Shell.
  • Smaller download size.
  • Accessibility improvements.
  • Ability to install to a custom folder.
  • Requires .NET Framework 4.7.2 or greater.
  • Support for High DPI (by default).
  • Added integration for Azure Data Studio.
  • Still no official support for Dark Mode. Please see my article on how to enable Dark Mode for SSMS.
  • Database Diagrams has been removed. Seriously it’s gone! You will need to install a previous version of SSMS (like 17.8.1) to get this functionality.

Summary

Dark mode is still not available and remains a feature you have to manually enable. It’s also weird that they dropped support for the Database Diagramming tool without any warning or guidance to replace it. This was a gem of a tool inside of SSMS and was simple to use for visualizing database relationships, and documentation. You will need to rely on an older version of SSMS or use another tool. Other than that it looks like a great update to SSMS.

For more details on what’s new, bug fixes and deprecations, please take a look at the detailed release notes.

To get started download SSMS 18.0 (GA) now.

Enjoy!

References

Azure

#AzureApril–Day 1

Inspired by @burkeholland, @editingemily, @sigje and others where instead of putting effort into an Aprils Fools joke, I will instead take the #AzureApril challenge of posting an Azure tip each day in April. Some tips might come from @mbcrump comprehensive list of tips and tricks, while others might come from me and/or the community. Now on to todays tip.

Tip #1

Azure has over a 100 services that offer you everything you need to develop, build and run you applications with all the performance, redundancy, security, and scale that the cloud has to offer. With all these services sometimes it can be daunting on where to begin.

Todays tip is to take bite-sized lessons to reinforce your #Azure skills, all in a single month of lunches. This is a practical guide to learning Azure cloud computing skills quickly or refresh what you already know.

By reading this e-book, you get to build your cloud computing skills quickly and efficiently. You’ll be productive immediately, and when you finish, you’ll be well on your way to Azure mastery.

For more details and to download the e-book, go to https://azure.microsoft.com/en-us/resources/learn-azure-in-a-month-of-lunches/

Since we’re starting a new month today this is a great tip to tackle and complete by end of the month, all while eating your lunch.

Enjoy!

References

Learn Azure in a Month of Lunches

Azure

New Azure Datacenters Open in Africa

image

Today Microsoft announced the general availability of new Azure regions in Cape Town and Johannesburg, South Africa. This marks a major milestone as Microsoft is the first global cloud provider to deliver cloud services from datacenters on the African continent.

Microsoft Azure now has a total of 54 regions worldwide that span 140 countries. That’s more than all other cloud providers combined – offering the scale needed to bring applications closer to your users around the world, preserving data residency, and offering comprehensive compliance and resiliency options.

Enjoy!

References

Microsoft opens first datacenters in Africa with general availability of Microsoft Azure

Azure Regions

Azure Locations

Windows

Windows 10 Mail and Calendar app finally gets complete dark mode

image

Today Microsoft is rolling out an update to its Mail and Calendar app and has finally added a complete dark mode to which the reading pane is now dark (previously the reading pane or email body was white). Microsoft has also added a toggle button to switch between light and dark which sits between the Forward and Archive buttons.

The new update is available for everyone that is using Windows 10 1809 build. You can download the Mail and Calendar app from the Microsoft Store.

Enjoy!

AIAzureDevelopmentEvents

Registration is now open for Microsoft Build

Build2019

Registration is now open for Microsoft’s premier developer conference, Microsoft Build, which is taking place May 6-8 in Seattle, WA. At Microsoft Build, you’ll get access to the latest product updates, hear about Microsoft’s strategy and product roadmaps, and get hands-on, ask questions, and learn the best practices.

Some of the benefits for attending Build are:

• Learning from real-world experiences on building, modernizing, and migrating cloud applications

• Add value to your new and/or existing applications with AI

• Collaborative coding with your peers using the latest development tools

• Increasing productivity for your business with DevOps automation, tooling, and processes

• Creating and deploying cross platform applications

• Discovering innovations across Mixed Reality, IoT, and Machine Learning

• Learning new ways to easily customize, build, and extend applications with minimal code

If you’re interested in the content from last year, here is complete listing of the 2018 sessions.

New this year is the ability to bring your student-aged family member (14-21 years old) to the conference for free! For details about this wonderful opportunity, click here. Space is limited, so register today. While attending the event last year, one of the Microsoft Executives brought his two daughters and it was awesome to see them take interest and engage with the speakers and product groups. I’m glad they made this available this year for all eligible students.

I went to Microsoft Build last year for the first time and loved the experience to see and try the latest technologies, to connect with peers, and discover new innovative solutions to build. I’m not able to attend this year but I’m hoping to go again in the near future. If you can’t attend, then you always have the option to watch it on demand.

If you’re interested in going, then Register for Microsoft Build now!

Enjoy!

References

Microsoft Build

Microsoft Build FAQ

AzureDatabase

February release of Azure Data Studio is now available

image

The February release of Azure Data Studio is now available to download and includes the following key highlights:

  • Introducing Admin pack for SQL Server
  • Auto-sizing columns in results
  • Notebook UI improvements
  • Added Profiler filtering
  • Added Save as XML
  • Added Data-Tier Application Wizard improvements
  • Updates to the SQL Server 2019 Preview extension
  • Turned on results streaming by default
  • Deploy scripts
  • Bug fixes

For a list of the complete updates, refer to the release notes.

Download Azure Data Studio now!

References

https://cloudblogs.microsoft.com/sqlserver/2019/02/13/the-february-release-of-azure-data-studio-is-now-available/

DevelopmentReflectInsight

Preview of ReflectInsight.Core

Today we published our first draft of ReflectInsight.Core, a port of our ReflectInsight logging library for .NET Framework to .NET Core and we are making it open source on GitHub. We still have some things to iron out like setting up a CI/CD, NuGet package creation, a sample app, docs and some refinements to the code base.

So far is working in our labs and we will share more information with you soon.

image

Enjoy!

Note: This post was re-blogged at https://blog.reflectsoftware.com

References

https://github.com/reflectsoftware/reflectinsight.core/tree/master