There and Back (to Minneapolis) Again

Exactly two years ago I started my journey with SQLskills. It has been an incredible experience and I’m grateful for my time with everyone in the company and also grateful for all the people I got to meet along the way. I’ve gained friendships and working relationships that will last a lifetime. While this has […]

Workloads that generate the 0×0000000000000000 query hash value?

In the last SQLskills Insider demo video I went through a scenario where you can use the query_hash column from sys.dm_exec_query_stats to aggregate statistics for queries that only differ by literal values. I received an interesting question from someone who watched the video, ran the demo query in production and saw a 0×0000000000000000 value as […]

New Article on SQLPerformance.com “Exploring Low Priority Lock Wait Options in SQL Server 2014 CTP1”

My 10th guest blog post was published today on SQLPerformance.com: Exploring Low Priority Lock Wait Options in SQL Server 2014 CTP1 In this post I further explore (from the last SQLPerformance.com post) online options, and specifically low priority lock wait improvements being included in SQL Server 2014 CTP1.

New Article on SQLPerformance.com “Exploring Partition-Level Online Index Operations in SQL Server 2014 CTP1”

My 9th guest blog post was published today on SQLPerformance.com: Exploring Partition-Level Online Index Operations in SQL Server 2014 CTP1 In this post I explore the online, single-partition rebuild improvement being introduced in SQL Server 2014 CTP1.

We can handle the truth

Today I attended the MCM call with Microsoft Learning (MSL). I won’t get personal here, because in spite of everything, I do imagine that the folks in MSL are under quite a bit of stress right now (yes – so is the community, but more on that later).  I myself remember getting chewed out back […]

A Brief Tour of SQL Sentry’s “AlwaysOn Monitoring”

Now before I begin this post, a quick disclaimer… SQLskills partners with SQL Sentry on a couple of things. We periodically write guest-posts on SQLPerformance.com and SQL Sentry also provides exclusive sponsorship of two of our Immersion Events. I am also a big fan of SQL Sentry Plan Explorer, but that would have been the […]