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. The red bird asks what Sam is reading. Sam holds up a book cover and the bird goes quiet. The bird protests that it is right here, and Sam says that is the part the book is about.

AI Sounds Like Someone, But Nobody Is in There

October 10, 2026
Pinal Dave
AI
AI, AI Book, Best Practices, SQL Humor

AI sounds like someone, which is exactly why the checking stops. Cardinal read the cover of my book and has not recovered.

Read More
Painting of five identical filing cabinets floating in dark space. Four are cold and sealed, one glows from a half-open drawer, and a brass plaque in front reads WHICH ONE IS REAL.

Text to SQL: The SQL Was Never the Hard Part

October 9, 2026
Pinal Dave
AI
AI, Best Practices, Database, Developer

Text to SQL works now, on real schemas, with joins and window functions. I watched three companies hand it to their business users, and all three quietly stopped. The SQL was never the hard part. The hard part is knowing which table is real and which meaning of the word you meant.

Read More
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
Painted portrait of Pinal Dave speaking at a lectern with two microphones on a deep blue stage, beside the words Pinal Dave, Competence Debt, AI Lets Us Ship What We Cannot Fix.

Tech Expo Gujarat 2026: Join Me in Ahmedabad This November

October 7, 2026
Pinal Dave
SQLAuthority News
AI, Conferences, SQL Training

I’m speaking at Tech Expo Gujarat 2026, November 27 to 29 at GUCEC in Ahmedabad. My session, Competence Debt: AI Lets Us Ship What We Cannot Fix, is on Saturday, November 28. Here is what it covers and how to find me there.

Read More
A drive-in burger stand order window at dusk with a tray holding a single French fry and an order ticket reading ONE FRY AT A TIME

SQL Server Network Latency: When the Database Isn’t the Slow Part

October 6, 2026
Pinal Dave
SQL Performance
Computer Network, SQL Connection, SQL DMV, SQL Performance, SQL Wait Stats

SQL Server network latency can make a fast database look slow. An application that fetches 4,000 orders one query at a time pays for every round trip. I measured the loop against one query, tested what ASYNC_NETWORK_IO means, and show how to check your own round trip time.

Read More
Page 1 of the SQL Server 2025 cheat sheet PDF: the Query It section with query order, paging, joins and window functions.

SQL Server 2025 Cheat Sheet: Every Query Tested, Free PDF

October 5, 2026
Pinal Dave
SQL Tips and Tricks
Cheatsheet, SQL Function, SQL Scripts, SQL Server Management Studio

This SQL Server 2025 cheat sheet puts the T-SQL I use every day on four printable pages. Every query ran on SQL Server 2025 first, and all the scripts are in the post. It covers joins, window functions, regular expressions, JSON, indexes, backups and SSMS shortcuts.

Read More
The backup that disappeared puzzle shows before and after shelves of six labeled cards, with one question-mark gap.

The Backup That Disappeared: Sunday Puzzle

October 4, 2026
Pinal Dave
SQL Puzzle

The backup that disappeared is one of six cards. Compare the shelves and name the missing card after another card moves.

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

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