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 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
An old oak with a propped limb inside a low fence with one gate, a young sapling planted nearby.

Protecting an Instance You Cannot Patch Any More

August 8, 2008
Pinal Dave
SQL Tips and Tricks
SQL Migration, SQL Patch, SQL Server, SQL Server Security, SQL Upgrade

Protect an Instance You Cannot Patch with isolation, least privilege, disabled features, tested backups, and a firm retirement date.

Read More
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
Previous 1 2 3 4 Next
  • Books
  • Testimonials
  • Privacy Policy

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