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
Gouache painting of an interrupted installer beside a repair checklist and tools

Visual Studio 2010 Shell Error During SQL Server Patching: Missing Package

May 12, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Patch, SQL Setup, Visual Studio

A Visual Studio 2010 Shell error interrupted a SQL Server patch in a 2017 case. The setup screen named the component, but the component log named the missing package. This post shows how to read the logs, decode the Windows Installer error and match the package before any repair.

Read More
A hand pulls a clean wooden skewer from the center of a freshly baked cake on a cooling rack.

Checking That a Patch Really Installed

May 18, 2015
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server, SQL Setup

Checking That a Patch Really Installed means comparing full versions, reading Setup summary logs, and confirming the startup error log.

Read More
A temporary wooden footbridge crosses a river from an old cottage to a newly built house.

Extended Security Updates Explained

October 12, 2014
Pinal Dave
SQL Tips and Tricks
SQL Licensing, SQL Migration, SQL Patch, SQL Server, SQL Server Security

Extended Security Updates give eligible older SQL Server releases limited critical security coverage while you complete a migration.

Read More
A walker seen from behind pauses where a woodland footpath splits into a narrow path and a wider one.

GDR or CU: Choosing Your Update Branch

June 14, 2014
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server, SQL Server Security

Choose GDR or CU for SQL Server by understanding security and cumulative branches, checking the exact build, and testing a branch change.

Read More
A line of falling wooden dominoes on a floor, with one red domino turned sideways to stop the chain.

Automating SQL Server Patching With PowerShell

November 18, 2012
Pinal Dave
SQL Tips and Tricks
Cumulative Update, PowerShell, SQL Patch, SQL Server, SQL Setup

Automating SQL Server Patching with PowerShell means staging a verified package, running Setup quietly, checking logs, and stopping on failure.

Read More
A model ship floats in a long indoor water tank as small waves roll toward it from the far end.

Keeping a Patch Test Environment Honest

September 23, 2012
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Patch, SQL Server, SQL Server Configuration, Testing

A Patch Test Environment must match production data, settings, jobs, and versions closely enough to reveal real patch risks.

Read More
A staple remover exposes different metal staple shapes beside one intact fastening

Is This Instance Patched? Reading ProductUpdateLevel and Build

August 19, 2012
Pinal Dave
SQL Tips and Tricks
Cumulative Update, SQL Instance, SQL Monitoring, SQL Patch

An update label is one clue, the build number is the identity. I show how to read both, compare builds safely, and avoid the NULL typo trap.

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

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