SQL Server Features & Components, Full Day Hands-On Labs

SQS01 Hands-On Lab: The A to Z of Cloud-based SQL Server Solutions


9:00am - 6:00pm

Level: Intermediate

Allan Hirt



Microsoft Azure, Amazon AWS, and Google Cloud Platform are either already part of your daily lives or will be soon. Deploying to the public cloud means different things to different people – are you going to use virtual machines (VMs) as part of Infrastructure as a Service (IaaS)? Use the native cloud-based solutions for Platform as a Service (PaaS) where you may just need a database or an instance of SQL Server? Still keep some on premises but extend to the cloud with hybrid solutions? Where do containers fit into the picture? For some solutions, is it a good idea to deploy to the cloud at all?

SQL Server and its databases still need to be made available, reliable, and highly performing up in the cloud. This full day session will cover how to approach planning and deploying SQL Server solutions that utilize the public cloud. The topics that will be discussed include:

  • How the public cloud is both similar and different to deploying on premises
  • 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
  • Best practices, tips, and tricks

As part of the day, you will get hands on experience in addition to the instructional content and demos. You will need to bring your own laptop to do the lab. Specs on what you will need will be sent as it gets closer to the date.

No matter where you are on your journey to the cloud, this day will modernize your SQL Server skills to be able to deploy successfully regardless of your public cloud provider of choice.

You will learn:

  • Understand the considerations for when to use – and when not to use – the public cloud for SQL Server
  • Understand how to make SQL Server available, reliable, and highly performing in the public cloud
  • Understand best practices, tips, and tricks for deploying to the cloud