Fall Means Election Season

While it’s not officially Fall yet, it is definitely Election Season. Elections for the PASS Board of Directors opens up...

Extended Events – Event Anatomy

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

Extended Events – Event Anatomy

So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into...

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

A look on the CXPACKET wait type

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...

A look on the CXPACKET wait type

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...

A look on the CXPACKET wait type

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...

A look on the CXPACKET wait type

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...

The #TSQL2sday #70 roundup

Time for the T-SQL Tuesday #70 roundup! I asked people for their best enterprise management strategies, and they responded beautifully....

IT/Dev Connections conference sessions next week

Next week is the wonderful IT/Dev Connections conference in Las Vegas, and I’m proud to announce that I’m presenting two...