Whatcha Doin’? Passive Security for Hostile Environments

Slide Deck

Demo Code

Resources

Triggers

Rollbacks and Commits in Stored Procedures and Triggers

DDL Trigger Event Groups

EVENTDATA() Function

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

SQL Server Audit

Event Notifications

Understanding Event Notifications vs. Triggers

Understanding Event Notifications vs. SQL Trace

DDL Event Groups

Getting Started with SQL Server Event Notifications

Extended Events

Using SQL Server Extended Events

An XEvent A Day: 31 days of Extended Events

Event Notifications vs Extended Events