SQL Server Management Studio nun 17.6 Sürümü Yayınlanmıştır.

Bu Sürüm ile birlikte Azure Manage Instance Desteğide gelmiş oldu.

Aşağıdaki adresten SSMS 17.6 sürümünü indirebilirsiniz.

İNDİR : https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

 

Genel Yenilik Listesi :

What’s new

General SSMS

SQL Database Managed Instance:

  • Added a support for Azure SQL Database Managed Instance. Azure SQL Database Managed Instance (preview) is a new flavor of Azure SQL Database, providing near 100{6189a1005e4f6dc613b8beb03d694ce50f0902974162d6a7dea944a970422cc9} compatibility with SQL Server on-premises, a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for on-premises SQL Server customers.
  • Support for common management scenarios like:
    • Create and alter databases.
    • Backup and restore databases.
    • Importing, exporting, extracting and publishing Data-tier Applications.
    • Viewing and altering Server properties.
    • Full Object Explorer support.
    • Scripting database objects.
    • Support for SQL Agent jobs.
    • Support for Linked Servers.
  • Learn more about Managed Instances here.

Object Explorer:

  • Added settings to not force brackets around names when dragging & dropping from Object Explorer to Query Window. (User suggestions 32911933, and 32671051.)

Data Classification:

  • General improvements and bug fixes.

Integration Services (IS)

Bug fixes

General SSMS

Data Classification:

  • Fixed an issue in Data Classification which was causing newly added classifications to be displayed with stale information type and sensitivity label.
  • Fixed an issue where Data Classification was not working when targeting a server set to a case-sensitive collation.

Always On:

  • Fixed an issue in AG Show Dashboard where clicking on Collect Latency Data could result in an error when the server was set to a case-sensitive collation.
  • Fixed an issue where SSMS was incorrectly reporting an AG as Distributedwhen the Cluster service shuts down.
  • Fixed an issue when creating AG using Create Availability Group dialog the ReadOnlyRoutingUrl is required.
  • Fixed an issue when the primary is down and manually failover to secondary, a NullReferenceException will be thrown.
  • Fixed an issue when creating Availability Group using backup/restore to initialize a database, on the secondary replicas, the database files will be created in the default directory. The fix includes:
    • Add the data/log directory validator.
    • Only do the file relocation when the replica is on a different OS to the primary replica.
  • Fixed an issue where SSMS wizard doesn’t generate CLUSTER_TYPEoption, causing secondary join to fail.

Setup:

  • Fixed issue where trying to upgrade SSMS by installing the “upgrade package” was failing when SSMS was installed in a non-default location.

SMO:

  • Fixed performance issue where scripting tables on SQL Server 2016 and above could take up to 30 seconds (now, it’s down to less than 1 second).

Object Explorer:

  • Fixed an issue where SSMS could throw an exception like “Object cannot be cast from DBNull to other types” when trying to expand Managementnode in Object Explorer.
  • Fixed an issue where Start PowerShell was not detecting the SQLServer module when user-defined PS profile emitted output.
  • Fixed an intermittent hang that could occur when right-clicking a Table or Index node in Object Explorer.

Database Mail:

  • Fixed an issue where Database Mail Configuration Wizard was throwing an exception when trying to display/manage more than 16 profiles.

Analysis Services (AS)

  • Fixed as issue where modifying a data source on a 1400 compatibility level model in SSMS the changes are not saved to the server.

Integration Services (IS)

  • Fixed an issue where SSMS did not show SSIS catalog node and reports when connected to SQL Database Managed Instance

Known issues

There are currently no known issues this release.

Leave a Reply

Your email address will not be published. Required fields are marked *