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_2

2. Types of Database Auditing

Josephine Bush¹  

(1)

Boulder, CO, USA

 

The starting point of any good auditing strategy is knowing the auditing options you have at your disposal. This chapter gives you a high-level description of each auditing tool that is covered in this book.

SQL Server Audit

SQL Server Audit is a built-in SQL Server auditing feature that can be used to set up auditing with SQL Server Management Studio (SSMS) . You can also set it up with SQL scripts, which makes it easier to apply the same auditing strategy to many servers. ...