Note: If you are connecting to a development server that uses a self-signed certificate, you will need to check "Trust Server Certificate" in the connection properties, but be wary of doing this in production environments.
SQL Server Management Studio (SSMS) is the primary integrated environment for managing SQL Server infrastructure. While SSMS is versioned independently of the SQL Server engine, it is often referred to alongside , which introduced several critical advancements. Key New Features in the SQL Server 2019 Ecosystem
SSMS 18.0 established a new relationship with Azure Data Studio (ADS)—Microsoft's modern, lightweight database tool. Rather than competing with each other, SSMS and ADS became . sql server management studio 2019 new
| Component | Requirement | |-----------|-------------| | OS | Windows 10 (min 1607), Windows Server 2016+ | | .NET Framework | 4.7.2 or later | | RAM | 4 GB minimum (8 GB recommended) | | Disk | At least 2 GB free | | Display | 1280×720 (1366×768 or higher recommended) |
: Both "Results to Grid" and "Results to Text" now support up to 2 MB per cell (up from 64 KB and 8 KB respectively), allowing developers to inspect much larger strings without truncation. Note: If you are connecting to a development
This feature drastically reduces the time it takes to recover a database after a crash or a long-running transaction rollback.
Here are some reviews from various sources: Key New Features in the SQL Server 2019 Ecosystem SSMS 18
Built-in tool to scan your databases for security misconfigurations and deviations from best practices.
: The collation dialog now supports UTF-8, aligning with the new UTF-8 collation features introduced in SQL Server 2019. Developer and UI Improvements
Microsoft also streamlined SSMS by removing outdated components in version 18.x: