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
A hand holds a magnifying glass under a garden leaf, revealing a cluster of insect eggs on its underside.

Reading SQL Server Release Notes Before You Patch

June 23, 2008
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Documentation, SQL Patch, SQL Server

Reading SQL Server Release Notes before patching helps you find known issues, fixes, behavior changes, and workload risks.

Read More
Hands finishing a small, neat fishing fly at a vise, with unused feathers pushed aside in a tray.

Writing a Good Technical Blog Post

May 1, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Blogging, SQL Documentation, SQL Server

A technical blog post works when it solves one problem with tested code, clear assumptions, a readable result, and honest limits.

Read More
A garden trellis with vines tied on with twine, and one vine leaning against it without any tie

Drawing a Diagram of an Existing Database

April 24, 2008
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Documentation, SQL Server, SQL Server Management Studio

A diagram of an existing database starts with real foreign keys, uses SSMS to reveal relationships, and records the important paths a picture misses.

Read More
A cabinet of seed drawers, each with a tiny window showing what it holds, one red tassel

Documenting a Database With Extended Properties

January 29, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Schema, SQL Documentation, SQL Server

Keep extended properties beside your SQL Server schema, maintain table and column descriptions, and query a useful data dictionary.

Read More
A young tree newly planted and loosely tied to a wooden stake, with a watering can nearby and older trees behind.

Onboarding a New DBA

November 18, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, Professional Development, SQL Documentation

Onboarding a new DBA starts with safe access, a server map, tested runbooks, and a first month of supervised operational tasks.

Read More
A row of moored rowboats in a quiet harbor, with one weathered red dinghy hidden behind the pilings.

Keeping an Inventory of Every SQL Server You Own

July 11, 2007
Pinal Dave
SQL Tips and Tricks
DBA, SQL Documentation, SQL Instance, SQL Server

Build an Inventory of Every SQL Server you own, including hidden instances, owners, versions, recovery details, and a process to keep it current.

Read More
A walker seen from behind at a mountain trail fork, three paths marked by stacked stone cairns

How to Read a T-SQL Syntax Diagram

June 7, 2007
Pinal Dave
SQL Tips and Tricks
Developer, SQL Documentation, SQL Index, SQL Server

Read a T-SQL syntax diagram without guessing: brackets mean optional, braces mean required choices, pipes separate options, and dots repeat items.

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

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