Replacing SQL Query Analyzer to Audit Ad Hoc SQL DML and DDL

An Application for Executing Ad Hoc SQL in a Regulated Environment.

What do you do when the data in an application is incorrect and the application isn't able to correct the situation?  You fix it, right? That approach doesn't sit well with the policies required by the regulatory compliance requirements of HIPPA and SOX, nor do auditors look on it favorably. This presentation demonstrates an application built to allow ad hoc changes to data and
create an audit trail of changes. Along the way we'll see some interesting T-SQL and use of SQLXML.

To download slides use this button:

Code examples are in a zip file. Use this button:

Scheduled Presentations: