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
Five potted ferns drawing water through cotton wicks from a glass bowl, a hand testing the soil of the last pot

Holiday Change Freeze Checklist for SQL Server: What to Verify First

December 25, 2024
Pinal Dave
SQL Tips and Tricks
Best Practices, Change Data Capture, SQL Server

Use a change freeze checklist for SQL Server to verify backups, integrity checks, disk headroom, Agent jobs, and serious errors.

Read More
A groundskeeper pushing a line-marking cart across an empty field, painting the first boundary line.

Turning a Business Question Into a Query: Define the Metric First

March 1, 2024
Pinal Dave
SQL Tips and Tricks
Best Practices, Business Intelligence, SQL DateTime, SQL Reports, SQL Server

Turn a business question into a tested T-SQL metric with explicit time zones, cancellations, returns, and a hand-checked sample.

Read More
A caulking gun with a stuck cartridge holding up the work at its nozzle

Blocking Alert: A T-SQL Check for Sessions Blocked Too Long

September 6, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, Comprehensive Database Performance Health Check, SQL Server

Short blocking is normal. This check flags lock waits past a threshold and walks each chain to the session at the front of the line.

Read More
Gouache painting: a tea shop counter where one small wooden crate is checked twice: once close up under a magnifying lens, and once from across the room on a wide shelf; the crate's tag is vermilion

BDD vs TDD: One Small Feature, Two Ways to Test It

August 31, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, Developer, Software Development, Testing

BDD vs TDD is easy to mix up until you test the same feature both ways. This post checks one delivery rule with a unit test and then with a plain-language scenario, runs the unit test, and explains when each approach fits.

Read More
A shell bead necklace with repeated shell colors beside one specimen of each color

Running Distinct Counts: Working Around COUNT(DISTINCT) OVER

July 27, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Your report wants unique customers so far, and SQL Server refuses COUNT(DISTINCT) over a window. Flag each first appearance and add up the flags instead.

Read More
A lawn bowls green with the jack in place, a bowl rolling toward it and a hand holding a measuring string.

Given-When-Then for Database Tests

July 24, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, Software Development, SQL Server, SQL Stored Procedure, Testing

Use Given-When-Then for readable database tests with known input, explicit THROW checks, and transaction rollback after each case.

Read More
Gouache painting of ten small terracotta pots of young herbs in a row on a potting bench, one pot vermilion.

Go Programming Language: 10 Interview Questions With Tested Answers

July 7, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, Go, SQL Scripts

The Go programming language is small, so ten questions cover most of an interview. This post answers each one in plain words with a tiny program. Every program was run twice on Go 1.27.1, and the real output is shown.

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

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