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

     

 


RSS as HTML

Personal Blog

 
New Tips:

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

Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition


Full Schedule