As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the payload of the event? What is a payload?
Category: SQLServerPedia Syndication
Extended Events Categories
Packages have a couple of descriptors (or classifiers) that can be useful to help figure out what events contained within that package might be related to other events.
Learning Extended Events in 60 Days
Want to Learn Extended Events over the course of your lunch break for a couple of months? This is the Table of Contents for learning Extended Events over the course of 60 days.
Extended Events Packages
The first core building block to the data that builds Extended Events is the concept around packages.
XEvent Session Supporting Cast
Beyond the metadata in the the catalog views and DMVs, there are a few more objects that come in handy when dealing with Extended Events. I call these the supporting cast.
Shredding Extended Event Actions
Are you rolling the dice with your love/hate relationship with XML? Tune in to see how you can ease your XML frustration along with increasing your free time to do more important things.
Shredding XML in XEvents
One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign to many DBAs. It’s not relational and often brings nightmares of parsing and performance issues.
Tables, Columns and Defaults Oh My!
The joys of inheriting a new database and being thrown into the fire to quickly assimilate as much information about the database as possible can be troublesome. This script will help with that!
What is DBCC?
What is really mean by DBCC and what do people mean when they say DBCC?
HealthySQL – A Review
A quick look into the book by Robert Pearl: Healthy SQL.