Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server Configuration and Deployment with Powershell DSC

PASS Data Community Summit via YouTube

Overview

Explore the power of Desired State Configuration (DSC) in PowerShell for SQL Server deployment and management in this comprehensive conference talk. Dive into the challenges of manual SQL Server instance provisioning and post-configuration steps, and learn how DSC can streamline these processes. Discover the core principles of Infrastructure as Code (IaC) and how they apply to Windows environments. Gain insights into the various components of DSC and learn how to set up a pull server for efficient management. Watch as the speaker demonstrates the deployment and setup of a two-replica availability group with a single button push. Understand how DSC can help monitor, report, and automatically correct configuration drift, ensuring your systems maintain their expected configurations over time. By the end of this talk, you'll be equipped with the knowledge to implement DSC for more consistent, faster, and error-free SQL Server deployments and configurations.

Syllabus

SQL Server Configuration And Deployment With Powershell DSC - Brandon Leach

Taught by

PASS Data Community Summit

Reviews

Start your review of SQL Server Configuration and Deployment with Powershell DSC

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.