XEvent Session Supporting Cast
So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated...
2015-09-10 (first published: 2015-09-04)
982 reads
SQL RNNR
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...
2015-09-04
8 reads
Viewing Running XEvent Metadata
In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata...
2015-09-08 (first published: 2015-09-03)
1,318 reads
Viewing Running XEvent Metadata
Running session metadata, while it can be still be viewed in the catalog views, is exposed via DMVs. Putting it a slightly different way, if I query DMVs that...
2015-09-03
5 reads
Viewing Deployed XEvent Metadata
Today will be the first of a few introductory level posts about Extended Events.
When dealing with Extended Events, there are...
2015-09-02
789 reads
Viewing Deployed XEvent Metadata
When dealing with Extended Events, there are a few ways to take a look some of the metadata. Not all metadata is created equal when dealing with Extended Events....
2015-09-02
2 reads
Shredding Extended Event Actions
The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that...
2015-09-01
754 reads
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...
2015-09-01
20 reads
Shredding XML in XEvents
One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign...
2015-08-26
936 reads
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...
2015-08-26
5 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers