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
Tilt-shift miniature photo of an antique brass calculating machine inside a glass museum case behind a red velvet rope, with a large magnifying glass looking in without touching it

Claude on SQL Server FAQ: 7 Questions Teams Ask Me

November 17, 2026
Pinal Dave
AI
AI, Best Practices, SQL Performance, SQL Server Security

This Claude on SQL Server FAQ answers the seven questions teams ask me before we set up the read, prove, then change loop. It covers safety, customer data, staging, team time, mistakes, the role of the DBA and how soon a result shows up.

Read More
Hand embroidery on linen of a teal front door with a glowing vermilion doorbell and an empty porch

Hi Messages: Ring the Bell and Say Why You’re Here

November 16, 2026
Pinal Dave
Personal
Best Practices, Career Advice, Professional Development, Social Media

Hi messages fill my inbox, and they’re harder to answer than anything else. Someone writes “Hi” and waits, and the real question arrives hours later. This post looks at why people do it, what it costs both sides, and how to put the reason in the first message.

Read More
Figure showing an agent given a visitor badge: open doors to read, a person at the door to change anything.

AI Agents and Security: Keys to the Building

November 12, 2026
Pinal Dave
AI
AI, AI Book, Best Practices, SQL Server Security
Part seven of ten. An AI agent is a new kind of user in your systems. It reads, runs queries and takes actions, all at machine speed. These are the questions a security-minded interviewer asks before handing it any keys. Try this first, it takes a minute Paste this into…
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
Profile card for PAGEIOLATCH_SH. Blamed for slow disks. Actually means the query is waiting for a page read to finish. Caused by scattered reads on a cold cache. What to do: look at the access pattern before you blame the storage.

Know Your Wait Types: Six Profiles, All Induced

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

I caused six wait types on purpose, one at a time, and measured each one for a single session. What each is blamed for, what it actually means, and the numbers it produced on SQL Server 2025. Wait types are the most misread figures in the product.

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

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