Policy-based management feature is introduced in 2008 which allows us to define and enforcing policies for configuring and managing SQL server. Policies can be created and enabled on the server, giving the DBA more control. This is very important in the context of creating common security practices in a company. This lab is divided into three exercises explaining about how to configure and monitor policies and conditions and how to configure database using policy based management.
Exercise 1: Configuring Policy
Exercise 2: Database Configuration using Policy-based management
Exercise 3: Monitoring Conditions and policies