Download SQL Server Management Studio 19.0 (Preview 2)

Microsoft has released the second preview of SQL Server Management Studio 19.0. With SSMS you can manage a Microsoft SQL environment, for example an on-premises SQL Server, but also an Azure SQL Data Warehouse in the cloud. It provides tools for migration, configuration, monitoring and deployment of the different data tier components. You can also assemble queries and scripts. The brief preview customizations look like this:

What’s new in 19.0 Preview 2

• Azure Data Studio installation integration – Installation of SSMS installs Azure Data Studio 1.36.2.
• Always Encrypted – Added the ability to explicitly configure an attestation protocol in the “Connect To Server” dialog when using Always Encrypted with secure enclaves (column encryption).
• Client Driver – Changed to Microsoft.Data.SqlClient.
• Contained Always On Availability Group – Added support for Contained Always On Availability Groups.
• Data Classification – Improvements to Data Classification user interface.
• Ledger – Added support for Ledger feature Database ledger. For more information, visit What is the database ledger?.
• Query Execution or Results – Improved checks for open connections.
• Query Tuning Advisor – Updated user interface for improved accessibility.
• Showplan – The showplan XML schema has been updated.

Bug fixes in 19.0 Preview 2

• Availability Group Dashboard – Fixed the issue when connecting to the Availability Group Dashboard for an AG on SQL Server 2016, which resulted in “unknown property ClusterType” error.
• Query Editor – Fixed issue with audible notification occurring when closing a query window. See SSMS 18.11.1 Beeps When I Close a Query Window.