Install SQL Server using Powershell Desired State Configuration (DSC)


Introduction

As per Microsoft, Desired State Configuration  (DSC) is a management platform in PowerShell that enables you to manage your IT and development infrastructure with configuration as code.  DSC allows administrators to define the desired state of a server or application, and automatically configure and manage that state over time. With DSC, you can define a configuration that specifies the exact software, settings, and policies that should be present on a given machine, and then apply that configuration to one or more servers using PowerShell.

This article will explore how to install SQL Server remotely using DSC (Desired State Configuration),