Latest Builds of Management Studio - SentryOne Team Blog

Latest Builds of Management Studio

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.

17.x / 18.x
Label Build # Date Released
18.0 Preview 5 15.0.18068.0 2018-11-15
18.0 Preview 4 15.0.18040.0 2018-09-24
17.9.1 14.0.17289.0 2018-11-21
17.9 14.0.17285.0 2018-09-04
17.8.1 14.0.17277.0 2018-06-26
17.8 14.0.17276.0 2018-06-21
17.7 14.0.17254.0 2018-05-09
17.6 14.0.17230.0 2018-03-20
17.5 14.0.17224.0 2018-02-15
17.4 14.0.17213.0 2017-12-07
17.3 14.0.17199.0 2017-10-09
17.2 14.0.17177.0 2017-08-07
17.1 14.0.17119.0 2017-05-24
17.0 14.0.17099.0 2017-04-25
17.0 RC3 14.0.17028.0 2017-03-09
17.0 RC2 14.0.16150.0 2017-02-01
17.0 RC1 14.0.16000.64 2016-11-16

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

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 Service Pack Build # Date Download
SSMS 16.5.3 N/A 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.

SQL Server Data Tools

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

New call-to-action

Comments ( 11 )

Leave A Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.