Advertisement
Published in:
2015 | OriginalPaper | Chapter
10. Surviving the Audit
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
Abstract
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.