The first video in our professional development series, led by Nupur Dave, is about how to avoid procrastination and stop putting things off.
Query Store Hints: Fixing a Query Without Touching Its Code
Apply query store hints to a vendor query without code changes, verify failures and plan behavior, then clear the hint after the real fix.
Masked Values: What Dynamic Data Masking Does Not Hide
A masked column shows zeros, but a user with SELECT can still filter, sort and guess the real values. Here is the proof and the fix.
Does Column Order in CREATE TABLE Change How Rows Are Stored?
Someone wants to reorder columns to shrink rows. I measured it on SQL Server 2025, and the answer is mostly no, with one small exception worth knowing.
Reading Pending I/O Requests During a Storage Slowdown
Sample pending I/O requests during PAGEIOLATCH or WRITELOG stalls, map each request to a file, and share timed evidence.
Finding Which Database Uses the Most CPU on a Shared Instance
Find which database uses the most CPU from cached query stats and plan attributes, then use Query Store for restart-safe history.
Pluralsight Author Summit 2013: A Truly Amazing Experience
The Pluralsight Author Summit in Salt Lake City was three days of learning and networking with authors who all love to share knowledge. Here is my recap of the sessions, the dinners, the management talks and the last day at a ski resort, with the photographs.