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
790 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
937 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
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
Where can I find reliable fissure treatment in Delhi?
Finding reliable care starts with choosing a clinic that focuses specifically on anorectal conditions...
Is online Partnership Firm Registration Service in Delhi reliable?
Yes, the online Partnership Firm Registration Service in Delhi is reliable when handled by...
Is Adenoz Injection safe for patients with low blood pressure?
Adenoz Injection is used to treat specific heart rhythm disorders, but it must be...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers