SQL Server Administration and Maintenance

SQH13 Building Perfect SQL Servers, Every Time


3:00pm - 4:15pm

Level: Introductory to Intermediate

Some of the biggest challenges in any large SQL environment are maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. In this session, you'll learn best practices for system settings, file system layout and scheduling maintenance tasks.

By default, SQL Server doesn't install with best practices for every environment. You'll learn the best practices for most SQL Server configurations, and how to automate your SQL Server builds in both physical and virtual worlds. As you may know, completely automating the build process has great benefits, but it also has great trade-offs. You'll benefit from the lessons learned from building a private cloud at a Fortune 100 telecommunications company with thousands of servers.

You'll also learn how use these same methods to ensure your own server build consistency, whether your SQL Servers are in the cloud or on-premises.

You will learn:

  • Best practices for installing SQL Server
  • How to automate SQL Server installations to enforce standards and reduce workload
  • Best practices for building a virtual cloned environment for SQL Servers