Detective By Accident – that’s what DBA really stands for, not Database Administrator. Come on, if it was really Database Administrators, we’d be DA’s. Granted, most of us don’t look like Warrick Brown or Sara Sidle, but when something disappears in the datacenter, people pick up the phone and call us.
On July 24th, Jason Hall and I are doing a webcast called CSI:DBA – Going Back in Time to Understand What Happened to Your Data. We’re going to cover some of the SQL Server techniques you can use to:
- Track who made schema changes
- Track who deleted & truncated tables
- Get the data back without time-consuming full restores
I’ll be covering how to do it with the native SQL Server tools, and Jason will demo how Quest tools can help. I’ve written up some of the native SQL parts of the presentation on our community site, SQLServerPedia. You can register for the webcast, or check out my notes on auditing SQL Server schema changes with DDL triggers and the Performance Dashboard.
