Note that SSMS is now allowing viewing ( View button) an output_file whose name is tokenized (at least for the simple macros/tokens supported by SQL Agent that are not determined at runtime).

Fixed an issue where trying to edit a SQL Agent job step could have resulted in the SSMS UI freezing.

Fixed an issue where OE was very slow in expanding tables for databases with several thousands of tables (over 20,000).

Fixed an issue where an error was displayed when trying to display the dashboard when connected to a Big Data Cluster endpoint.

Fixed an issue where the first database added to Always On AG does not join correctly.

We also have several bug fixes in various areas of general shell improvements, DPI and scaling, accessibility, and more.

Profiler: added support for AS Trace Definition 15.1.

Added support for PowerBI endpoint in AS, matching functionality of asazure.

Instead, it keeps packages in the projects as they are in SSISDB except changing protection level to EncryptSensitiveWithUserKey. Compared with the old Export, which loaded and upgraded packages in the SSIS project, the new version independent Export won’t load and upgrade packages in the SSIS project.

Made an improvement for the user experience of exporting SSIS projects from SSISDB.

Support migrating on-premise SSIS agent jobs to ADF pipelines and triggers.

Support connecting Azure-SSIS integration runtime and managing or executing SSIS packages in package stores.

Made user-friendly improvements in configuring Azure-enabled DTExec to invoke SSIS package executions on Azure-SSIS Integration Runtime.

Support executing SSIS Package from file system in MI Agent Job.

This change adds missing Azure Editions to our Dac wizards, particularly support for Hyperscale.

Added support for “Import Data-Tier Application” (.bacpac) to SQL Azure HyperScale.

Added support for sensitivity rank in Data Classification.

SQL Assessment API – Platform, Name, and Engine Edition fields can now contain usual comma-separated lists (“platform”: ), not only regular expressions (“platform”: “/Windows|Linux/”).

Added “Notebook” as a destination for Generate Scripts wizard.

You can download SQL Server Management Studio 18.5 today and review SSMS Release Notes for full details.Ī glimpse into some of the interesting changes for this release include, but are not limited to: New features in SQL Server Management Studio We have some feature updates as well as important behind the scenes updates. Today, we’re sharing the release of SQL Server Management Studio (SSMS) 18.5.

Sql management studio