http://www.sqlservercentral.com/Content tagged Auditing posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Learn how to monitor database-level actions and write audit results to files.http://www.sqlservercentral.com/redirect/articles/63698/2008/07/22http://www.sqlservercentral.com/redirect/articles/63698/In this article TJay Belt describes a process to help respond to audit requests in a timely mannerhttp://www.sqlservercentral.com/redirect/articles/63391/2008/06/18http://www.sqlservercentral.com/redirect/articles/63391/SQL Server 2008 February CTP introduces a new feature, SQL Server Audit. This feature facilitates auditing of Database Engine events by providing simple T-SQL statements to enable, store, and view audits on server and database objects. Part 1 of this series focuses on the server level events.http://www.sqlservercentral.com/redirect/articles/63385/2008/06/16http://www.sqlservercentral.com/redirect/articles/63385/Tjay Belt brings us a story of how auditing was actually implemented and a discussion of why particular decisions were made.http://www.sqlservercentral.com/articles/Auditing/63249/2008/06/11http://www.sqlservercentral.com/articles/Auditing/63249/Continuing with Part II of his auditing series, Gsquared takes a look at active auditing techniques for your SQL Server.http://www.sqlservercentral.com/articles/Auditing/63248/2008/06/10http://www.sqlservercentral.com/articles/Auditing/63248/Auditing becomes more important every day as new requirements for data access are implemented. New author Gsquared, well known in the forums, brings us a look at types of audits and some details on passive auditing techniques.http://www.sqlservercentral.com/articles/Auditing/63247/2008/06/09http://www.sqlservercentral.com/articles/Auditing/63247/Learn how using the OUTPUT clause in SQL Server 2005 queries simplifies T-SQL code and returns results of rows changed by an INSERT, UPDATE or DELETE SQL command.http://www.sqlservercentral.com/redirect/articles/63202/2008/06/09http://www.sqlservercentral.com/redirect/articles/63202/Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.http://www.sqlservercentral.com/redirect/articles/63019/2008/05/15http://www.sqlservercentral.com/redirect/articles/63019/My company is just starting to look at adding functionality to retain historical data for key tables and columns for auditing purposes in many of our SQL Server databases. I have seen some of your recent tips related to triggers (Forcing Trigger Firing Order in SQL Server and Trigger Alternatives in SQL Server - OUTPUT Clause). Based on using triggers or a similar technology, what is the best way to store the historical data?http://www.sqlservercentral.com/redirect/articles/62769/2008/04/15http://www.sqlservercentral.com/redirect/articles/62769/Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.http://www.sqlservercentral.com/articles/Auditing/62126/2008/02/29http://www.sqlservercentral.com/articles/Auditing/62126/Part 2 of this article illustrates how to enable Change Data Capture on a database, on a table and how SQL Server tracks the data changes of the CDC enabled table.http://www.sqlservercentral.com/redirect/articles/62294/2008/02/28http://www.sqlservercentral.com/redirect/articles/62294/Part one of this series illustrates how to enable Change Data Capture on a database, and on a table, and how to keep track of Data Definition Language changes on a table.http://www.sqlservercentral.com/redirect/articles/61971/2008/01/25http://www.sqlservercentral.com/redirect/articles/61971/Longtime SQL Server guru David Poole brings us a look at one of the thorny problems a DBA faces: tracking down illicit users.http://www.sqlservercentral.com/articles/Security/61678/2008/01/15http://www.sqlservercentral.com/articles/Security/61678/In a new DBA role, Daryl Quadros brings us a list of the first tasks you should perform.http://www.sqlservercentral.com/articles/Administration/61319/2007/11/28http://www.sqlservercentral.com/articles/Administration/61319/As part of your performance audit, you will need to examine each database located on each of your SQL Server instances and examine some basic database settings.http://www.sqlservercentral.com/redirect/articles/61422/2007/11/16http://www.sqlservercentral.com/redirect/articles/61422/