CHAPTER 10
Sur viving the Audit
In this chapter, I will discuss the various methods to retrieve audit-related information, such as the default trace, SQL Audit, DDL triggers, and more. I will explore the internals of the transaction log and give you a glimpse into how read it in its native hexadecimal format, which is how the popular third-party vendors do it in their compliance and data recovery software. Luckily, with the advent of SQL Server 2008’s Change Data Capture, you will see an easier way to capture DML.
What happens now if you hear the dreaded five-letter word audit? Your organization’s legal department has just been put on notice ...
Get Healthy SQL : A Comprehensive Guide to Healthy SQL Server Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
