About the Presentation
Audit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output?
In Enterprise Audit with SQL Server Audit, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works “under the covers”, and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit’s output options.
Whether it’s through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you’ll be able to deploy Audit across your SQL Server enterprise and manage its output, fearlessly.
Session Level: Intermediate
This session was presented at PASS Summit 2015.
Download the Presentation
Presentations (Upcoming & Past)
- SQLSaturday #499 – Madison, WI – April 9, 2016
- PASS Summit – Redmond, WA – October 26-30, 2015
- SQLSaturday #446 – Portland, OR – October 24, 2015
- SQLSaturday #442 – Orlando, FL – October 10, 2015