Security > Learn > "How Do I" videos >  How Do I: Secure SQL Server using SQL Server 20...

How Do I: Secure SQL Server using SQL Server 2008 Policy Based Management?

SQL Server 2008 introduced a new feature known as Policy Based Management (PBM). This feature allows us to create policies for our SQL server instance. Few important features of Policy Based Management are:

  • It is similar to group policy feature provided by Windows
  • We can create SQL Server Policies and deploy these policies across multiple servers
  • Policies can be scheduled or we can run them on demand
  • Policy can also rollback the transaction (policy violating transactions) with raising an error

In this video I’ll showcase how we can leverage Policy Based Management to secure our SQL server environment. I’ll introduce you with these basics of PBM and we will see how we can build policies related to SQL server security and assess those policies on our SQL Server instance.

Presented by Gaurav Sharma, Information Security on July, 2009

Length: 8 minutes 56 seconds

Downloads

Video Downloads
WMV (Zip) | WMV | iPod | MP4 | 3GP | Zune | PSP

Audio Downloads
AAC | WMA | MP2 | MP3 | MP4

Page view tracker