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
Nov2

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

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

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.

Continue Reading
Nov1

20 Years of SQLAuthority: Twenty Books, One Family, and a Diary That Grew Up

Pinal Dave
Personal
Balance Bounce Believe, Blogging, Life Lessons, Memory Lane, SQL Milestone
6 Comments

20 years of SQLAuthority started with one query saved on November 1, 2006. Almost 6,000 posts later, there are nineteen books of mine and one by Shaivi on our shelf. This is the story, and a thank you to Nupur, to Shaivi and to you.

Continue Reading
Oct31

AI Read the Procedure Nobody Dares to Touch

Pinal Dave
AI
AI, SQL Documentation, SQL Humor, SQL Stored Procedure
No Comments

AI read the procedure that everybody walks past. Nine hundred lines, no comments, one very old warning at the top.

Continue Reading
Oct30

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

Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Monitoring, SQL Performance, SQL Scripts
No Comments

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.

Continue Reading
Oct29

Claude on SQL Server: Read, Prove, Then Change

Pinal Dave
AI
AI, Query Store, SQL Performance, SQL Server Security, SQL Wait Stats
No Comments

Claude on SQL Server is safe when production gives it eyes and nothing else. This post splits the loop into three stages: start this week with a read-only login, make it a daily habit with a past cases library, then run it on a schedule with a second opinion. I tested the login on SQL Server 2025.

Continue Reading
Oct28

SQL Server Deadlock, Slow-Cooked: A Recipe That Serves Two Sessions

Pinal Dave
SQL Tips and Tricks
Deadlock, SQL Error Messages, SQL Lock, SQL Scripts
No Comments

A SQL Server deadlock, written up the way a recipe card is written. Ingredients, prep, method, and what to do when the sauce splits. It reproduces on SQL Server 2025 every time, and I have the timestamps and the deadlock graph to prove it.

Continue Reading
Oct27

The Nightly Index Rebuild Job, 1998 to 2026: An Obituary

Pinal Dave
SQL Performance
Maintenance Plan, SQL Index, SQL Performance, SQL Statistics, Transaction Log
No Comments

The nightly index rebuild job has died after a long illness. It was born in 1998 to a hard disk that could not seek. It never believed the disk had been replaced. It is survived by page density, which did most of its work all along.

Continue Reading
Previous 1 2 3 4 5 6 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

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.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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