Would You Like to Save Some Time?

Creative Commons - http://www.flickr.com/photos/oter/3663113949/sizes/z/in/photostream/

Sure, we all would!

What if I told you that there was a new project on codeplex that could has saved hundreds of hours for my organization and could do the same for you?  Well, this weekend marks the first public release of the Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server and that is exactly what it’s designed to do. 


I believe that any repetitive task is a potential candidate for automation, and installing SQL Server is no different.  You may say “I already automate my installs using an unattended configuration file”, but that only addresses part of the problem.  What about those changes you have to make prior to the install?  Things like configuring Microsoft Distributed Transaction Coordinator (MSDTC), or changing the TCP Offload Chimney setting?  Then, once your install is complete, your job still isn’t done.  My shop, like most companies, has a list of things that need to be done after the install like setting up Database Mail, creating Operators, deploying standard Stored Procedures, and the list goes on.  What if there was a way to automate the entire process from beginning to end?  Well, now there is…


SPADE is a process that I have created that does exactly that.  The process is PowerShell based and completely customizable for any organization.  I built the system to be folder based, so adding new Pre Install or Post Install tasks is as easy as dropping a new script into a folder. 


The SPADE process is very simple and mimics the same process that you would follow if you were installing manually.  It processes a list of Pre Install tasks, creates the unattended install file for you, installs SQL Server, and then processes a list of Post Install tasks.  The difference is that SPADE leverages the awesomeness that is PowerShell to modify those configurations for you, so you don’t have to navigate through multiple different application interfaces to get it done.  Fewer clicks means that you can move on to something else faster.


You can download SPADE from http://sqlspade.codeplex.com


The initial beta release is available now, so what are you waiting for?

The Catch…

This system currently supports Standalone (Not clustered) installs of SQL Server 2005, 2008, and 2008R2.  I am currently working on support for “Denali” and will have that available once it has RTM’d.  Also, while I have tested the Database Engine components and Integration Services, I have not tested the install of Reporting Services or Analysis Services yet.  Any volunteers would be greatly appreciated.


This is beta software, and should be treated accordingly.  My team has used this software in my organization for many months and saved hundreds of hours in the process, but every environment is different.  Once I have received sufficient feedback and addressed any issues that have been identified I will remove the “Beta” designation.

Many months have gone into preparing this release and I hope that you find it as valuable for automating SQL Server installs as I have.

2 thoughts on “Would You Like to Save Some Time?

Leave a Reply

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