管理 SQL Server 資料庫太麻煩？SQL Server Management Studio 能幫上忙

What's new in this version:

Whats New:

SSMS:
- Added "Migrate to Azure" under Tools menu – We have integrated Database Migration Assistant and Azure Database Migration Service to provide quick and easy access to help accelerate your migrations to Azure
- Previous version of SSMS 18.0 (< Preview 6) had the "Available Databases" key shortcut bound to CTRL+ALT+J. In Preview 6 and later, the key binding has been restored to CTRL+U, like it was in SSMS 17.x
- Added logic to prompt the user to commit open transactions when "Change connection" is used

SSIS:
- When you use SQL Agent of MI by SSMS, you can configure parameter and connection manager in SSIS agent job step


BUG FIXES:
SSMS Editor:
- New TRANSLATE function now recognized by intellisense
- Improved intellisense on FORMAT built-in function
- LAG and LEAD are now recognized as built-in functions
- Fixed an issue where intellisense was giving a warning when using "ALTER TABLE...ADD CONSTRAINT...WITH(ONLINE=ON)"

Object Scripting:
- Fixed an issue where trying to script a spatial index with GEOMETRY_AUTO_GRID/GEOGRAPHY_AUTO_GRID on an Azure SQL Database was throwing an error

SMO:
- Fixed an issue where an application written using SMO would encounter an error if it tried to enumerate databases from the same server on multiple threads even though it uses separate SqlConnection instances on each thread

Data Classification:
- Fixed an issue when saving classifications in the data classification pane while there are another data classification panes open on other databases

Azure SQL Database:
- Enabled the Statistics properties sub menu option under menu Statistics in Azure, since it has been fully supported for quite some time now

Query Data Store:
- Fixed an issue where a "DocumentFrame (SQLEditors)" exception could be thrown
- Fixed an issue when trying to set a custom time interval in the build-in Query Store reports the user was not able to select AM or PM on the start/end interval

Copy Database Wizard:
- Generate scripts/Transfer/Copy Database Wizard try to create a table with an in memory table doesn't force ansi_padding on
- Transfer Database task/Copy Database Wizard broken on SQL Server 2017 and SQL Server 2019
- Generate scripts/Transfer/Copy Database Wizard script table creation before creation of associated external data source

Profiler:
- Added "Aggregate Table Rewrite Query" event to Profiler events

ShowPlan:
- New mem grant operator properties display incorrectly when there is more than one thread