PASS logo

November 15-18

Seattle & online

2021 Summit video library

How to Audit SQL Server for Free

Josephine Bush

Are you tired of not knowing who’s changing what on your SQL Servers? Maybe your company can’t afford to buy third-party auditing tools, but there’s no need to buy expensive auditing tools if you can’t afford them or don’t want to use them. You can know about everything changing on your SQL Servers without having to pay for a tool.

By auditing with the built-in features of SQL Server Audit, you can track changes, report on usage to auditors, change user permissions or passwords without breaking functionality, and/or understand your workload to migrate parts or all of your database to the cloud or other database technologies.

This session will help you understand how to use SQL Server Audit. You will also learn how to compile the results in a central location for easy reporting and learn how to email audit findings with a SQL Agent job. Additionally, you will get a high-level comparison of how SQL Server auditing compares to cloud SQL auditing.