SQL Server Administration and Maintenance

SQH01 Managing SQL Server at Scale


8:00am - 9:15am

Level: Intermediate

Being a DBA is hard enough work, but when your team manages more than 500 servers you will encounter some unique challenges. In this session, you'll learn techniques employed by a large enterprise to simplify deployments and manage performance, including:

  • Automation, Standardization and Exceptions
  • Private Cloud techniques
  • Tools
  • Scale Out versus Scale Up
  • Hybrid solutions
  • DevOps, Teamwork, Negotiation, Collaboration and War
  • Finally 10 Tips on scaling SQL Server within your organization

You'll learn:

  • How to reduce overall effort level of managing SQL Server in your environment
  • Techniques for automating common SQL Server tasks to reduce daily workload
  • Best approaches for scaling SQL Server, both on premises and in the cloud