Introduction to SQL Audit and Audit Reports

Daniel Maenle

Do you need to know who is doing stuff in your database?
Do you suffer long hours trying to find what is causing changes?

SQL Audit allows for you to track changes within SQL server. Either on the server level or the database level. You can now see who is making changes. Who does that unexpected update to your table…SQL Audit! Since SQL Server 2016 sp2+ you have access to database audit specifications on Standard edition. So, let’s leverage this data to a driving force for data compliance.

In this session I will go over how to build a simple SQL Audit, and how to then empower your SQL Audit into consumable reports which will be built to make the data useful for tracking purposes, using SQLAuditCentral.

This is to be a primer session but also give you enough to have a great start and get great insights into what your SQL server is doing, and how to move forward into greater insights into changes, of the who and the what. We will be discussing server level and database level audit specifications.