I’m speaking at Tech Expo Gujarat 2026, November 27 to 29 at GUCEC in Ahmedabad. My session, Competence Debt: AI Lets Us Ship What We Cannot Fix, is on Saturday, November 28. Here is what it covers and how to find me there.
Twenty Practice Queries on One Small Schema
Work through twenty practice queries on one small sales schema, with expected results for filters, joins, totals, windows, and gaps.
Long-Running Query for Demonstrations You Can Control
A long-running query for demonstrations has to run long enough to watch and stop when you say. This post builds one from a counting table, shows how its run time grows with the row count and explains how to watch and stop it. It also compares it with WAITFOR DELAY.
SQL SERVER – 3 Questions: An Index Reduces Performance of SELECT Queries
An index can reduce the Performance of SELECT Queries when it changes a particular plan unfavorably. Readers asked three follow-up questions.
Practical Real World Performance Tuning – Fun and Reviews
Part two of my behind the scenes story of Practical Real World Performance Tuning: the fun we had in class and the reviews our students shared.
SQL SERVER – GDPR Features and Operational Responsibilities
GDPR Compliance concerns how an organization processes personal data. Reader questions prompted my series about the database controls that can help.
Choosing a Technical Conference Worth Attending
Choose a technical conference by matching sessions and audience to your skill goals, then counting the full cost before you book.