SQL Server: Advanced Training for Azure VM Deployments
Trainer(s): David Pless, Pam Lahoud, Amit Khandelwal, Tejas Shah, & Aditya Badramraju
Provider: DPS 2020 (Data Platform Summit)
Duration: 8 Hours 07 Mins
Offer Price: USD 54.5 (75% OFF)
Discount Code: HAPPY75
(GST + Internet Transaction Fee additional)
Abstract: SQL Server: Advanced Skilling for Azure VM Deployments
Many customers are looking to migrate their SQL Server instances and SQL based applications to the cloud to take advantage of scalability, flexibility, advanced high availability and disaster recovery options, optimized licensing scenarios, access to Azure monitoring & Azure advisory technologies, and other marketplace tools & capabilities in the Azure fabric.
The decision has been made to bring your solution to the cloud, but then the challenge many customers experience is knowing how to properly size their environments, understanding the best strategy for availability, and how to start their migration journey.
In this workshop we will address all of these key challenges and the best practices on migrating your SQL Server workloads to Azure virtual machines.
We will cover migration strategies starting with assessing the state of your current environment. We will then target our evaluation results to a destination platform in Azure. We will learn about proper virtual machine sizing and the VM classes, proper tuning for Windows and Linux platforms, and how to take best advantage of licensing practices in Azure.
We will then focus on high availability and disaster recovery options, best practices, monitoring and management. We will address modern HADR approaches for SQL Server including Always On Availability Groups, Failover Cluster Instances (FCI), Log Shipping, and supported replication models. We will also cover virtual machine optimization best practices and deployment considerations for hybrid configurations.
This workshop will be an engaging, real-world examination of modernizing your most critical SQL based platforms.
Note: This recorded class is available in the format of a video course. Content is presented in modular videos. Learn more.