Patching

Invoke-DbaAdvancedInstall

Chrissy LeMaire (@cl), netnerds.net

Invoke-DbaAdvancedInstall View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Executes SQL Server installation on a single computer with automated restart handling. Description Performs the complete SQL Server installation workflow on a target computer, including pre and post-installation restart management. This internal function handles copying configuration files to remote machines, executing setup.exe with specified parameters, configuring TCP ports, enabling volume maintenance tasks, and managing required system restarts. It provides detailed installation logging and error reporting to track the success or failure of each installation attempt.

Invoke-DbaAdvancedUpdate

Kirill Kravtsov (@nvarscar)

Invoke-DbaAdvancedUpdate View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS Synopsis Installs SQL Server updates and patches on remote computers with automatic restart management Description Executes SQL Server KB updates on a target computer by extracting patch files, running setup.exe with appropriate parameters, and managing system restarts as needed. This function handles the core installation logic for Update-DbaInstance, processing update actions for specific SQL Server instances or all instances on a machine.

Save-DbaKbUpdate

Chrissy LeMaire (@cl), netnerds.net

Save-DbaKbUpdate View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Downloads Microsoft Knowledge Base updates and patches to local storage Description Downloads Microsoft KB updates, cumulative updates, and service packs from Microsoft’s servers to your local file system. This function handles SQL Server patches as well as any other Microsoft KB updates, making it easy to stage patches for installation across multiple servers. Supports filtering by architecture (x86, x64, ia64) and language, and can download multiple KBs in a single operation.

Update-DbaInstance

Kirill Kravtsov (@nvarscar), nvarscar.wordpress.com

Update-DbaInstance View Source Kirill Kravtsov (@nvarscar), nvarscar.wordpress.com Windows, Linux, macOS Synopsis Installs SQL Server Service Packs and Cumulative Updates across local and remote instances automatically. Description Automates the complete process of applying SQL Server patches to eliminate the manual effort of updating multiple instances. This function handles the entire patching workflow from detection through installation, replacing the tedious process of manually downloading, transferring, and applying updates across your SQL Server environment.