10/09/2019
Keep your SQL Management Studio up to date!
Microsoft just released version 18.3.1
What's new in 18.3.1
Data Classification
Add Data Classification information to column properties UI (Information Type, Information Type ID, Sensitivity Label, and Sensitivity Label ID are not exposed in the SSMS UI).
Intellisense/Editor
Updated support for features recently added to SQL Server 2019 (for example, "ALTER SERVER CONFIGURATION").
Integration Services
Add a new selection menu item Tools > Migrate to Azure > Configure Azure-enabled DTExec that will invoke SSIS package ex*****ons on Azure-SSIS Integration Runtime as Execute SSIS Package activities in ADF pipelines.
SMO/Scripting
Added support for Support scripting of Azure SQL DW unique constraint.
Data Classification
- Added support for SQL version 10 (SQL 2008) and higher.
- Added new sensitivity attribute 'rank' for SQL version 15 (SQL 2019) and higher and Azure SQL DB.
SMO/Scripting
SQL Assessment API - Added versioning to ruleset format.
SQL Assessment API - Added new checks.
SQL Assessment API - Added support for Azure SQL
Database Managed Instance.
SQL Assessment API - Updated default view of cmdlets to display results as a table.
Bug fixes in 18.3.1
Analysis Services
Fix scaling issue in MDX Query Editor.
Fixed an issue in XEvent UI that prevents the users from being able to create a new session.
Database Deployment to SQL Azure
Fixed an issue (in DacFx) which was causing this feature not to work.
General SSMS
Fixed an issue, which was causing SSMS to crash when using the sorting feature in the XEvent viewer.
Fixed long outstanding issues where SSMS Restore database may hang indefinitely.
Restore Database - Select Backup Devices Slow to Load.
SSMS 2016 very slow in the database restore dialog.
Restoring database is slow.
Restore Database from Device HANGS on clicking "...".
Fixed an issue where the default language for all logins was shown as Arabic.
Fixed the hard to see the dialog for Query Options (when the user right-clicks on the T-SQL editor window) by making it re-sizable.
The Completion time message visible in the Result Grid/File (introduced in SSMS 18.2) is now configurable under Tools > Options > Query Ex*****on > SQL Server > Advanced > Show completion time.
In the connection dialog, replaced Active Directory - Password and Active Directory - Integrated with Azure Active Directory - Password and Azure Active Directory - Integrated, respectively.
Fixed an issue that prevents users from being able to use SSMS to configure auditing on SQL Azure-Managed Instances when located in a TZ with negative UTC offset.
Fixing an issue in XEvent UI where hovering over the grid was causing rows to be selected.
Import flat file
Fixed the issue where Import Flat File was not importing all data by letting the user choose between a simple or rich data type detection.
Integration Services
Add new operation type StartNonCatalogEx*****on for SSIS Operation report.
Fixed an issue in the Azure Data Factory pipelines generated by Azure-enabled DTExec utility to use the correct parameter type. (explicit for 18.3.1)
Fixed an issue, which was causing SMO to throw errors when fetching properties when SMO.Server.SetDefaultInitFields(true) was being used.
Fixed an issue where the Y-axis did not scales when Ex*****on Count Metric was selected in Tracked Query View.
Vulnerability Assessment
Disabled clearing and approving baseline for Azure SQL DBs.
Known issues (18.3.1)
Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes).
There are redraw issues when switching between multiple query windows. See UserVoice for more details. A workaround for this issue is to disable hardware acceleration under Tools > Options.
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier compone...
