How to Audit SQL Server for Free.

Please join us on 18th Nov, 2021.

What ~ Toronto Data Professionals Community (Virtual)

When ~ Thursday 18th Nov, 2021

Agenda:

6:00 Networking and Introduction

6:15 Topic: How to Audit SQL Server for Free by Josephine Bush who has over 10 years of experience as a Database Administrator. She is a Microsoft Certified Solutions Expert, author of Learn SQL Database Programming published by Packt in May 2020 and she is also blogger and speaker.

7:30 End

Where : Online via Microsoft team

Session Details:

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. Additionally, you will get a high level comparison of how SQL Server auditing compares to cloud SQL auditing.

Speaker Bio:
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.