Hands-On-Lab: SQL Server Policy Based Management

Hello Friends,

Here is another popular lab from Hands-On-Lab library: SQL Server Policy Based Management.

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

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.