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 T-SQL crossword grid, fifteen squares by fifteen, with twenty four numbered starting squares and the black squares filled in.

T-SQL Crossword: 24 Clues, Answers Next Week

November 18, 2026
Pinal Dave
SQL Puzzle
SQL Function, SQL Humor, SQL Scripts, SQL Training

A T-SQL crossword with a real grid and 24 clues. Every answer is a word you have typed, or a word that has typed you. Answers next week, in the comments if you cannot wait.

Read More
Two identical query windows side by side on one monitor, both with the same colour scheme, one of them with a cursor blinking after the word REPLACE.

Restore Database Mistake: I Learned About Databases From That

November 10, 2026
Pinal Dave
SQL Tips and Tricks
Career Advice, SQL Backup and Restore, SQL Error Messages, SQL Scripts

A restore database mistake, in the first person, minute by minute. This is a composite of three near misses I have been close to, with the details changed. The error message is real, and so is every rule at the end.

Read More
A magazine countdown spread, numbered blocks from ten to one, each with a small monochrome illustration of a database feature.

SQL Server 2025 Features, Ranked by How Much They Changed My Week

November 6, 2026
Pinal Dave
SQLAuthority News
Cumulative Update, JSON, SQL Function, SQL Performance, SQL Scripts

SQL Server 2025 features, ranked the way the music magazines rank albums. By whether they changed anything, not by how loud the launch was. Every entry below was tried on build 17.0.4085.5 before it earned a place. Three function probes came back unrecognised with this lab’s settings, and…

Read More
An open record book with a gold edged page, one entry highlighted, a small ribbon marking the place.

SQL Server Limits, Verified: Eleven Records Pushed to the Edge

November 4, 2026
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Error Messages, SQL Index, SQL Scripts, Undocumented SQL

SQL Server limits, done the way a record book does them. Not what the documentation says, but what happened when I tried one more. Eleven records, each attempted on SQL Server 2025 build 17.0.4085.5, each with the exact error text at the edge. One documented figure turned out to be wrong on this…

Read More
A courtroom sketch in pastel, the witness stand holding a small stack of printed T-SQL, the gallery empty, no faces drawn.

SQL Server Triggers on Trial: The State Versus the Trigger

November 3, 2026
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Trigger, Transaction Log

SQL Server triggers, tried in open court. The prosecution says they’re slow, hidden and wrong. The defence says they’re the only witness in the room. Four exhibits were measured on SQL Server 2025, and the judge rules at the end.

Read More
A paperback adventure book illustration in the old two colour style, a phone glowing on a bedside table at night.

SQL Server Blocking at 2 a.m.: You Are the On-Call DBA

November 2, 2026
Pinal Dave
SQL Performance
SQL Activity Monitor, SQL Error Messages, SQL Lock, SQL Scripts, Transaction Log

SQL Server blocking, told as a choose-your-own-path story. You are the on-call DBA. The phone has gone. The diagnosis and the kill were run in the lab on SQL Server 2025 and measured. The other branches are reasoned, and the text says which is which.

Read More
Old west poster illustration of eight slightly different outlaw sketches, faces hidden under hat brims, each with the same distinctive tear on the sleeve, and a pencil circle drawn around that tear.

Find the Query That Ran at 3 a.m.: A Wanted Poster

October 30, 2026
Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Monitoring, SQL Performance, SQL Scripts

How to find the query that ran at 3 a.m. after the fact. It uses nothing but what SQL Server 2025 keeps on its own. I planted a culprit, gave it eight disguises and buried it in four hundred innocent lookups. Then I tracked it down with Query Store. This is the poster.

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

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