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 worker seen from behind lays tools beside a closed stretch of railway while a distant train waits at a signal.

Scheduling Patch Windows Without Surprises

October 15, 2011
Pinal Dave
SQL Tips and Tricks
AlwaysOn, DBA, SQL Patch, SQL Server, SQL Server Agent

Scheduling Patch Windows requires realistic restart time, failover steps, job coordination, backup checks, and clear stop rules.

Read More
A passenger train waiting on the main line at dusk while a short fast train passes on a side track under a red signal lamp

Staying Current Without Chasing Every Update

January 15, 2010
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server, SQL Service Pack

Staying current on SQL Server takes a repeatable CU cadence, fast security response, and a patch policy your team can actually keep.

Read More
A farmer seen from behind holds a tarpaulin at the edge of a hay field as a storm cloud builds on the horizon.

Explaining Database Risk to Managers

January 7, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Backup and Restore, SQL Patch

Explain database risk to managers by turning backups, patching, and capacity into clear impact, likelihood, cost, and action choices.

Read More
A row of blossoming apple trees along a brick wall, with two bare trees and a gardener walking toward them.

Tracking Which Updates Every Server Has

January 27, 2009
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Monitoring, SQL Patch, SQL Server

Tracking Which Updates each SQL Server runs takes a dated inventory table, SERVERPROPERTY snapshots, and a report of instances behind the target.

Read More
Floured hands fold dried fruit into bread dough on a wooden board, with a warm oven waiting behind.

Slipstreaming Updates Into a New Install

October 29, 2008
Pinal Dave
SQL Tips and Tricks
Cumulative Update, SQL Patch, SQL Server, SQL Server Installation, SQL Setup

Slipstreaming Updates lets SQL Server Setup apply a selected CU during installation with UpdateSource and avoids a separate patch pass.

Read More
A narrowboat rising in a canal lock, one of three locks stepping up a green hillside.

Patching an Availability Group in the Right Order

October 4, 2008
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Cumulative Update, SQL High Availability, SQL Patch, SQL Server

Patching an Availability Group safely means updating secondaries first, checking synchronization, failing over, and updating the old primary.

Read More
A figure closes red storm shutters on seaside cottage windows facing an approaching storm.

Responding to a SQL Server Security Bulletin

September 30, 2008
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server, SQL Server Security

A SQL Server Security Bulletin should trigger exposure checks, ordered patching, verified recovery, and a clear management update.

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

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