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
Figure from chapter six showing that AI writes the draft while review and tests decide whether it ships.

AI-Written SQL: The Query That Ran and Lied

November 5, 2026
Pinal Dave
AI
AI, AI Book, Software Development, SQL Performance
Part six of ten. AI-written SQL fails in a way that plain bad code never does. It runs, it returns a number, and the number is wrong. Here is one that came out 28 times too big. The number While writing chapter 6 of my new book, I asked an…
Read More
Cardinal Rules cartoon by SQLAuthority. Three panel Halloween cartoon. Sam says nobody has opened this procedure since 2011. The red bird says it read the whole thing and the office lights flicker. The bird reports a comment saying do not fix, signed by the bird, yesterday.

AI Read the Procedure Nobody Dares to Touch

October 31, 2026
Pinal Dave
AI
AI, SQL Documentation, SQL Humor, SQL Stored Procedure

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

Read More
Gouache painting of a thick glass observation window in a slate-blue wall, a quiet sage workshop visible inside, a wooden rail in front and one vermilion lantern hanging from the frame

Claude on SQL Server: Read, Prove, Then Change

October 29, 2026
Pinal Dave
AI
AI, Query Store, SQL Performance, SQL Server Security, SQL Wait Stats

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.

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
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
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
Cardinal Rules, a three panel cartoon by SQLAuthority. The VP suggests letting the AI run straight into production. The red bird is already typing DELETE FROM and Sam pulls the cable out of the wall. The bird says the WHERE clause was coming eventually.

AI in Production Without a WHERE Clause

October 17, 2026
Pinal Dave
AI
AI, DBA, SQL Delete, SQL Server Security

AI in production without a second pair of eyes is a quick way to lose a table. Cardinal was going to add the WHERE clause. Eventually.

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

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