For database administrators (DBAs), data engineers, and developers, SQL Server Management Studio (SSMS) is the cockpit of the Microsoft data platform. While the flagship SQL Server database engine gets the headlines, SSMS is the tool you live in every day.
With the release of SQL Server 2019, Microsoft significantly revamped SSMS, not just as a sidecar to the database engine, but as an independent, modern tool. The keyword "SQL Server Management Studio 2019 new" isn't just about compatibility—it’s about a tidal wave of quality-of-life improvements, performance boosts, and features that were previously exclusive to Azure Data Studio.
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).
Note: SQL Server Management Studio 2019 corresponds to SSMS 18.x (officially released April 2019, with updates through 18.12.1 in 2024). We will focus on features new from SSMS 17.x to the 18.x series.
It is important to clarify a common point of confusion. SSMS 19 is the tool version, whereas SQL Server 2019 is the database engine version.
The "New SSMS 19" is fully compatible with SQL Server 2019. In fact, using the newest management tool is highly recommended even if you are running older database engines (like SQL Server 2016 or 2019). The tool brings the security features and UI improvements to your management workflow regardless of the engine version you are running.
SQL Server Management Studio (SSMS) 2019 is the integrated environment for managing any SQL infrastructure, from SQL Server 2019 down to SQL Server 2008. This version focuses on productivity, accessibility, and integration with Azure data services. sql server management studio 2019 new
SQL Server Management Studio (SSMS) 18.x is the integrated environment for managing Microsoft SQL Server instances, databases, and related services; it is the primary GUI for development, configuration, administration, and debugging of SQL Server. SSMS 18.x was the supported SSMS generation during the SQL Server 2019 era and is fully compatible with SQL Server 2019. SSMS is a separate, free install from SQL Server itself and receives independent updates.
SQL Server Management Studio (SSMS) version 18 is the primary release aligned with SQL Server 2019, introducing significant modernization to the tool's shell and performance . Top 5 Features in SSMS 18 (2019 Release)
Modern Shell & Smaller Footprint: Built on the Visual Studio 2017 Isolated Shell, it offers improved accessibility and a download size roughly half that of previous versions (~400 MB) .
Increased Query Output Limit: Both "Results to Grid" and "Results to Text" now support up to 2 MB per tuple (up from 64 KB/8 KB), making it significantly easier to inspect large dynamic SQL strings without truncation .
High DPI Support: High DPI is enabled by default, ensuring that dialogs and windows scale correctly across modern high-resolution monitors and multi-monitor setups .
Integrated Tools: It features a "Launch Azure Data Studio" option directly within the UI and integrates the Query Tuning Assistant (QTA) to help users manage database compatibility level upgrades . SQL Server Management Studio 2019: What’s New
SQL Server 2019 specific support: It is the first version fully aware of compatibility level 150, enabling features like UTF-8 support in collation dialogs and Always Encrypted with secure enclaves . Key Developer & Admin Improvements
Static Data Masking: Securely mask sensitive data in a non-production copy of your database .
Object Scripting: New "CREATE OR ALTER" menu options simplify the scripting of existing objects for deployment .
ShowPlan Enhancements: Added actual time elapsed and actual vs. estimated rows for operator nodes, aligning the actual plan view with Live Query Stats .
Custom Installation: For the first time, SSMS can be installed to a custom folder rather than being forced into the default program files path .
Note: The Database Diagrams feature was initially removed in 18.0 but was added back in version 18.1 due to high user demand . Note: SQL Server Management Studio 2019 corresponds to
If you'd like, I can help you with specific steps for upgrading your SSMS or explain how to use the new Query Tuning Assistant.
Note: There is no official "SSMS 2019" version number; the major version released alongside SQL Server 2019 was SSMS 18.0 (later updated to 18.12.1). Below are the major features introduced in the SSMS 18.x generation.
The built-in Performance Dashboard (right-click on a server -> Reports -> Standard Reports -> Performance Dashboard) saw major updates.
What’s new?
Why this matters: In older SSMS versions, troubleshooting performance required writing complex DMV queries. Now, a GUI-driven "top waits" report helps junior DBAs identify bottlenecks in seconds.
This is where you write SQL code (SELECT, INSERT, etc.).