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 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.
Josephine Bush has over 10 years of experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using SQL Server, MySQL, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics. She is the author of Learn SQL Database Programming published by Packt in May 2020. She blogs on sqlkitty.com and you can reach her on Twitter @hellosqlkitty.