Kevin Kline who spoke a few years ago at WISSUG, (http://kevinekline.com/) tweeted about SPADE - http://sqlspade.codeplex.com/ Scripted PowerShell Automated Deployment Engine for SQL Server, and knowing that Jon is going to speak on PowerShell topics in March, I thought I can do installations... so I volunteered to present sqlSPADE to our group.
So I have downloaded all the files and am setting it up for execution in a VPC environment. I know I am going to learn a bunch in this process. I expect it to be really valuable for my future, and hopefully others too. :)
"SPADE simplifies the process of standing up a new SQL Server instance by applying standard Operating System pre-configurations, Installing SQL Server and then applying post-configurations and creating standard objects.
SPADE is a tool that is designed to speed up your standard deploymets of SQL Server. You may be saying "But I can already do an unsattended install"...but that's not all that's involved in most server builds. There are Operating System configurations like Microsoft Distrubuted Transaction Coordinator (MSDTC), Local Security Policy and others. I'm sure that you also have standard SQL objects that need to be deployed like Stored Procedures, Agent Jobs, Operators, etc. All of this can be done by SPADE automatically by running 1 simple PowerShell script."
I think I heard somewhere tonight "Simple doesn't necessarily mean easy" maybe it was @onpnt who said it at the @madpass tonight. I am looking forward to this project.
No comments:
Post a Comment