The Halloween server shadow puzzle hides one mismatched cable. Look at three racks and choose the shadow that cannot belong.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
AI Interview Questions Test You, Not the Machine
AI interview questions test whether you can explain something out loud. Cardinal can produce an answer. Cardinal cannot be asked.
Slow Queries: A Field Guide to Eight Species
Slow queries, identified the way a field guide identifies birds: by silhouette, habitat, call, and the species they’re confused with. All eight were raised in the lab on SQL Server 2025. The reads and the wait types are what each one produced.
Embeddings and Vectors: The Map of Meaning
Part four of ten. Search used to mean matching words. Embeddings let a system match meaning instead, and almost every AI feature that touches your data stands on that one idea. 1. What is an embedding? An embedding is a list of numbers that stands for the meaning of a…
Continue ReadingThe Query Optimizer Interview: Twenty Minutes, No Hints
The query optimizer sat down for twenty minutes and answered for itself. Why it ignored your index, why one procedure gets a plan built for the wrong caller, what it does when it cannot see your value, and the moment its own plan admits it stopped looking.
The Understudy: A Story About the Human in the Loop
Fiction. The understudy is the person paid to stay ready. Every night a system settles millions of payments in seconds. Four times a year one person does the same work by hand, on paper, against the clock, so that the ability to do it still exists somewhere in the building.
The SQL Advisor: Seven Answers, All Measured
The SQL Advisor answers seven letters with measurements instead of opinions. Table variables, what each index costs on insert, shrinking after a big delete, SELECT star, ORDER BY in a view, heaps, and whether the order of your WHERE predicates matters.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.