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
Cardinal Rules, a three panel cartoon by SQLAuthority. Sam asks the red bird how many rows will come back. The bird says four hundred and has never been surer of anything. A fairground scale spills a huge ribbon of abstract marks, and the deflated bird says four hundred was a feeling, not a number.

AI Row Count Estimates Come From Nothing

October 3, 2026
Pinal Dave
AI
AI, SQL Humor, SQL Performance, SQL Statistics

AI row count estimates arrive with tremendous confidence. Cardinal said four hundred. The query returned nine million.

Read More
Figure showing four circles, one inside the next: AI, machine learning, deep learning and generative AI.

AI Basics: The Four Circles, and Four More Questions

October 1, 2026
Pinal Dave
AI
AI, AI Book, Career Advice, Professional Development
Part one of ten. Most AI interview questions start here, even for senior roles. Someone asks you to explain a large language model in plain words, and your answer tells them more than your resume does. 1. What is the difference between AI, machine learning, deep learning and generative AI?…
Read More
The real SSMS Spatial results tab next to the query that produced it: 16 lines from the center pin to the grid points exactly the square root of 65 away, each 8.062 units long

Erdős Unit Distance Problem: What It Is and What AI Found

September 29, 2026
Pinal Dave
AI
AI, Mathematics, Spatial Database, SQL Scripts

The Erdős unit distance problem asks how many pairs of points can sit exactly one unit apart. Paul Erdős guessed the answer in 1946, and the guess stood for eighty years. In May 2026, an OpenAI model found a counterexample. I checked the grid trick behind it in SQL Server, spatial queries included.

Read More
Cardinal Rules, a three panel cartoon by SQLAuthority. Sam asks the red bird for last quarter revenue. The bird types in a blur and calls the query poetry. Sam says there is no table called Revenue Final, and the bird replies that there should be.

AI Hallucinated a Table That Was Never There

September 26, 2026
Pinal Dave
AI
AI, Database, DBA, SQL Humor

AI hallucinated a table, wrote a lovely query against it, and handed the whole thing over without blinking. Say hello to Cardinal.

Read More
An empty warehouse receiving dock at dawn with a new conveyor running to an open door, and a hand-lettered cardboard sign taped to the frame reading MONDAYS: WAIT TILL 9

AI Generated ETL Worked on Day One. Then Came Monday.

September 25, 2026
Pinal Dave
AI
AI, Data Observability, Data Warehousing, ETL

AI generated ETL ran clean on the first try, and it took six weeks to find out what it was missing. A late Monday file, a file sent twice, a file full of zeros and mangled names all got through. The ugly old job had a rule for every one of them, and nobody had written those rules down. Now I ask AI for the failure list before I ask for any code.

Read More
The cover of 100 AI Interview Questions and Answers for Data Professionals by Pinal Dave, white and red type on near black, reading 100 questions, 184 key terms, answers you can say out loud.

100 AI Interview Questions and Answers for Data Professionals

September 24, 2026
Pinal Dave
SQLAuthority News
AI, AI Book, Career Advice, Professional Development, SQL Book

My new book is out. It holds the 100 AI interview questions data interviewers ask now, with answers short enough to say out loud. Six of those questions are in this post, free.

Read More
Three views of tea: stirring with a spoon, swirling after removal, and gradually settling.

Navier-Stokes Problem: What It Is and What AI Found

September 18, 2026
Pinal Dave
AI
AI, Mathematics

The Navier-Stokes problem in plain words: what the famous fluid question asks, what AI says it found, and why it is not official yet.

Read More
Previous 1 2 3 4 5 … 8 Next
  • Books
  • Testimonials
  • Privacy Policy

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