1 posts about · 8 mentions
SQL Authority with Pinal Dave
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. Find out where you stand before you buy anything.A query that ran perfectly and was……
read the full post →SQL Authority with Pinal Dave
The Navier-Stokes problem starts with a cup of tea. Stir it, pull out the spoon, and watch the swirl slowly settle. The math that describes that swirl is about two hundred years old. For about ninety years, nobody could answer one question about it.On……
read the full post →SQL Authority with Pinal Dave
October 3, 2026AI row count estimates arrive with tremendous confidence. Cardinal said four hundred. The query returned nine million.Cardinal Rules. A Saturday cartoon about AI and databases.Two things in your day estimate row counts, and only one of them has……
read the full post →SQL Authority with Pinal Dave
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,……
read the full post →SQL Authority with Pinal Dave
AI hallucinated a table, wrote a lovely query against it, and handed the whole thing over without blinking. Say hello to Cardinal.Cardinal Rules. A Saturday cartoon about AI and databases.Cardinal is the small red bird who lives on top of Sam’s monitor.……
read the full post →SQL Authority with Pinal Dave
This SQL Server 2025 cheat sheet puts the T-SQL I use every day on 4 printable pages. Every query on it ran on SQL Server 2025 before it went in. All the scripts are below, so you can copy them.My first SQL Server cheat sheet goes back to TechEd India in 2009.……
read the full post →SQL Authority with Pinal Dave
The backup that disappeared was one of six on the shelf. Another card changed places. Which one is missing?A backup shelf is one of those places where a quick glance can lie. A row of boxes looks complete until the day you need one particular box. This is a……
read the full post →SQL Authority with Pinal Dave
SQL Server Developer Edition is free for development and testing. It includes the features of its matching paid edition, and it’s licensed for non-production use only.Two questions come up again and again. Which download should I pick for a demo, a class or……
read the full post →SQL Authority with Pinal Dave
NOLOCK double counting is the bug where three people stand in a lunch line and four lunches go out. Nobody new showed up. One person went through twice.That’s this week’s episode of SQL in Sixty Seconds. Dex counts lunch tickets for Owen, June and Sam, and……
read the full post →