Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

J. BushPractical Database Auditing for Microsoft SQL Server and Azure SQLhttps://doi.org/10.1007/978-1-4842-8634-0_16

Database Auditing Options Comparison

Josephine Bush¹  

(1)

Boulder, CO, USA

 

Here’s a quick review of the options for auditing. This chapter has use cases and pros and cons for each auditing option along with references back to specific chapters for additional information.

Auditing Options

• SQL Server Audit – This built-in SQL Server auditing feature can be used to set up auditing with SQL Server Management Studio or with SQL scripts. This feature makes it easy to see what is changing on your SQL Server. To make SQL Server auditing work, ...