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 showing that the model sees only what fits in its context window, and everything else is gone.

Tokens and the Context Window: Out of the Window, Out of Mind

October 8, 2026
Pinal Dave
AI
AI, AI Book, Best Practices, Professional Development
Part two of ten. Most of the surprises people hit with AI at work trace back to this one chapter. A model reads in tokens, holds only so many at once, and charges for each one. 1. What is a token? A token is the unit of text a model…
Read More
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
A box of office belongings and a blank access badge on a kitchen table, while a car leaves the neighborhood outside.

The Fog After a Layoff: Rules for the First 30 Days

September 30, 2026
Pinal Dave
AI
Career Advice, Life Lessons, Professional Development, Self Help

The fog after a layoff shows up before the grief does. You can’t read, you can’t decide, and you can’t find the words to tell the people you love. It isn’t weakness, and it lifts. These are small rules for the first 30 days, and the signs that it’s time to talk to someone.

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
Previous 1 2 3 4 5 … 8 Next
  • Books
  • Testimonials
  • Privacy Policy

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