975
Chapter 42: SQL Audit
42
to continue with other auditing technologies such as tracing or triggers for compliance and
monitoring. SQL Audit is the future and will improve with each new version of SQL Server
as is evident with the enhancements in SQL Server 2012.Major highlights of this chapter include the following:■ (^) Each instance may have multiple SQL Audits — collection buckets for audit data
that can write to an audit fi le, application log, or security event log.
■ (^) Each SQL Audit can have one Server Database Specifi cation and one Database Audit
Specifi cation per database writing to that SQL Audit. Each Server or Database Audit
Specifi cation may have multiple events or actions that it’s auditing.
■ Database Audit Specifi cations can audit DML statements: select, insert, update, and
delete. In addition, the audit details include user context information.
This part covers another new monitoring technology targeted at enterprise servers. SQL
Audit is a strategic tool, both for Microsoft and the IT shops that adopt it.
c42.indd 975c42.indd 975 7/31/2012 10:17:50 AM7/31/2012 10:17:50 AM
http://www.it-ebooks.info