UPDATE: I just finished up my presentation slides for this upcoming NY/NJ SQL User Group meeting, on Saturday, 10/24/2009. I may cut a few slides, but I'm certainly done adding any. Probably a few too many, but some of them are just section dividers, and I can always skip a subtopic if I'm short on time. Perhaps a few small modifications, but for the most part - I'm done. I also created my script files, and have them ready for some of the Demos I plan to do. I will be providing handouts for the audience members to follow along on some parts. Now for the dry run....
So, my presentation, "Who Did IT and Ran" - a SQL Caper, will be a focus on Database Forensics, of how to employ native sql server views and functions, to find out who did what to your database and when. It will give you ideas on how to get your SQL Server in compliance (think SOX), without the use of 3rd party solutions.
I will be discussing the various methods to retrieve this information, such as the Default Trace and DDL Triggers. We will explore the internals of the Transaction Log, and attempt to read it in its native HEX format. This will be sort of a magician's secret revealed - the algorithm how the popular 3rd party vendors do it in their compliance and data recovery software. Luckily, with the advent of SQL Server 2008's Change Data Capture, which will also be a discussion and demo topic, I will show you the far easier way to capture DML.
Finally, we will be giving away great prizes, SWAG, including FREE licenses for our SQLCentric monitoring & alert system!
I hear we still have some seating availability left, so to register and for more info on this FREE event and for FREE Breakfast and Lunch, see the link below. Hope to see you there!
The NJ and NYC SQL Server User Groups would like to invite you to a FREE Saturday Event featuring Jacob Sebastian, Michael Coles, and Robert Pearl
Date: Saturday, October 24th
Time: 9:00am - 3:00pm (Sign-in begins at 8:15am)
Location: Microsoft Office (Iselin, NJ)
For Registration Link/Bios/Topic Summary/More Detail, please see:
User Group Websites:
NJSQL - http://njsql.org/Default.aspx
NJSQL Google Group: http://groups.google.com/group/nj-sql-server-user-group
NYC - http://nycsqlusergroup.com/
Sponsors: Red-Gate, Moore-Stephens Business Solutions, LLC, Pearl
Knowledge Solutions, Inc, Apress