I’ve uploaded my deck and scripts for my upcoming presentation. It’s in the “Presentation” page.
In order to create the sample “Stack Exchange” databases, you can use the Gist here .
I’ve noticed some range and scale issues so I took out the explicit schema creation (for now). For right now it just selects into a table, dropping the table if it already exists.
Back in October I had the opportunity to attend Jonathan Kehayias’ “SQL Server Archaeology” presentation. I’d been trying to wrap my brain around Extended Events for a while, but his presentation got me motivated to dive into the system_health Event Session.