Easy-to-use graphical management tool for managing SQL Server

SQL Server Management Studio

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe
Download SQL Server Management Studio 18.7

  -  635 MB  -  Freeware

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.

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe