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/
