As databases become more critical to the operation of our organizations, we are being asked to audit and report on access to both data and the configuration of our systems. SQL Server has a number of features that can help you comprehensively audit your system, including SQL Audit, Extended Events and the default trace. Come learn how you can configure and incorporate detailed auditing into your reporting to management.
Level: 200 – Should have some basic knowledge of SQL Server, database security, and T-SQL.
- Using Logon Triggers
- Looking at the default trace
- Using SQL Audit to track logins
- Using Extended Events to track logins
- Checking permissions at the server and database level
- Watching database activity using DML triggers
- Watching database activity using SQL Audit
- Watching database activity using Extended Events