Notably, SSMS 18.0 discontinued the practice of sharing components with the SQL Server engine itself. This meant that updates could be delivered more frequently and with greater confidence, reducing the risk of unintended side effects.
The Query Store became even more critical for identifying performance regressions caused by new optimizer features. SSMS provides specialized reports to visualize how IQP features—such as Table Variable Deferred Compilation and Adaptive Joins—impact query execution.
: The graphical ShowPlan visualizer explicitly highlights performance cost impacts driven by the new 2019 inline scalar User Defined Functions (UDF) capability. Feature Comparison Matrix sql server management studio 2019 new
The agility of the new SSMS 18 allowed Microsoft to ship major enhancements in smaller point releases:
SSMS 18.0 was more than just a number change; it was a complete rebuild. By moving to the VS 2017 Isolated Shell, Microsoft significantly improved the tool's core stability and performance. Notably, SSMS 18
A development team uses SSMS 18.0 for schema design and server management while simultaneously launching Azure Data Studio from within SSMS for data exploration and collaboration via notebooks. The two tools complement each other seamlessly, with scripts and queries shared between environments.
SSMS 2019 heavily emphasized Azure integration, reflecting Microsoft’s cloud-first strategy: SSMS provides specialized reports to visualize how IQP
: Built on the Visual Studio 2017 Isolated Shell , which improves accessibility, high DPI support, and reliability.
Joshua Eze is the Founder & Salesforce Architect at Sailwayz, a certified Salesforce Consulting Partner based in the UK. With over 6 years of experience leading CRM transformations, he is a certified Application & System Architect passionate about using technology to simplify business processes. Joshua helps companies unlock the full potential of Salesforce with strategic, scalable, and secure solutions.
