Policy-Based Management and Central Management Server

Explore policy-based management and Central Management Server in SQL Server through this comprehensive conference talk from PASS Data Community Summit. Dive into the advantages and disadvantages of Central Management Server, learn how to import and export configurations, and master server registration techniques. Discover the intricacies of policy-based management, including condition creation, manual policy setup, and importing policies. Follow along with hands-on demonstrations covering topics such as creating and evaluating policies, using expressions, and implementing server restrictions. Gain valuable insights into database engine policies, job renaming, and policy modification strategies to enhance your SQL Server management skills.

Syllabus

Intro
Agenda
Central Management Server
Advantages
Disadvantages
ImportExport
Demo
View Central Management Server
Register Central Management Server
Create Server Groups
Create Folders
New Server Registration
Connection Error
Server Registration
Object Alias
Named Instance
Folder Level
Query Window
Can you add servers to CMSprogrammatically
What if I was dropping a table
Did the query window kill the connection
Export
PolicyBased Management
MSDB
Conditions
Manual Policy Creation
Importing Policies
Evaluation Modes
Demonstration
Using the CMS
Creating Conditions
View Objects
Create Policy
Enable Policy
Evaluate Policy
Apply Policy
Execute Sequel
Create Expression
Evaluate Expression
Import Policies
Database Engine
Auto Shrink
Policy State
Server Restrictions
Renaming Jobs
Modifying Policies