If you use SQL Server database to host the SSIS catalog database (SSISDB), you can use this SSMS feature to generate the Data Factory pipelines, activities, and triggers that are required to schedule SSIS packages.
This new SSMS feature provides a familiar user interface (UI) that resembles SQL Server Agent for scheduling packages that are deployed to a SQL Server database. Unlike SQL Server on-premises and SQL Database Managed Instance (Preview), which have SQL Server Agent as a first-class job scheduler, SQL Database does not have a built-in scheduler. You can now monitor replication environments where the publisher database or distribution database is part of an Always On Availability Group.Īdds “Rejected Row Location” support for external tables in Azure SQL Data Warehouse.Īdds a scheduling feature for SQL Server Integration Services (SSIS) packages that are deployed to an Azure SQL database. Replication monitor now supports registering a listener for scenarios where the publisher database or distributor database is part of an Availability Group. This update includes the following improvements: It provides the greatest level of support for the latest cloud features in Azure SQL Database and Azure SQL Data Warehouse.
This version of SQL Server Management Studio (SSMS) works with all supported versions of SQL Server 2008 through SQL Server 2017.
