This week, I will be headed to Chicago (#SQLSatChi) on March 17, 2018. I will be presenting my session “Locks, Blocks and Deadlocks; Tame the Sibling Rivalry“. If you are a…Continue readingSweet Home Chicago
For my first SQL Saturday in 2018 and my first since September 30th, I will be headed to Tampa Florida (#SQLSatTampa) on February 24, 2018. I will be presenting my session…Continue readingAce of Spades, Tampa
In the previous post, we went over the details of DBCC_SHOW_STATISTICS, now let’s see how this comes together. We shall run the histogram for the ProductID from the Sales.SalesOrderDetail table.…Continue readingStatistics and PowerBI Visualizations, Part Two
So this is my first T-SQL Tuesday post. This month’s challenge comes from Ewald Cress and is to recognize those who have made a meaningful contribution in your life in…Continue readingTSQL Tuesday #96
Filtered Statistics For me, tuning the Microsoft Data Platform and SQL Server is a simple principle, make the engine do as little work as possible. For the engine and the…Continue readingFiltered Statistics
Working with Buffer Pool Extension There are many limitations to the SQL Server Standard Edition Database Engine. In my opinion, one of the most confining is the memory limitation. Many…Continue readingBuffer Pool Extension
I am honored to be accepted to speak and return Philadelphia, PA on Saturday, June 04, 2016. Along with seeing great #sqlfamily and being able to share what I can…Continue readingSQL Saturday #517 Philadelphia
I am honored to be accepted to speak and return Atlanta, GA on Saturday, May 21, 2016. Along with seeing great #sqlfamily and being able to share what I can…Continue readingSQL Saturday #521 Atlanta
I am honored to be accepted to speak and return Richmond, VA on Saturday, March 19, 2016. Along with seeing great #sqlfamily and being able to share what I can…Continue readingSQL Saturday #486 Richmond