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.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Robert Pearl
About this chapter
Cite this chapter
Pearl, R. (2015). Surviving the Audit. In: Healthy SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6772-0_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6772-0_10
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6773-7
Online ISBN: 978-1-4302-6772-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books