SQL Server Administration and Maintenance

SQT16 Using PowerShell to Quickly Deploy New SQL Server Instances

11/19/2013

4:15pm - 5:30pm

Michael Wells

Database Administrator

Raymond James

As much as you love SQL Server, do you cringe whenever you hear you'll need to stand up yet another SQL Server instance? Sure it's fun, but who has the time? Maybe you've thought there must be a better way of doing this. You can generate an unattended install file, but what about all the other tasks that will need to be done?

In this session, we'll explore a process that was created to truly automate not just the SQL Server install, but all the configurations and the deployment of your organization's standard objects all using a free, open-source set of PowerShell scripts that you can download and use today. This session will review the process that has saved hundreds of hours and ensures a SQL Server instance that meets your company's standards.

You will learn:

  • Multiple methods of automating tasks with PowerShell scripts.
  • Detailed explanation of a real-world example of an automation framework
  • Have access to the code, which they can take back and immediately begin using within their environment