SqlServerDsc vs. win_powershell: Which Pattern Should You Use?

Description:
When automating SQL Server with Ansible, which pattern should you reach for?
1. Dedicated SqlServerDsc resources: Use natively for the 80% of baseline settings it already covers.

2. SqlScriptQuery (T-SQL): Best for multi-statement T-SQL scripts like standard maintenance jobs.

3. State-aware win_powershell: One self-contained .ps1 script with honest --check, red/green --diff, and custom JSON payloads when no DSC resource exists.

#SQLServer #Ansible #PowerShell #SqlServerDsc #DBA