Update

Get-DbaKbUpdate

Chrissy LeMaire (@cl), netnerds.net

Get-DbaKbUpdate View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves detailed metadata and download links for Microsoft KB updates from the update catalog Description Searches Microsoft’s update catalog website to retrieve comprehensive information about KB updates including service packs, hotfixes, and cumulative updates. Returns detailed metadata such as supported products, architecture, language, file size, supersession information, and direct download links. Integrates with Get-DbaBuild to provide SQL Server-specific versioning details when available, making it essential for patch management and update research workflows.

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.

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.