Work of art – the intra query parallelism deadlock graphs

Look at some of the graphs produced by the intra query parallelism deadlocks, below.

Bart Duncan explains this “phenomenon” (bug, rather)...

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...

Automated Metadata Report for SSAS Tabular

There’s been an excellent free solution for documenting SSAS metadata in multi-dimensional models for quite some time: http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/.
I had the...

Executing DBCC for SQL Server Analysis Services 2016

In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...

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.
Related Posts:

How...

Extended Events Categories

I recently delved into a brief explanation of Packages as they correlate to Extended Events. In that article, I left...

Multi-Cursor Editing SQL feels like the movie Inception just became real

- Yes… multicursor editing is epic

- No… SSMS doesn’t support multi-cursor editing the way it should.
- Yes… you can do some...

One Easy Strategy for the Database Enterprise

Working with the default XEvent session and trying to make it more suitable to Enterprise worthy.
Related Posts:

SQL Servers Black Box Recorder - system_health December 29, 2018

Finding Installed Event...

One Easy Strategy for the Database Enterprise

 
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...

Populating My DBA Database for Power Bi with PowerShell – Server Info

Following my last post about using Power Bi with my DBA Database I have been asked if I would share...