Novick Software
SQL Server Consulting Design Programming Tuning

  andy novick is a sql server mvp



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:

New England SQL Server Users Group

Waltham, MA

November 10, 2005




Personal Blog

New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage


Nov 7, '12
Loser: DB

Full Schedule