On October 27, 2020, Microsoft released SQL Server Management Studio (SSMS) 18.7.1. This is a minor bug fix release after SSMS 18.7. You can download SSMS 18.7.1 here.
SSMS 18.7.1 Released
SQL Server Management Studio (SSMS) is Build number 15.0.18358.0. Like all recent 18.x releases, it is a single download that can be used for a fresh SSMS 18.7.1 installation. It can also upgrade any previous 18.x GA version to SSMS 18.7.1. The full release notes are here.
One big change with SSMS 18.7 is described by Microsoft this way:
“Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. Users of SQL Server Management Studio are now able to benefit from the innovations and features in Azure Data Studio. Azure Data Studio is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid.“
So far, this has been a pretty controversial change. Erik Darling created a User Voice suggestion on October 20th that has already gotten over 234 votes, and many comments.
The general consensus (which I agree with) seems to be that it is ok to offer ADS as an optional installation as part of SSMS, but not being able to opt out of the ADS installation will create problems for some organizations.
Duplicate Azure Data Studio Installations
One minor issue that this bundling creates is that you are very likely to end up with duplicate ADS installations on a machine. If you have followed Microsoft’s guidance by downloading and installing the User Installer version of ADS, you will see an entry called Azure Data Studio (User). The bundled copy of Azure Data Studio that SSMS 18.7 installs is a System Installer version.
You also might have an older version of ADS that you previously installed with the User Installer. SSMS 18.7 (and 18.7.1) will just install the System Installer version of ADS 1.23.0. The User Installer and System Installer versions are completely separate.
So, this means that you can easily end up with two separate copies of ADS that you may not know about. This is not a huge problem, since you can quickly and easily uninstall either or both copies of ADS without affecting SSMS at all. But this does create extra complexity and more work.
I am curious about what will happen when the next version of ADS is released (sometime in November). I am guessing that it will do version checking against whatever copy you have (User or System) and are trying to install (User or System), and not let you overwrite a newer version with an older version.
SSMS Release Cadence
SQL Server Management Studio has been on a somewhat erratic release cycle over the past two years. Despite some recent guidance about a bi-monthly cadence, we seem to be settling in to a quarterly release cycle.
|SSMS Version||Release Date|
|18.7.1||Oct 27, 2020|
|18.7||Oct 20, 2020|
|18.6||Jul 22, 2020|
|18.5.1||Jun 9, 2020|
|18.5||Apr 7, 2020|
|18.4||Nov 4, 2019|
|18.3.1||Oct 2, 2019|
|18.2||Jul 25, 2019|
|18.1||Jun 11, 2019|
|18.0||Apr 24, 2019|
|17.9.1||Nov 21, 2018|
Despite all the attention (and regular monthly releases) that Azure Data Studio (ADS) gets, SSMS is a very useful tool that is still better than ADS for pure database administration work. I am very happy to see SSMS getting a little more attention from Microsoft.
If you have any suggestions for SSMS, Microsoft is openly soliciting feedback on SSMS on User Voice for SQL Server.
If you have any questions about this post, please ask me here in the comments or on Twitter. I am pretty active on Twitter as GlennAlanBerry. Thanks for reading!