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 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
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
golang

Go Language for Database Professional

December 7, 2022
Pinal Dave
SQL Tips and Tricks
Database, Developer, Go

The Go language is an open-source project started by Google. It is a statically typed, compiled language that feels like a dynamically typed, interpreted.

Read More
Mixed wooden pieces in one shallow bowl beside three small bowls containing sorted matching pieces.

Normalisation in Plain Words, and When to Stop

February 24, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Understand normalisation through one order example, then decide when a reporting copy is worth the cost of keeping duplicated data consistent.

Read More
Database Diagram

Database Diagram – Available Again in SQL Server Management Studio 18.1 Onwards

June 13, 2019
Pinal Dave
SQL Tips and Tricks
Database, SQL Server, SQL Server Management Studio

Database Diagram was one of the most popular features of SQL Server Management Studio (SSMS). This feature was available in SSMS till version 17.9.

Read More
A small desk organizer holds neatly arranged pencils beside a plain adjustable reading lamp.

Ten SSMS Settings Worth Changing on Day One

April 29, 2019
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Review ten SSMS settings for safer connections, clearer results, useful plans, and recoverable query text before starting your everyday work.

Read More
Three plain hourglasses with different sand levels stand beside a closed notebook on a wooden desk.

The Handful of Counters That Actually Matter

April 24, 2019
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Make SQL Server monitoring useful by relating waits, batch activity, memory indicators, and file latency to the same workload and observation window.

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

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