Whatcha Doin’? Passive Security for Hostile Environments
Slide Deck
Demo Code
Resources
Triggers
Rollbacks and Commits in Stored Procedures and Triggers
SQL Trace
Auditing: SQL Server’s Built-in Traces
The default trace in SQL Server – the power of performance and security auditing
The Server-side Trace: What, Why, and How
Stairway to Server-side Tracing series
How to create a Profiler Trace during Server startup
SQL Audit
SQL Server Audit Action Groups and Actions
Event Notifications
Understanding Event Notifications vs. Triggers
Understanding Event Notifications vs. SQL Trace
Getting Started with SQL Server Event Notifications
Extended Events
Using SQL Server Extended Events