Universal SQL Installations Framework (Script review and Demo)

Prakash Heda, 2015-09-18

on 19th sep 10.00 am pst, i will be speaking on “universal sql installations framework” @ sqlsaturday, san diego!!, if you are in the area i hope to see you…

pass sqlsaturday’s are free 1-day training events for sql server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers and sponsors. whether you’re attending a sqlsaturday or thinking about hosting your own, i think you’ll find it’s a great way to spend a saturday – or any day.

sqlsaturday – san diego – 19 sep 2015

event schedule

universal sql installations – part 1 (10 am to 11 am)

universal sql installations – script review & demo (11:15 am to 12:15 pm)

register here

session feedback

scripts repository – github

session detail:

i will show you how to do multiple versions of sql server installations using single scripts with all best practices baked in, this session will first discuss process framework, prerequisites and then followed up with script review and live demo of installing diff version of sql servers along with diff os using single line command which ensure environment consistency and optimal performance across dev/stage/qa/production.

you’ll take-away script to install different versions of sql server on diff os systems with utmost ease. this script allows anyone in it to install sql systems with best practices baked into it which ensure all sql installation can be streamlined and with a single line command can install any of the below combinations:

• windows 2008r2/2012/2012r2

• sql 2016ctp2.3/2014/2012/2008r2 (enterprise/standard/developer editions)

• any sql service pack/ cumulative updates / hotfix combination

• vmware/hyper-v/azure vm/aws ec2/physical servers

• implement best practices and configuration based on available resources for dedicated sql server environments

you’ll learn how to:

• install different versions of sql server on supported os systems, and readymade scripts to do so

• install sql server systems following best practices and new default which makes more sense

• ensure consistent sql server support environments help improve dba productivity and reduce production issues

• easily add new sql server configurations to support new applications and new versions of sql servers

• identify support situations where different types of applications need dedicated sql servers

• ensure perfect consistency across dev/qa/stage/production env and assure developers of the same





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads