SQL Server Patching Made Easy with Ansible

Patching SQL Server has never been more crucial, with Microsoft regularly rolling out updates to fix bugs and address security vulnerabilities. But how can you make patching easier through automation? In this video, we’ll dive into:

1. The differences between Windows Update and Microsoft Update.
2. How to use Group Policies to ensure updates for software like SQL Server can be installed using Microsoft Update. And how to make sure they don't get installed at random times.
3. An example Ansible playbook that simplifies SQL Server patching using the win_update module.

DBA Challenges - HTTP://www.dbachallenges.com

Blog Post - https://www.automatesql.com/blog/ansi...

Chapters:
00:00 Introduction
01:03 Windows Update vs Microsoft Update
02:45 Default Group Policy Review
05:19 Ansible Playbook review
08:11 Demo - Patching
12:58 Additional resources