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_8

8. Implementing Extended Events via SQL Scripts

Josephine Bush¹  

(1)

Boulder, CO, USA

 

To make extended events work, you need to set up a session. Chapter 6, “What Is Extended Events?”, covered the parts and pieces that comprise a session. Chapter 7, “Implementing Extended Events via the GUI,” covered how to set up a session in the GUI. In this chapter, you will learn how to set up an extended event session with SQL scripts.

Caution

Just because you can audit everything, doesn’t mean that you should. If you audit everything and anything, you will ...