September 2010
Intermediate to advanced
1704 pages
111h 8m
English
A facet is a logical grouping of predefined SQL Server 2008 configuration settings. When a facet is coupled with a condition, a policy is formed and can be applied to one or more SQL Server instances and systems. Common facets include Surface Area Configuration, Server Audit, Database File, and Databases. Table 22.1 illustrates the complete list of predefined facets that can be selected, along with an indication of how each facet can be automated. Check On Schedule uses a SQL Server Agent job to evaluate a policy. Check On Change uses event notification to evaluate based on when changes occur. Facets are included with SQL Server 2008 and cannot be modified.
Table 22.1 Facets for Policy-Based Management
The complete list of facets ...