Sql Server Management Studio 2019 New

Create table:

Run a query:

Backup database:

Restore database:

Import data:

Generate scripts:

View execution plan:

Monitor performance:

Data privacy regulations (GDPR, CCPA) drove one of the most practical new features.

What’s New: Data Classification & Sensitivity.

This feature alone turns a week of manual auditing into a 10-minute job. sql server management studio 2019 new

If you are upgrading from SSMS 17 (for SQL 2016/2017), here is your checklist:

In older SSMS, if you filtered tables by name "Sales%", the filter reset when you restarted. SSMS 2019 saves your filters per database connection. Create table:

The "new" in SSMS 2019 isn't just features—it’s the engine.

For database administrators, developers, and data professionals, SQL Server Management Studio (SSMS) is the command center. With the release of SQL Server 2019, Microsoft didn't just update the database engine; they delivered a series of significant updates to SSMS. Run a query:

If you are still using SSMS 17.x (from the SQL Server 2017 era) or older versions like SSMS 2016, you are missing out on a massive productivity leap. This article breaks down everything new in SSMS 2019 (version 18.x), from Azure integration to performance tools.

| Feature | SSMS 2017 (17.x) | SSMS 2019 (18.x) | |---------|------------------|------------------| | SQL Server 2019 support | Partial | Full | | Azure Data Studio launch | No | Yes | | XEvent Profiler | No | Yes | | S3-compatible backup | No | Yes | | AAD Universal Auth | Limited | Full with MFA | | Dark theme | No | Experimental |

Was this article helpful?

Thank you!