Vice President in Database Operations Financial Company X Greenwich, Connecticut
Provisioning a new SQL Server instance is not just about the install. Often times we have to go through a litany of post configuration steps that must be performed. When we do this manually we are far more likely to make mistakes.
Additionally configuration can change over time. These changes need to be managed and unexpected changes can cause issues. Can you say for certain that your systems are configured exactly as you expect?
Desired State Configuration (DSC) in Powershell is a key tool for moving towards a culture of Infrastructure as Code (IaC) in a windows environment. It can help make your deployments more consistent while speeding them up. Additionally it can help you monitor, report, and correct configuration drift automatically.
In this session we will go over the core principles of Infrastructure as Code, the various components of DSC, how to set up a pull server. We will also use DSC to deploy and setup a two replica availability group with the push of a button.
Learning Objectives:
Teach basic principals of Infrastructure as Code (IaC)
Teach basics of DSC and components
Show how DSC integrates into the change management process