SQL Server Configuration and Deployment with Powershell DSC - Brandon Leach

Title: SQL Server Configuration and Deployment with Powershell DSC

Abstract: 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 and how to use them. We will then use DSC to deploy and configure SQL Server with the push of a button.

Speaker: Brandon Leach

Speaker Bio: Brandon Leach, Vice President in Database Operations Financial Company X
A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

Blog -
LinkedIn - https://www.linkedin.com/in/sqlservernerd/
Twitter - @SQLServerNerd

Agenda:

• 12:15-12:30pm: Sign-in & network
• 12:30-12:35 pm: Announcements & Intro
• 12:35-1:35pm: Presentation
• 1:35-2:00pm: Q&A, wrap-up

Location:
Online. You must register for the link