Press or click Execute . Refresh the Databases folder in Object Explorer to see it.
SSMS 17.x had notorious issues: random crashes, slow Object Explorer expansion, and memory leaks. SSMS 18.x focused heavily on reliability.
: 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 . sql server management studio 2019 new
: A built-in service to scan databases for security risks and misconfigurations.
| Removed Feature | Reason | Workaround | |----------------|--------|-------------| | | Security vulnerability (deprecated) | Use PRINT , RAISERROR , or Visual Studio | | Maintenance Plans for Multi-Server | Rarely used | Use SQL Agent Jobs with T-SQL | | XDR (XML Data Reduction) | Obsolete | Use standard XML | | SQL Server 2008 backward compatibility | Requires older .NET | Install SSMS 17.x alongside | Press or click Execute
Here are some ratings from various sources:
The graphical execution plan is a DBA’s best friend. SSMS 18.x added several long-requested features. SSMS 18
Built-in tool to scan your databases for security misconfigurations and deviations from best practices.
The new features of SSMS 18 are best understood through their practical impact on daily tasks. The table below highlights the most important advancements:
Alex, the lead DBA, sat before his monitors. He launched the SSMS installer , watching the progress bar creep forward. Once it finished, he didn't just see a tool; he saw a way to finally conquer the "Big Data" problem that had been plaguing their quarterly reports. The Spark of a New Era