I will be presenting on following subject on Virtual Tech Days TechEd Pre-Con – February 9, 2011.
Auditing Made Easy: Change Tracking and Change Data Capture
Date and Time: February 9, 2011 11:45am-12:45pm
In this fast paced demo oriented session we will go over few of concept which are related to real life problem at customers. We often see developers and DBA looking for details like who has dropped the table, who has last modified any object as well what was actually modified. SQL Server 2008 has all the answers. It has various new methods for Auditing where not only you can know details about what was changed as well know who changed it as well. In addition to that we can capture way more details configuring Auditing. We can also work prevent changes if proper policy management is configured.
If you have ever attended my session on this subject earlier, this is going to absolutely new session and very much demo oriented. There is going to be quiz at the end of the session and I promise that if you attend the session, you will get all the answers correct.
Reference: Pinal Dave (http://blog.SQLAuthority.com)