Partilhar via

Announcing SQL Server Management Studio - July 2016 Release

  • Artigo

Today, we are very pleased to announce the first monthly update of SQL Server Management Studio (SSMS) following the SQL Server 2016 release. This update remains a fully-supported generally-available (GA) quality release. It includes support for Azure SQL Data Warehouse, significant updates to SQL Server PowerShell and numerous fixes for customer-reported defects.

Get it here: Download SSMS July 2016 release

  • The version number for the latest release is 13.0.15500.91

New in this release

  1. Edit, July 6th:  This release of SSMS enables the 'XACT_ABORT' option in SSMS by default. This option instructs SQL Server to rollback the entire transaction and abort the batch if a run-time error occurs. You can disable this option in the SQL Server Query Execution options dialog page.
  2. Edit, July 6th:  Improved support for SQL Server 2016 (1200 compatibility level) tabular databases in the Analysis Services Process dialog and the Analysis Services Deployment wizard..
  3. Support for Azure SQL Data Warehouse in SSMS.
  4. 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. You can find out more in the SQL PowerShell update blogpost.
  5. Support for PowerShell script generation in the Always Encrypted wizard.
  6. Significantly improved connection times to Azure SQL databases.
  7. 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.
  1. 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.
  2. Bug fix in SSMS query designer to allow adding tables to the designer if a user doesn’t have SELECT permissions on them.
  3. Bug fix in PowerShell module to enable loading of ‘SQLAS’ extension (Microsoft Connect item #2544902).
  4. Bug fix in the SSMS editor window to allow drag-and-drop open of Sql files (Microsoft Connect item #2690658).
  5. Bug fix in Profiler to fix Profiler crash when exiting. (Microsoft Connect item #2616550).
  6. Bug fix in SSMS to prevent crash when trying to edit a join link in the SSMS table designer (Microsoft Connect item #2721052).
  7. Bug fix in SSMS to enable database script generation for db_owner role members. (Microsoft Connect item #2869241).
  8. Bug fix in SSMS editor to remove the delay in closing a query tab if the server has gone offline (Microsoft Connect item #2656058).
  9. Bug fix to enable Backup option in SQL Server Express databases (Microsoft Connect item #2801910).
  10. Bug fix to add IntelliSense support for 'TRY_CAST()', and 'TRY_CONVERT()' functions (Microsoft Connect item #2453461).
  11. Bug fix in Analysis Services to correctly show the Data Feed provider for multi-dimensional Analysis Services models.

Please visit the SSMS download page for additional details, and to see the full changelog.

Known Issues

The full list of known issues is available in Release notes available here.

Contact us

As always, if you have any questions or feedback, please visit our forum or Microsoft Connect page. You can also tweet our Engineering Manager at @sqltoolsguy on Twitter. We are fully committed to improve the SSMS experience and look forward to hearing from you!

Comments

  • Anonymous
    July 02, 2016
    The comment has been removed
  • Anonymous
    July 02, 2016
    AFAIK SSMS 2016 also installs some features and drivers from SQL SERVER 2016. So the SQL Server 2016 Import/Export Wizard is installed side by side to SQL Server 2014. Trying to use Import/Export 2016 shows 2 problems:1. The Wizard cannot save the IS-pack generated for an import/export task because it behaves as an "Express" version.2. The new wizard offers an Import from EXCEL 2013/2016 option, which is great, but the neccessary provider is not installed. This results in message "The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data)". Installing "Access 2013 Runtime" is a workaround.Bugs or features?
  • Anonymous
    July 03, 2016
    good
  • Anonymous
    July 05, 2016
    The bug regarding opening the "Help Viewer" is still here on this version 13.0.15500.91* Full information:http://ariely.info/Blog/tabid/83/EntryId/178/SSMS-2016-Help-viewer-bugs-and-workarounds.aspxThere are two open connects regarding the issue, which did not get any response from Microsoft team at this time (links to the connects and to forum thread regarding the issue are in the link above).
  • Anonymous
    July 05, 2016
    I am still unable to connect to my Azure SQL Database (V12) and see the list of tables. The Object Explorer connects, and then expanding the database's tables just gives me the two folders "System Tables" and "External Tables". I am still able to query the database with SQL but the table browser is broken. SSMS 2014 works just fine.
  • Anonymous
    July 06, 2016
    Any news about the dark theme?
  • Anonymous
    July 07, 2016
    The comment has been removed
    • Anonymous
      July 21, 2016
      The comment has been removed
  • Anonymous
    July 07, 2016
    When you right-click a table, the "design" Option is no longer available. Also, when you create a new table, the designer does not open but a strange "adventureworks" script opens. Is it a bug? I do not like this Version at all, and went back to the june Version.
    • Anonymous
      September 01, 2016
      I see the designer when I choose New Table, and I see Design in the menu options. Does it depend on what version of SQL you are connected to?