Download SQL Server Management Studio 17.9.1

Microsoft has released a new version of SQL Server Management Studio, often abbreviated to SSMS, with version number 17.9.1. With SSMS you can manage a Microsoft SQL environment, for example an on-premise SQL Server, but also an Azure SQL Data Warehouse in the cloud. It offers tools for the configuration, monitoring and commissioning of the different data tier components and you can also build queries and scripts. The corresponding announcement looks like this:

SSMS 17.9.1 is now generally available

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9.1. This is a minor update to 17.9 with the following important improvements:

• Occasionally, SSMS closes MFA query editor connections with no outstanding transactions. A simple way to repro this is as follows:
  • Open a New Query window in SSMS
  • Connect to Azure SQL DB with MFA
  • Create a global temp table, insert some data and run a SELECT from the table
  • After a few seconds, re-run the above SELECT statement
  • The Temp table may have been dropped, in certain scenarios.

  Based on a few CSS cases and the impact of these issues, we decided to release a minor update for the benefit of our customers.

• DAC Wizards: DacFX Import/Export fails with the below error during import:
  • Failed to connect to server sqlce.database.windows.net. (Microsoft.SqlServer.Smo).
• SSMS Restore plan: SSMS does not generate correct restore plan and picks up an older full backup, despite having newer full backups.
• SMO:Updated Microsoft.SqlServer.SqlManagementObjects NuGet package to include a readme.txt file.

As always, are always listening and would love to hear from you with any questions, comments or feature suggestions via the SQL Server Feedback Forum.