SQT09 Building Perfect SQL Servers, Every Time


2:00pm - 3:15pm

Level: Introductory to Intermediate

Join Joey as he shares his tips and tricks on building perfect SQL Servers.

One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You will hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how to use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.

You will learn:
  • Best practices for configuring SQL Server
  • How to script your SQL Server installation process so it happens in a reliable, repeatable fashion
  • Lessons from building a private cloud at a major telecommunications company