sql server management studio 17 configuration manager

#SQL SERVER MANAGEMENT STUDIO 17 CONFIGURATION MANAGER UPDATE#

The following fixes are included in this update:įixed an issue in which trying to change the schedule of an existing Maintenance Plan was throwing an exception. You can now create SQL Server Agent jobs to execute SSIS packages on the managed instance. To learn more about Azure Data Factory pipelines, activities, and triggers, see Pipelines and activities in Azure Data Factory and Pipeline execution and triggers in Azure Data Factory.Īdds support for SSIS package scheduling in SQL Server Agent in a SQL Server Managed instance. You can then edit and extend these objects in Data Factory.įor more information, see Schedule SSIS package execution on Azure SQL Database with SSMS. 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.

#SQL SERVER MANAGEMENT STUDIO 17 CONFIGURATION MANAGER UPDATE#

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.

Sql server management studio 17 configuration manager