Month: April 2019

DatabaseDeveloper

SQL Server Management Studio (SSMS) 18.0 now Generally Available

on April 29, 2019

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

on April 1, 2019

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