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_3

3. What Is SQL Server Audit?

Josephine Bush¹  

(1)

Boulder, CO, USA

 

SQL Server Audit is built-in auditing functionality available via SQL Server Management Studio GUI or SQL scripts. You can set it up and configure it to capture pretty much anything that happens on SQL Server. It’s quite flexible and easy to set up.

SQL Server Audit Availability

The first version of SQL Server Audit was available in 2008, and it was only in Enterprise edition. As of the 2012 version, Microsoft expanded it to be available in server-level audits with all editions ...