2008.3

This is the promised continuation of my May Code Camp talk. This time, I’ll talk about the Management Data Warehouse and Auditing. The Management Data Warehouse and its associated data collector provide an awesome tool for collecting historical performance data for servers across the Enterprise. If any of you have been SQLH2 users, you’ll see how this is a wonderful replacement for that tool. Ever written a trigger to capture change data to store in a audit table? Those days could be gone! I’ll give an overview of the new auditing capabilities of SQL Server 2008 and show you how to take advantage of these capabilities.

Sharon Dooley (MCP, former SQL Server MVP) has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning, though she also does a lot of administration. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Manager. She’s currently hard at work developing Learning Tree’s SQL 2008 Admin course. Ms. Dooley is the author of SQL Server 7.0 Essential Reference (New Riders) and the lead author of Professional SQL Server 6.5 Administration (Wrox). Sharon is an active member of PASS (The Professional Organization for SQL Server) and has presented at numerous conferences. She was named a Microsoft MVP in 2001 and was an MVP for SQL Server until 2004. In her spare time, she enjoys being bossed around by her cats.