Description

SQL Server: Advanced Training for Azure VM Deployments by dpless

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:

Module 1 – SQL Server 2019 Overview

• Topic 1: Features and Capabilities
• Topic 2: Opportunities in Azure

Module 2 – SQL Server Migration strategies for IaaS

• Topic 1: Assessing the source environment
• Topic 2: Migrating data and SQL objects to the cloud

Module 3: SQL Server best practices for common workloads on IaaS (90 min.)

• Topic 1: Sizing and VM types
• Topic 2: Performance Guidelines
• Topic 3: Resource Provider Benefits
• Topic 4: Demystifying licensing in SQL Server 2019

Module 4: Modern HADR Approaches for SQL in IaaS (90 min.)

• Topic 1: Always On Availability Groups
• Topic 2: Fail over Cluster Instances (FCI) in Azure
• Topic 3: Log Shipping
• Topic 4: Supported Replication Models
• Topic 5: HADR hybrid configurations
• Topic 6: Azure HADR options

Module 5: SQL Server on IaaS – (Monitoring and Management)

• Topic 1: Managing SQL Server on IaaS both for Windows and Linux
• Topic 2: Comparing on-prem virtualization to Azure

Module 6: IaaS/PaaS hybrid deployments for scalability

• Topic 1: Application scenarios
• Topic 2: Business Intelligence scenarios