Monday, July 4, 2016

New update to SQL Server Management Studio (July 2016)

This is an update to the SSMS. This post describes the previous update.

The following change log shows the changes made in this update as itemized on Microsoft site. The bug fixes, quite a few of them have also been applied. Go to this URL to view the complete document as well as to download this update. If you already had the previous version, you may be asked to upgrade to this version when you launch SSMS.

Changelog

  • 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.
  • Improved support for SQL Server 2016 (1200 compatibility level) tabular databases in the Analysis Services Process dialog.