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 […]
Joe Sack
SQL Server Performance Tuning, High Availability and Disaster Recovery Blog
There and Back (to Minneapolis) Again
Posted on: September 19, 2013 10:19 am
Workloads that generate the 0x0000000000000000 query hash value?
Posted on: September 18, 2013 7:05 am
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 0x0000000000000000 value as […]
New Article on SQLPerformance.com “Exploring Low Priority Lock Wait Options in SQL Server 2014 CTP1”
Posted on: September 18, 2013 6:26 am
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”
Posted on: September 13, 2013 6:34 am
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
Posted on: September 9, 2013 12:05 pm
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”
Posted on: September 6, 2013 12:02 pm
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 […]
