When upgrading database compatibility levels, the QTA guides administrators through performance regression testing. It automatically analyzes query plans and recommends optimal plan guides to prevent performance degradation. Improved Static Data Masking
In this article, we will explore every major new feature, hidden gem, and workflow change introduced in SSMS 18.x (the version lineage tied to SQL Server 2019).
: The platform shifted its base dependency to .NET Framework 4.7.2 . This introduces strict host requirements: installation is blocked on obsolete builds of Windows 10 (pre-version 1607) and Windows Server 2016 (pre-version 2017). Advanced Security and Compliance Frameworks sql server management studio 2019 new
This feature alone turns a week of manual auditing into a 10-minute job.
Deep Dive: What’s New in SQL Server Management Studio (SSMS) 18 When upgrading database compatibility levels, the QTA guides
A new UI-driven tool that scans your database for security risks and provides actionable recommendations for hardening. 3. Expanded Cloud & Hybrid Support
Performance tuning received a massive injection of "new" DNA in SSMS 2019. : The platform shifted its base dependency to
SQL Server Management Studio (SSMS) 18.0 is the primary version associated with the release of , providing full awareness for its capabilities, including compatibility level 150. Key Features of SSMS 18.0 (for SQL Server 2019)
You can now perform rich operations on encrypted columns (pattern matching, LIKE , > comparisons) without decrypting the data on the client.
The connection dialog box features enhanced support for Azure Active Directory (Azure AD) Multi-Factor Authentication. Developers and administrators can securely connect to Azure SQL databases using interactive authentication methods, smart cards, and single sign-on (SSO). 5. Accessibility and User Experience Adjustments High-DPI Monitor Support