SQL Server Implementation Frameworks From Dev to Prod

Speaker Prakash Heda of Advent Software

You'll learn about a best practice framework that alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

There are many variables to consider when supporting SQL Servers in the real world, including:

• Cloud systems (Microsoft Azure/Amazon AWS), virtualization (VMware/HyperV), physical servers

• Different versions of SQL Servers, and different editions (Standard/Enterprise)

• Service packs and specific Hotfixes

• Configuration differences based on OS/Memory/Disk configuration

• Different products need specific configurations and features of SQL Server

• Post installation steps and default access

The best practice framework will get us past the complexities and provide us with the following capabilities and benefits:

• A Process framework configured to support the above requirements

• Flexibility to easily add new configurations

• A consistent experience to all environments, allowing users to do their implementations without having to worry about OS, SQL Server, and access requirements

• Every SQL server installation can be configured in advance to use the best of OS/Disk/Memory resources

• Necessary features can be enabled in advance to provide optimum performance

• Standard implementations simplify troubleshooting

• Support for predefined OS templates with Disk configurations

• All necessary tools can be installed and configured for use in advance

Prakash Heda works as Database Team Lead at Advent Software (http://www.advent.com/). His expertise includes Performance Tuning + Troubleshooting, High Availability, SAN configuration and Windows administration. He has managed enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash is MCDBA and MCITP certified and he specializes in administration & development using VB/ASP/SSIS for SQL Server 2000 - 2014. He's a frequent presenter at PASS groups, SQL Saturdays, and an avid Tweeter, blogger, and runner.