This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
The Halloween server shadow puzzle shows three cabinets and their shadows; one cable shape does not match.

The Halloween Server Shadow: Spot the Impossible One

October 25, 2026
Pinal Dave
SQL Puzzle

The Halloween server shadow puzzle hides one mismatched cable. Look at three racks and choose the shadow that cannot belong.

Read More
Cardinal Rules, a three panel cartoon by SQLAuthority. The red bird holds an interview questions book and asks Sam to explain an embedding in plain words. Sam explains it and the bird says correct. Sam says now you, and the bird asks to phone a friend.

AI Interview Questions Test You, Not the Machine

October 24, 2026
Pinal Dave
AI
AI, AI Book, Career Advice, SQL Humor

AI interview questions test whether you can explain something out loud. Cardinal can produce an answer. Cardinal cannot be asked.

Read More
A colour plate in the style of a classic bird guide, eight small execution plan silhouettes arranged in two columns with numbers beside them.

Slow Queries: A Field Guide to Eight Species

October 23, 2026
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Scripts, SQL Wait Stats

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.

Read More
Figure showing an embedding map where related ideas become neighbours.

Embeddings and Vectors: The Map of Meaning

October 22, 2026
Pinal Dave
AI
AI, AI Book, Database, SQL Data Storage
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…
Read More
Cartoon of a calm figure in a dark suit sitting for an interview, with a wall of hundreds of unlabelled filing drawers behind it.

The Query Optimizer Interview: Twenty Minutes, No Hints

October 21, 2026
Pinal Dave
SQL Performance
Best Practices, Developer, SQL Performance, SQL Server

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.

Read More
Illustration of a person seen from behind in a dark corridor, holding a folder, looking through wired glass into a lit meeting room where four other people are using it.

The Understudy: A Story About the Human in the Loop

October 20, 2026
Pinal Dave
AI
AI, Best Practices, Developer, Professional Development

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.

Read More
Ink spot illustration of an opened letter lying flat with a brass letter opener across one corner and a glass inkwell beside it.

The SQL Advisor: Seven Answers, All Measured

October 19, 2026
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, Developer, SQL Server

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.

Read More
1 2 3 4 … 843 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com