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
Diagram titled One row, one DELETE, five places it still lives. The left panel lists the row alive: a 284 byte log record before the commit, an address at 1 colon 392 colon 0, a checkpoint writing the page, and a backup copying it out. The right panel lists what remains after the delete: the ghost record still 184 bytes, log records, the statistics histogram that names the row, deallocated pages, and every backup.

The Migration of a Row: Tagged, Followed, Found Again

September 21, 2026
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, Developer, SQL Server

I followed the migration of a row through SQL Server 2025, from the first write to the grave. The log gets there before the table. The delete does not erase anything. And when the table is empty and the ghost is gone, the statistics histogram still names the row in full.

Read More
A glossy office reception under a huge AI FIRST banner, where the receptionist has given up on the terminal and is running a finger down a paper phone directory

Ten AI Phrases We Use Too Often

September 7, 2026
Pinal Dave
AI
Developer

In 2013 I wrote a small list of phrases developers used too often. Twelve years later, here are ten AI phrases I hear every week, and what each one means.

Read More
A weary DBA smiles at a dusty monitor where one amber alert glows beside a cobweb

What AI Thinks a DBA Does All Day

August 24, 2026
Pinal Dave
AI
Developer

What AI thinks a DBA does all day is a calm, orderly Tuesday, so I wrote down my actual Tuesday. Its day has six items, and mine has thirteen.

Read More
Editorial cartoon of a consultant suspended inside a giant AI bubble while executives enthusiastically pump it larger

AI Bubble: I Hope It Pops

August 21, 2026
Pinal Dave
AI
Developer

The AI bubble I hope will pop is the one I am standing inside, holding a book, a consulting practice, and the survival instincts of a cartoon coyote who has just looked down.

Read More
Medieval manuscript panel of the same balance of labour against capital, tipping one way in the upper register and the other way below.

Your Second Skill Was Never a Parachute

August 18, 2026
Pinal Dave
AI
Developer

Your second skill was never a parachute, and the proof is six hundred years old. The Black Death wage laws of 1349 explain what is happening to our careers.

Read More
Single-scene cartoon of a cheerful AI cleaning robot beside an overflowing DELETED bin in an empty database warehouse while a horrified developer says he only meant the duplicates

Beautiful T-SQL Queries: Three Could Delete the Company

August 17, 2026
Pinal Dave
AI
Developer

AI writes genuinely beautiful T-SQL queries. Aligned, aliased, commented. Beautiful has never meant correct, and three of these could delete the company.

Read More
A single animation frame of a person at a breakfast table forensically examining a birthday card with a magnifying glass

AI Slop: The Literary Offenses of the Machine

August 13, 2026
Pinal Dave
AI
Developer

How to spot AI slop, discovered the hard way, over four hundred entries, in a dressing gown, at two in the morning, and ending in a place I did not care for.

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

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