SQL Server Administration & Maintenance, Workshops

SQF01 Workshop: Architecting Scalable, Available, and Manageable SQL Server Deployments


8:00am - 5:00pm

Level: Intermediate to Advanced

Allan Hirt



Whether you are running SQL Server on premises, in a public cloud, or as part of a hybrid solution that spans both, your solutions must meet three main criteria:

  1. Perform well
  2. Be up and running meeting the company's availability requirements
  3. Be relatively easy to manage

Deployments that are up but are slow, or ones that perform well but are down every other day are useless. Add to that solutions that are complex and hard to manage often break and cause downtime and/or performance issues no matter how good they look in a Visio diagram.

How do you balance performance, availability, and manageability to achieve all your goals in a single design for SQL Server? How do you migrate from A to B with minimal downtime? How do you manage cost when considering a cloud- or hybrid-based deployment? All of these topics and more will be tackled.

This full day will not only provide tips and tricks on how to achieve successful deployments based on real world experience, but show and discuss relevant features and technologies that you should be aware of no matter how you deploy and use SQL Server - Windows Server, Linux, physical, virtual, IaaS, or PaaS.

You will learn:

  • Understand the considerations for when to use – and when not to use – the public cloud for SQL Server
  • How to plan availability for SQL Server solutions that are hybrid, IaaS, or PaaS
  • How to ensure that you get the performance required from your SQL Server solutions