There is a new release of SQL Server Management Studio (SSMS) now available – version 17.0. It feels like yesterday when SSMS 16 was released (June 2016). I’m not going to complain as it’s refreshing to see such the constant updates to SSMS now that it’s not tied in with the database engine installer.
To get the latest version, head to the download page and install the web-installer. SSMS 17 will install side-by side with previous versions of SSMS.
This latest release includes a lot of new functionality, namely with support for connecting to SQL Server on Linux. Please see the full SSMS changelog for a complete listing of enhancements and bug fixes. Sadly this release still doesn’t support the Dark theme. Hopefully this is something they add in a future release.
Installing SSMS 17:
Updated splash screen:
SSMS 17 icons have been updated to be consistent with VS Shell provided icons and support High DPI resolutions:
One of the nice additions to this release is the inclusion of “Presentation Mode”. There are 3 new tasks available via the Quick Launch (Ctr-Q):
- PresentOn – Turns on presentation mode where the editor and environment fonts are larger
- PresentEdit – Allows you to edit the presentation font sizes
- RestoreDefaultFonts – Reverts back to the default settings
If you are familiar with these commands in Visual Studio then you will notice that there is currently no PresentOff command. Use RestoreDefaultFonts to turn off Presentation Mode.
Download SQL Server Data Tools (SSDT)
SSMS Release Notes
Is Utility Explorer missing from SSMS 17 or just hidden?