The graphical execution plan is a DBA’s best friend. SSMS 18.x added several long-requested features.
: A new tool that guides you through database compatibility level upgrades by collecting performance baselines and identifying regressions. Functional Changes sql server management studio 2019 new
You can manage columns that are encrypted while still performing rich queries (like pattern matching or range scans) on the data, with the cryptographic keys managed securely via SSMS. 4. Modernization and Usability Upgrades The graphical execution plan is a DBA’s best friend
Database security gets a dedicated evaluation framework built directly into the Object Explorer interface. sql server management studio 2019 new