This week we see an update for SQL Server Management Studio, version 18.1. This release is the latest generation of SQL Server Management Studio and provides support for SQL Server 2017.

What’s New in this Release

  • Database diagrams – Database diagrams were added back into SSMS. If you did not know they removed this from the 18.0 release. For more details, see Database Diagrams.
  • SSBDIAGNOSE.EXE – The SQL Server Diagnose command line tool was added back into the SSMS package.
  • Integration Services (SSIS) – Support for scheduling SSIS package, located in SSIS Catalog in Azure or File System, in Azure. There are three entries for launching the New Schedule dialog, New Schedule… menu item shown when right-clicking the SSIS package in SSIS Catalog in Azure, Schedule SSIS Package in Azure menu item under Migrate to Azure menu item under Tools menu item and “Schedule SSIS in Azure” shown when right-clicking Jobs folder under SQL Server agent of Azure SQL Database Managed Instance.

For details about what’s new in this release, please see the SSMS release notes.

Getting the Update

Head over to https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms and go to the Download SSMS 18.1 section.

Version Information

  • Release number: 18.1
  • Build number: 15.0.18131.0
  • Release date: June 11, 2019

NOTE: SSMS 18.1 is the latest general availability (GA) version of SSMS. If you have SSMS 18.0 (GA) installed, installing SSMS 18.1 upgrades it to 18.1. If you have an older preview version of SSMS 18.0 installed, you must uninstall it before installing SSMS 18.1.

Supported SQL Offerings

This version of SSMS works with all supported versions of SQL Server 2008 – SQL Server 2019 preview and provides the greatest level of support for working with the latest cloud features in Azure SQL Database and Azure SQL Data Warehouse.

Additionally, SSMS 18.x can be installed side by side with SSMS 17.x, SSMS 16.x, or SQL Server 2014 SSMS and earlier.

Enjoy!

References

Download SQL Server Management Studio (SSMS)

SQL Server Management Studio – Changelog (SSMS)

Posted by Callon Campbell [MVP]

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s