Главная
Study mode:
on
1
Intro
2
Agenda
3
Central Management Server
4
Advantages
5
Disadvantages
6
ImportExport
7
Demo
8
View Central Management Server
9
Register Central Management Server
10
Create Server Groups
11
Create Folders
12
New Server Registration
13
Connection Error
14
Server Registration
15
Object Alias
16
Named Instance
17
Folder Level
18
Query Window
19
Can you add servers to CMSprogrammatically
20
What if I was dropping a table
21
Did the query window kill the connection
22
Export
23
PolicyBased Management
24
MSDB
25
Conditions
26
Manual Policy Creation
27
Importing Policies
28
Evaluation Modes
29
Demonstration
30
Using the CMS
31
Creating Conditions
32
View Objects
33
Create Policy
34
Enable Policy
35
Evaluate Policy
36
Apply Policy
37
Execute Sequel
38
Create Expression
39
Evaluate Expression
40
Import Policies
41
Database Engine
42
Auto Shrink
43
Policy State
44
Server Restrictions
45
Renaming Jobs
46
Modifying Policies
Description:
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.

Policy-Based Management and Central Management Server

PASS Data Community Summit
Add to list
#Conference Talks #PASS Data Community Summit #Computer Science #Database Management #Programming #Databases #Database Administration #SQL Server Administration
0:00 / 0:00
1 of 46

Intro