SSMS 16.3 disponible


Ya se encuentra disponible la nueva versión del SSMS (SQL Server Management Studio)

 

  • SSMS monthly releases are now branded numerically not by months.
  • New authentication option ‘Active Directory Universal Authentication’. This is a token-based authentication mechanism driven by Azure Active Directory that supports multi-factor, password, and integrated authentication mechanisms. Learn more about Active Directory Universal Authentication.
  • New Extended Events templates matching the functionality of SQL Server Profiler templates (Microsoft Connect item #2543925). Learn more about the included SQL Server Profiler templates.
  • New ‘Get-SqlLogin’ and ‘Remove-SqlLogin’ cmdlets to help perform SQL Server login management using PowerShell(Microsoft Connect item #2588952).
  • New PowerShell cmdlet ‘New-SqlColumnMasterKeySettings’ that adds support for creation of column master keys for arbitrary providers and key paths.
  • New ‘Create database’ dialog to streamline creation of Azure SQL databases in SSMS.
  • Support for filtering in the ‘Databases’ node of SSMS Object Explorer. Navigate to the ‘Databases’ node in Object explorer and click the filter icon in the Object explorer toolbar to filter the list of databases.
  • Support for Azure-Resource Manager (ARM) type storage accounts in the Backup and Restore wizards.
  • Initial beta support for high-resolution displays (Microsoft Connect item #1129301).
  • Improvements in Database Engine Tuning Advisor (DTA) to support automatically reading a workload from the SQL Server Query Store.
  • Improvements in Database Engine Tuning Advisor (DTA) to display index recommendations for clustered columnstore indexes, non-clustered columnstore indexes, and rowstore indexes.
  • Support for sending Database Console (DBCC) commands using SQL Server Analysis Services PowerShell cmdlets.
  • Bug fix to view cleartext of decrypted AlwaysEncrypted large object (LOB) columns in SSMS (Microsoft Connect item #2413024).
  • Bug fix in Always Encrypted dialog to fix crash when Windows visual styles are not enabled (e.g. enabling high contrast display).
  • Bug fix for ‘Method not found’ error preventing connection to SQL Server instances.
  • Bug fix for SSMS crash when creating a partition function with datetime offset.
  • Bug fix to remove Microsoft .NET 3.5 requirement for starting Distributed Replay administration tool (DReplay.exe).
  • Bug fix in Analysis Services Deployment wizard to support fully-qualified server names.
  • Bug fix in SSMS to display partitions in Analysis Services tabular models with a 2016 compatibility model (Microsoft Connect item #2845053).
  • Performance improvements and bug fixes in Analysis services tabular models, and SQL Server Shared Management Objects (SMO).