This week we see an update for SQL Server Management Studio, version 17.2. This release is the latest generation of SQL Server Management Studio and provides support for SQL Server 2017.
What’s New in this Release
- Multi-Factor Authentication (MFA)
- The connection dialog box now supports the following 5 authentication methods:
- Windows Authentication
- SQL Server Authentication
- Active Directory – Universal with MFA support
- Active Directory – Password
- Active Directory – Integrated
- Database import/export for DacFx wizard can now use Universal Authentication with MFA
- ADAL managed library used by Azure AD Universal Authentication with MFA was upgraded to version 3.13.9
- A new CLI interface supporting Azure AD admin setting for SQL Database and SQL Data Warehouse
- Output window has entries for queries run during expansion of Object Explorer nodes
- Enabled View designer for Azure SQL Databases
- Changes to the default scripting options for scripting objects from Object Explorer in SSMS
- Added support for National Clouds in "Restore from URL"
- QueryStoreUI reports now supports additional metrics (RowCount, DOP, CLR Time etc.) from sys.query_store_runtime_stats
- IntelliSense is now supported for Azure SQL Database
- Security: connection dialog will default to not trusting server certificates and to requesting encryption for Azure SQL Database connections
- General improvements around support for SQL Server on Linux
- Performance Dashboard server report now available as a default report
- Showplan node search allows searching in plan properties. Easily look for any operator property such as table name
For the full list of changes, see SQL Server Management Studio – Changelog (SSMS).
Getting the Update
Head over to https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms and you will find two links for installation. The first links downloads and installs SSMS 17.2 where as the second link will update an existing 17.x installation.
This update will not upgrade or replace SSMS versions 16.x or earlier. SSMS 17.x will install side by side with previous versions. If you have multiple SSMS versions installed than the latest is labeled as Microsoft SQL Server Management Studio 17 and has the following icon:
Starting the Installation
Installation is quick and easy…
After the installation is complete, when you open up SSMS 17.2 and look at the About dialog you will see the following components updated:
Sadly we still don’t have an official Dark theme for SQL Server Management Studio. I recall reading comments from the SQL team last year that they needed to do work on all the dialogs before releasing this theme. If the base SSMS IDE supports the Dark theme than just release it You can work on the dialogs as needed and provide them in future updates.