DPS 2020 Training Class – SQL in Azure VM – by David Pless, Pam Lahoud, Amit Khandelwal, Tejas Shah, Aditya Badramraju
Visit DPS 2020 More Training Classes Book Now
|
Pre-Con Title |
SQL Server: Advanced Training for Azure VM Deployments |
|
Track(s) |
Data Administration |
|
Tags |
#SQLServer #SQL2019 #Azure #IaaS #Migration #BestPractices #Sizing #Performance #Optimization #Licensing #HighAvailability #AlwaysOn #Clustering #Windows #Linux #Virtualization #AzureVM #SQLVM |
|
Level |
Intermediate |
|
Trainer/Speaker |
David Pless , Pam Lahoud , Amit Khandelwal , Tejas Shah, Aditya Badramraju |
|
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. We look forward to seeing you there! |
| Modules/Topics |
SQL Server 2019: Advanced Skilling for Azure IaaS Deployments Module Overview: Module 1 – SQL Server 2019 Overview
Module 2 – SQL Server Migration strategies for IaaS
Module 3: SQL Server best practices for common workloads on IaaS (90 min.)
Module 4: Modern HADR Approaches for SQL in IaaS (90 min.)
Module 5: SQL Server on IaaS – (Monitoring and Management)
Module 6: IaaS/PaaS hybrid deployments for scalability
|
|
Attendee Pre-requisite (if any) |
Pre-requisite: There are no pre-requisites though familiarity with SQL Server 2016+ and virtualization is helpful. |
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day). Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
