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_13

13. Auditing Azure SQL Databases

Josephine Bush¹  

(1)

Boulder, CO, USA

 

This chapter will show you how to audit your Azure SQL Databases. In some ways, it’s very much like SQL Server auditing, and in other ways, it’s fairly different.

There is a high-level comparison of Azure auditing vs. SQL Server auditing in Table 13-1.

Table 13-1

SQL Server and Azure SQL auditing comparisons

Cloud solution	SQL Server Audit	Extended Events	Auditing differences
SQL Server VM	Yes	Yes	The same as if you are using SQL Server on premises
Azure SQL Database	No	Yes	SQL Audit ...