An Update to SQL Server Management Studio is Available

August 9, 2017

image

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.

image

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:

image

Starting the Installation

Installation is quick and easy…

sshot-8

sshot-9

sshot-11

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:

image

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.

Enjoy!

References

Download SQL Server Management Studio (SSMS)

SQL Server Management Studio – Changelog (SSMS)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

PowerShell, Programming and DevOps

Musings and mischief on PowerShell, Programming and DevOps.

toon vanhoutte

Blogging about connecting devices, systems and people! On-premises and in the cloud. Microsoft stack only.

Ken Cenerelli

My life in software development

scomfaq.wordpress.com/

Things about System Center and Cloud...

Build HoloLens

All about HoloLens

DevDays®

For web designers and cloud developers

Build Azure

All about the Microsoft Cloud

vishal patel

Software Developer, Windows 8 and Windows Phone Enthusiast

SQL with Manoj

SQL Server (TSQL) Programming, DB concepts, Tips & Tricks with >400 articles... comments welcome!!!

dragablz.wordpress.com/

Dragable, tearable, dockable WPF TabControl. Open source to boot.

Adrian Hall

Because Developers are Awesome

Ratish Philip's Blog

Another adventure in code...

codematrix

Application Architecture at it's best

One Unicorn

Thoughts from one member of the Entity Framework team...

Rachel Lim's Blog

Simplifying programming into something I can understand

.NET Developer's Blog

Software Development, Flying and Life

The Flying Maverick

Software Development, Flying and Life

Hiking Photography

Beautiful photos of hiking and other outdoor adventures.

paint.net blog

The best image and photo editor. By Rick Brewster.

%d bloggers like this: