The following information is based upon SQL Server 2025 CTP 2.1 and is subject to change upon release. Recently, I've been updating the Ansible playbooks and the mssql Ansible role to support SQL Server 2025.  This role and playbook are used throughout the Ansible for SQL Server DBAs course, and...

If you're automating your SQL Server 2025 installations on Windows with Ansible over SSH (passwordless login), you might hit a cryptic error that stops you in your tracks. I recently ran into this, and the solution is all about understanding Kerberos delegation. The Problem: A Cryptographic Fail...

In my last post, we defined the prerequisites needed for patching.  Before applying the patch, we need to make sure the variables are set and that we're dealing with a healthy AG.  With those out of the way, we're ready to build out the remaining tasks.   tasks/cleanup.yml tasks/failback.yml ...

Defining the prerequisites before you start patching is extremely important.  I'm not talking about making sure your Ansible control node is set up and testing access to your SQL Server AG replicas (very important as well, but a different subject).   Nope, I'm talking about making sure that the ...

Ansible's inventory file is fundamental for defining and organizing the servers to be managed in a SQL Server Availability Group.  It serves as the "address book" for Ansible to use when patching these instances.  Next up are roles.  We'll build an example role as part of this blog series (disc...

In my previous post, we explored the concept of rolling updates for SQL Server Availability Groups and how Ansible can transform this complex process into a streamlined, repeatable operation. We discussed the benefits of automation and outlined a high-level strategy for implementing this approach...

Over the past few weeks in the AutomateSQL Insiders Community, we've been discussing SQL Server patching.  More specifically patching Availability Groups in a rolling fashion.  This technique keeps your replicas up to date while maintaining minimal downtime.  Automated patching is nothing new.  ...

Service management is a pretty common task for both DBAs and Windows administrators.  If you're like me, you've spent countless hours remoting into servers just to check the status of a service or to manually restart it.  Perhaps you've needed to disable a service briefly while troubleshooting or...

Windows patching is usually a topic left for Windows administrators.  But what if, as a DBA, you're tasked with patching both the OS and SQL Server?  That scenario is common in smaller or cross-functional IT teams where boundaries between roles aren't so clear.  DBAs can't ignore OS patching for ...

My Early Challenges with Ansible on Windows When I was getting started with Ansible back in 2017, I ran into issue after issue.  Coming from a Windows background, trying to use a tool that was primarily used on Linux meant there was little documentation to reference.  You might be saying, "Why d...