SQL Server Management Studio – July 2016 Release

SQL Server

Microsoft has announced the first monthly update of SQL Server Management Studio (SSMS) following the release of SQL Server 2016. This fully-supported release is available for download here.

New or Updated Features:

  • Support for Azure SQL Data Warehouse in SSMS.
  • Significant updates to the SQL Server PowerShell module. This includes a new SQL PowerShell module and new CMDLETs for Always Encrypted, SQL Agent, and SQL Error Logs.
  • Support for PowerShell script generation in the Always Encrypted wizard.
  • Significantly improved connection times to Azure SQL databases.
  • New “Backup to URL” dialog to support the creation of Azure storage credentials for SQL Server 2016 database backups. This provides a more streamlined experience for storing database backups in an Azure storage account.

  • New Restore dialog to streamline restoring a SQL Server 2016 database backup from the Microsoft Azure storage service. The dialog eliminates the need to memorize or save the Shared Access signature for an Azure storage account in order to restore a backup.

  • Improved support for SQL Server 2016 (1200 compatibility level) tabular databases in the Analysis Services Process dialog.
  • Bug fix in SSMS query designer to allow adding tables to the designer if a user doesn’t have SELECT permissions on them.
  • Bug fix in PowerShell module to enable loading of “SQLAS” extension.
  • Bug fix in the SSMS editor window to allow drag-and-drop open of Sql files.
  • Bug fix in Profiler to fix Profiler crash when exiting.
  • Bug fix in SSMS to prevent crash when trying to edit a join link in the SSMS table designer.
  • Bug fix in SSMS to enable database script generation for db_owner role members.
  • Bug fix in SSMS editor to remove the delay in closing a query tab if the server has gone offline.
  • Bug fix to enable Backup option in SQL Server Express databases.
  • Bug fix to add IntelliSense support for “TRY_CAST()”, and “TRY_CONVERT()” functions.
  • Bug fix in Analysis Services to correctly show the Data Feed provider for multi-dimensional Analysis Services models.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

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