SQL Server Management Studio

What's new in this version:

New:
- Azure Data Studio installation integration  Installation of SSMS also installs Azure Data Studio.
- Always Encrypted: To recognize the new HSM endpoints, you need to upgrade SSMS. This is done by consuming the new AKV Provider NugetPackage.
- Import Flat File: Made an improvement to better predict data types by learning on 300 lines by default.
- Import Flat File: Prevent columns from being declared as TinyInt that should be SmallInt.
- Import Flat File: Made an improvement where DW tables are properly cleaned, if there is a failure in data import.
- Resource Governor: Added support for decimal values.
- ShowPlan: Added PREDICT operator.
- XEvent UI: Added capability to script out Extended Events using the wait_type name. Users are requesting to use the value of map_value column instead of map_key in wait_type filter predicate as the key value is subjected to change during version upgrade. Fix: Added a checkbox and given the option to users, to choose either map_value or map_key for the wait_type filter predicate value.

Fixed:
- Accessibility: Fixed tab ordering of buttons in the "The following settings are not supported by the database" window that pops up when querying against DW.
- Accessibility: Import and Export Wizard: the page layout is incorrect in high dpi mode.
- Activity Monitor: Fixed an issue where Activity Monitor was pausing when opening the "Processes" tab. See SQL Server User Feedback.
- Always On Availability Group: Fixed an issue where Read Scale Availability Group Failover was not working.
- Analysis Services: Updated PowerQuery components to 2.84.982 for AS Tabular models scenarios.
- Analysis Services: Fixed an issue that may have resulted in an error when trying to connect to SSAS via msmdpump.dll. See SQL Server User Feedback.
- Backup/Restore  Fixed an issue where selecting "View Connection Properties" yielded a SMO error on HostDistribution prop being missing for SQL 2016 and earlier.
- Database Designer: Fixed an issue, which was causing SSMS to crash when handling decimal numbers.
- Database Diagrams: Fixed an issue that could cause SSMS to crash or hang when using Database Diagrams where "Add Table" dialog was not properly displayed.
- Database Mirroring: Fixed an issue that was causing mirror configuration to fail. See SQL Server User Feedback.
- General SSMS: Fixed an issue where trying to connect to an Azure SQL DB, which could take several seconds (SQL login in a user database).
- General SSMS: Fixed an issue where SSMS was not handling/displaying deadlock captured (.xdl files).
- General SSMS: Fixed an issue where trying to open error log settings for SQL Server 2008 R2 and below failed with ErrorLogSizeKb property not found.
- General SSMS: General fixes and improvements around Azure Synapse Analytics SQL on-demand support.
- Import Flat File: Fixed an issue where the wizard was not detecting that the file could be in use by another application and instead was throwing an error. See SQL Server User Feedback.
- Import/Export Data-Tier Application: Fixed the default service tier to be Standard S0 when importing a bacpac (same as Azure portal and SqlPackage.exe behavior).
- Import Flat File: Fixed an issue where the wizard was not detecting that the file could be in use by another application and instead was throwing an error. See SQL Server User Feedback.
- Integration Services: Fixed an issue that Azure Subscription ComboBox items are duplicate in IR Creation Wizard and Job Migration Wizard when different subscriptions have the same name.
- Integration Services: Fixed an issue that sometimes Connect button cannot be enabled in IR Creation Wizard.
- Integration Services: Fixed an issue that items of "Use Environment variable" ComboBox in "Set Parameter Value" dialog are not in order.
- Intellisense: Fixed a crash in SSMS that could happen when executing a query.
- Intellisense: Fixed an issue where intellisense doesn't work when the user is connected to an Availability Group configured for Read-Only Routing.
- Linked Servers: Fixed an issue where a user with CONTROL SERVER permission (but not in sysadmin role) was not able to add a linked server.
- Log Viewer: Fixed an issue where a user with VIEW SERVER STATE permissions was not able to view the SQL Server Error Logs. See SQL Server User Feedback.
- Object Explorer: Fixed an issue where selecting the Start PowerShell menu on some Object Explorer nodes (like "Policy Management", "Extended Events") would cause PowerShell not to start correctly.
- Registered Servers: Fixed an issue where SSMS crashed when trying to register a Central Management Server.
- Registered Servers: Fixed the issue where menu items to launch Azure Data Studio from Registered Servers was missing.
- Reports: Fixed an issue where on the Performance Dashboard you try to navigate to sublinks (such as Expensive Queries) and it doesn't work. This issue was common on most non-English versions of SSMS. See SQL Server User Feedback.
- ShowPlan: Fixed and issue that was causing SSMS to crash when using Find Node to search for text. See SQL Server User Feedback.
- ShowPlan: Add KB suffix on the Memory Grant tooltip row
- Vulnerability Assessment: Fixed an issue that was causing SSMS to throw an error when trying to set baselines in Vulnerability Assessment. See SQL Server User Feedback.
- XEvent UI: Fixed the issue where hitting F1 was not landing on the correct page on DOCS.
- XEvent UI: Fixed log in XEvent Viewer where the tooltip was not displaying correctly text containing text encoded using surrogate pairs.