SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Universal SQL Installations Framework (Script review and Demo)

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


Prakash Heda works as Sr. Database Administrator at Advent Software. His expertise includes Performance Tuning/Troubleshooting, high availability, SAN configuration and windows administration. He has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS using SQL Server 2000, 2005 and 2008/R2 and SQL server 2012. He is an active member of PASS, SQL Saturday. He’s a frequent presenter at user groups, SQL Saturdays, and other community events. He is also an avid tweeter, blogger and runner.


Leave a comment on the original post [sqlfeatures.com, opens in a new window]

Loading comments...