I Needed to Install 80 SQL Servers…Fast. Here’s How I Did It!

Target Audience:

DBAs and consultants that want to leverage automation to scale themselves to their company’s needs. If you need to install or maintain the configuration of a SQL Servers, this session is for you. No prior knowledge of Desired State Configuration (DSC) is needed.


Challenged with this problem, let me show you how I used PowerShell Desired State Configuration to deploy and configure 80 SQL Servers for a client, fast! For this task, I needed to go from DSC Zero to DSC Hero. In this “notes from the field” session, I’ll share with you how I was able to achieve my client’s goals.

In this session we’ll learn:

  • DSC Fundamentals
  • DSC Resources and where to get them
  • Configuration Data
  • Best practice SQL Server configurations implemented in DSC
  • Leveraging this configuration for Disaster Recovery

Why I Want to Present This Session:

As a consultant I need to provide maximum value to my customers, they don’t need me in a corner clicking next, next…finish to install SQL Server. Further, I want at have a well structured, engineered configuration that I can easily deploy. I want to share this experience with you so you can leverage the same tools to increase your value to your employers or clients.

Additional Resources:


The following two tabs change content below.
Meet Anthony Nocentino, Enterprise Architect, Founder and President of Centino Systems, Pluralsight Author, Corporate Problem Solver and a voracious student of the latest computer science technology. Anthony is only satisfied when he finds the right technology resolution for his client’s business need.  Business today thrives on data – from the C-Suite to the information worker.  Anthony specializes in all things related to data – database systems, virtualization, system and network design and performance engineering.  He designs solutions, deploys the technology and provides expertise on business system performance, architecture and security.    Anthony has a Masters in Computer Science and is working towards a PhD focusing on high performance/low latency data access algorithms on solid state disks.  Anthony is interested in engaging with anyone who strives to understand how data drives business decisions.  He seeks to work with technologists he can teach as he solves the bigger business problems faced by today’s enterprises.
Previous Post
Cardinality Estimator on SQL Server 2014/2016
Next Post
How Often Should You Run Backups and CHECKDB?

6 Comments. Leave new

Howdy sir. A few things I’d think about to refine the abstract:

  • Does the target reader know what DSC is? How much do they need to know going into the session?
  • Can you link them to something that gives a quick intro to DSC so they can see if attending the session makes sense?
  • Is it for on-premises, cloud, or both? (If cloud, any specific cloud vendor, or all?)

You don’t have to answer me in the comments, just thinking through what I’d ask if I was the attendee.


I can always count on you sir, I cleaned up the abstract a bit to address your comments.


Hello Anothony – Is the session viewing, permission based? I dont see the video link for the session or did i miss it in the page?


Any news on this?


    Richard – it didn’t get voted in. If you subscribe to the site’s news, you’ll know when voting opens and you can vote for the sessions you wanna see.


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.