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

Attendee Requirements:

  • You must provide your own laptop computer (Windows or Mac) for this hands-on lab.
  • You will get a training key to register during the session. Once registered, you will then have access to the labs. Every attendee will have their own lab environment.
  • You will need to bring your own device to do the lab exercises; one will not be provided for you. The lab environment is accessed using the conference’s internet connection which has worked well in the past, but it is something that we cannot guarantee will not interfere if something is amiss.
  • All lab exercises will be done via a web browser and you may need to use Remote Desktop (Terminal Services) to access virtual machines. If you are not running a Windows-based PC, you may need to seek out a Remote Desktop equivalent. For the browser-based portions, ensure that you conform to the specifications listed at https://docs.learnondemandsystems.com/tms/connectivity-requires.md?appid=tms. The most common issues are with firewalls or GPOs on corporate laptops that are locked down. We cannot guarantee you will be able to do the labs if you do not check and ensure that your device meets all of the standards at that link as well as the ability to use remote desktop which requires port 3389.
  • In terms of the device you would need to do the labs, anything meeting the software specs is acceptable. There are no specific hard drive space, processor, or memory requirements outside of that. In past classes, Mac and PC laptops work fine and Chromebooks have generally had no issues. iPads and iPad Pros have had issues, so I do not recommend brining that to access the labs.