SQL Server Management Studio (SSMS) is the primary integrated environment for managing SQL Server infrastructure. While SSMS is versioned independently of the SQL Server engine, it is often referred to alongside , which introduced several critical advancements. Key New Features in the SQL Server 2019 Ecosystem
For many identified risks, SSMS provides a direct T-SQL remediation script to fix the security gap instantly. Always Encrypted with Enclaves sql server management studio 2019 new
| Release | Key New Features & Improvements | | :--- | :--- | | (Apr 2019) | Rebuilt on VS 2017 Isolated Shell, full support for SQL Server 2019, Data Classification, Vulnerability Assessment, smaller installer, Azure Active Directory auth. | | SSMS 18.1 (Jun 2019) | Restored Database Diagrams, restored ssbdiagnose utility, fixed IntelliSense settings, SSIS package scheduling. | | SSMS 18.2 (Jul 2019) | IntelliSense for OPTIMIZE_FOR_SEQUENTIAL_KEY , added ContainsInlineScalarTsqlUdfs to show UDF inlining, completion time in Messages tab. | | SSMS 18.3 (Sep 2019) | UI support for ALTER SERVER CONFIGURATION and other new T-SQL, added a rank attribute to Data Classification. | | SSMS 18.4 (Nov 2019) | GUI controls for Query Store custom capture policies, support for MAX_PLANS_PER_QUERY setting, custom info protection policies for Data Classification. | | SSMS 18.5 & 18.6 (2020) | Support for Microsoft Entra multifactor authentication (MFA), enhancements for Azure SQL Managed Instance. | | SSMS 18.x (Ongoing) | Continued bug fixes, stability improvements, and updates to support new Azure and SQL Server features. | SQL Server Management Studio (SSMS) is the primary
The "new" in SSMS 2019 isn't just features—it’s the engine. Always Encrypted with Enclaves | Release | Key