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
Video Downloads
WMV (Zip) | WMV | iPod | MP4 | 3GP | Zune | PSP
Audio Downloads
AAC | WMA | MP2 | MP3 | MP4