Latest Builds of SQL Server Management Studio (SSMS)

Community Team

Published On: September 24, 2019

Categories: Management Studio, SSMS, SQL Server 11

Management Studio is now a completely standalone product, not tied to any specific version or edition of SQL Server, and no longer requires licensing of any kind. You can read about some of the major changes to this new release cycle approach here:

You should also note that there is a new, much more aggressive support policy for SSMS, meaning you will want to stay up to date. If you contact Microsoft about an issue with a build that is a point release behind, they will just tell you to upgrade:

And you can always download the latest releases here:

Typically, you should expect a new build about every 30 days, though as you can see below they will sometimes sneak out an out-of-band release (or take a little longer, such as when 17.0 came out of RC). People seem to be quite happy dealing with this faster-paced delivery model, even though during the beta cycles it comes with the risk of an occasional setback and waiting a few days for a fix. To me this is way better than the old model, where sometimes we would wait months or years for any change at all.

Label Build # Date Released
18.3 15.0.18178.0 2019-09-23
18.2 15.0.18142.0 2019-07-25
18.1 15.0.18131.0 2019-06-11
18.0 15.0.18118.0 2019-04-24
18.0 Private 15.0.18116.0 2019-04-18
18.0 RC1 15.0.18098.0 2019-03-28
18.0 Preview 7 15.0.18092.0 2019-03-01
18.0 Preview 6 15.0.18075.0 2018-12-18
18.0 Preview 5 15.0.18068.0 2018-11-15
18.0 Preview 4 15.0.18040.0 2018-09-24

The nicest thing about the latest releases, other than the rapid release cycle? Beta support for HiDPI (e.g. 4K) screens. (Here's Aaron Bertrand's take on it and an update for SSMS 18.2.)

Previous Versions

Microsoft has made it a little bit easier to find previous supported releases of Management Studio by putting up a download page here. It will continue to offer the latest builds for SQL Server 2012 and SQL Server 2014 for as long as they are supported, but with two active branches in development (and with 16.5 all but ceasing, with the focus on 17.0), you should not expect many new updates outside of any remaining service packs that will be released.

This page doesn't offer anything in the 2005, 2008, or 2008 R2 flavors though. The following table has a link to the latest known publicly available download if you need 2008/2008 R2 SSMS support for things like SSIS packages. You can install this older release side-by-side with 2012, 2014, or the new branch. Not sure there is any plausible reason to choose 2012, 2014, or 2016 over the new branch, but if that's what you want to do, you can.

Version Build # Date Download
SSMS 17.9.1 14.0.17289.0 2018-11-21 Download
SSMS 16.5.3 13.0.16106.4 2017-01-26 Download
SQL Server 2014 (SP1) 12.0.4100.1 2015-05-14 Download
SQL Server 2012 (SP3) 11.0.6020.0 2015-11-21 Download
SQL Server 2008 R2 (SP2) 10.50.4000 2012-07-02 Download
The 2008 R2 link takes you to the 2008 R2 Express download page. When you click "Download" on that page, you'll have some choices; for SSMS you want SQLManagementStudio_x64_ENU.exe or, if your hardware is from last century, SQLManagementStudio_x86_ENU.exe.

It may be possible, of course, to get a later build of SSMS by subsequently applying newer service packs, but it is not something we've gotten around to testing.

Azure Data Studio

The latest version of Azure Data Studio can be downloaded here, and the release notes are here.

SQL Server Data Tools

The latest builds of SSDT can be downloaded here. The changelogs are available here (Visual Studio 2017 | Visual Studio 2015).

These posts are provided by the collective SentryOne team!