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 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
A fingertip tracing one dark growth ring on a freshly cut tree stump in a forest clearing

Checking the Update History of an Instance

March 7, 2007
Pinal Dave
SQL Tips and Tricks
DBA, SQL Log, SQL Patch, SQL Server

Reconstruct SQL Server update history from Setup Bootstrap logs, startup error logs, and the current build when no patch ledger exists.

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

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