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
A figure kneels at the edge of a frozen pond, testing the ice with a long pole before crossing.

When to Upgrade: RTM, First CU or Later

June 9, 2008
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Migration, SQL Server, SQL Upgrade

Decide When to Upgrade SQL Server by weighing new features, early defects, support needs, and evidence from your own workload.

Read More
A distant climber on a rocky ledge beside a red rope already anchored and coiled for the descent.

Rolling Back a Cumulative Update Safely

February 18, 2008
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Backup and Restore, SQL Patch, SQL Server

Rolling Back a Cumulative Update needs backups, setup evidence, a tested uninstall path, and special care for databases changed after patching.

Read More
A cook seen from behind tastes from a small trial saucepan while a large covered pot waits beside it.

Testing a Cumulative Update Before Production

September 6, 2007
Pinal Dave
SQL Tips and Tricks
Cumulative Update, SQL Backup and Restore, SQL Patch, SQL Server, Testing

Testing a Cumulative Update means restoring real data, replaying key jobs, comparing plans and timings, and signing off before production.

Read More
Two hands lift a stack of nested ceramic mixing bowls, the largest red bowl holding all the others.

Why SQL Server Has Cumulative Updates, Not Service Packs

August 1, 2007
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server, SQL Service Pack

Understand why SQL Server uses Cumulative Updates instead of service packs, what each CU contains, and how to plan a reliable patch cycle.

Read More
A hand holds a brass key up to the light beside two nearly identical keys on a wooden workbench.

How to Read a SQL Server Build Number

June 7, 2007
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server

Learn how a SQL Server build number identifies the engine release, maps to a cumulative update, and explains differences between two instances.

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

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