Categories: SQL Server

The Future of SSMS

One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a separate installation. You heard that right (read, probably), no more dragging along those bulky .ISO files with the entire SQL Server set-up just to install some client tools. Just like SSDT, you can now just download Management Studio from the interwebs.

What’s even better is that you can now also get automatic updates! I opened SSMS and suddenly I got a lovely notification in my system tray that there are updates for SSMS. Isn’t that great? Clicking on it gave me the following dialog:

Nice. Don’t get too cocky though, clicking the Update button just takes you to an MSDN download page where you can download the latest version. Baby steps.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

View Comments

Recent Posts

Power BI PBIR Format Admin Setting

The Power BI Enhanced Report Format (PBIR) will soon become the default, and that's a…

5 days ago

Logged in as a member of an Azure AD Group Error while Deploying DACPAC

Quite a long title for a short blog post :)While deploying a DACPAC (from a…

1 week ago

Export a Power BI Report that cannot be Downloaded

Yes, you're reading that right, we're going to download a report that cannot be downloaded.…

2 weeks ago

dataMinds Connect 2025 – Slides & Scripts

You can find all the session materials for the presentation "Indexing for Dummies" that was…

2 months ago

Cloud Data Driven User Group 2025 – Slides & Scripts

The slidedeck and the SQL scripts for the session Indexing for Dummies can be found…

2 months ago

Retro Data 2025 – Slidedeck

You can find the slides of my session on the €100 DWH in Azure on…

2 months ago