


Auditing - Fixed an issue where the Audit logs merge window doesn't show all servers when there are too many items in the root of the container.Auditing - Fixed an issue where the Audit logs merges window crashes when there's a folder with an empty name in the root folder of the storage account.Always On - Fixed an issue where an error was displayed when trying to display the dashboard when connected to a Big Data Cluster endpoint.Always On - Fixed an issue where the first database added to Always On AG does not join correctly.Analysis Services - Fix cached connection when scripting in AS with AAD connection.Accessibility - Stretch database wizard: fixed an issue where the screen reader does not inform about the name of the query table when providing information about the table.Accessibility - SSIS ADF / New Schedule: fixed an issue where the focus order is not logical in the scan mode of narrator under New Schedule wizard.SMO/Scripting - SQL Assessment API - Added 13 assessment rules.SMO/Scripting - SQL Assessment API - Platform, Name, and engineEdition fields can now contain usual comma-separated lists (platform: ), not only regular expressions (platform: /Windows|Linux/).SMO/Scripting - Added support for SQL On Demand.SMO/Scripting - Added Notebook as a destination for Generate Scripts wizard.SMO/Scripting - Removed support for Feature Restriction (this preview feature has been removed from SQL Azure and SQL on-prem).SMO/Scripting - Added new DwMaterializedViewDistribution property to View object.Instead, it keeps packages in the projects as they are in SSIS DB except changing protection level to EncryptSensitiveWithUserKey.
DOWNLOAD MICROSOFT SQL STUDIO UPGRADE
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. Integration Services - Made an improvement for the user experience of exporting SSIS projects from SSIS DB.Integration Services - Support migrating on-premises SSIS agent jobs to ADF pipelines and triggers.Integration Services - Support connecting Azure-SSIS integration runtime and managing or executing SSIS packages in package stores.Integration Services - Made user-friendly improvements in configuring Azure-enabled DTExec to invoke SSIS package executions on Azure-SSIS Integration Runtime.Integration Services - Support executing SSIS Package from file system in MI Agent Job.Hyperscale - Added support for Import Data-Tier Application (.bacpac) to SQL Azure HyperScale.Data Classification - Added support for sensitivity rank in Data Classification.Data Classification - Added a button to the VA scan result view, in order to remediate data classification rule by going to the data classification pane.Analysis Services - Profiler: added support for Analysis Services Trace Definition 15.1.Analysis Services - Added support for Power BI endpoint in Analysis Services - matching functionality of Azure Analysis Services.De bijbehorende aankondiging ziet er als volgt uit: What's new in 18.5 Daarnaast kun je queries en scripts in elkaar zetten. Het biedt tools voor de configuratie, monitoring en ingebruikname van de verschillende data-tiercomponenten. Met SSMS kun je een Microsoft SQL-omgeving beheren, bijvoorbeeld een on-premise SQL Server, maar ook een Azure SQL Data Warehouse in de cloud. Microsoft heeft versie 18.5 van SQL Server Management Studio, vaak afgekort tot SSMS, uitgebracht.
