skip to Main Content

SQL Tools 2020 Release Roundup

SQL Server Management Studio (SSMS)

SQL Server Management Studio had four releases in 2020, and a lot of the known issues have now been resolved. As well as bug fixes, this release (v18.8) brought us a few new items:

  • Azure Data Studio installation integration: Installation of SSMS installs Azure Data Studio 1.25.1.
  • Analysis Services: Added support for Power BI Premium Gen2 workspaces.
  • Auditing: Added support for EXTERNAL_MONITOR and “operator audit”.
  • Integration Services: Improved IR Creation Wizard such that creating SSISDB is optional when creating SSIS IR.

Release Notes, which show a full list of bug fixes: https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms

Download: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

Azure Data Studio

Don’t forget that since version 18.7, Azure Data Studio is included with SQL Server Management Studio.

You can learn more about this change here: https://cloudblogs.microsoft.com/sqlserver/2020/10/20/sql-server-management-studio-18-7-now-generally-available/ or in the section “Installation with Azure Data Studio” in the download documentation above.

Azure Data Studio v1.25 also came out in December and you can see the release notes here: https://cloudblogs.microsoft.com/sqlserver/2020/12/17/sql-tools-december-release-recap/

Post Terms: Microsoft Data Platform | SQL | updates

About the Author

Leah Monterroso

Marketing Manager, Leah Monterroso, has been writing blogs and articles for the last six years. Since working with Ballard Chalmers, she has immersed herself in Microsoft tech news and bringing value to clients and the wider community through content.

You can find Leah online at:

Back To Top