IEAzure: Immersion Event on Azure SQL Database and Azure VMs

Overview

This 3/400-level, 2-day, SQL Server training class is designed to help you gain a deep understanding about Microsoft Azure, including Azure virtual machines and Azure SQL Database.

The class will give you a wealth of practical knowledge on creating and configuring Azure virtual machines as well as installing and configuring Microsoft SQL Server on those virtual machines. You’ll learn about compliance, networking, active directory integration, maintenance considerations, high availability and disaster recovery options, and how to scale performance. Various billing considerations and licensing options for SQL Server on Azure virtual machines will be covered in detail.

The class will then dive deep into Azure SQL Database, covering its numerous features such as restore services, Dynamic Data Masking, Row-Level Security, Always Encrypted, Query Store, Index Advisor, and Geo-Replication. We’ll also discuss what I call “unsupported features” (things you may be used to the on the box version of SQL Server that Azure SQL Database does not have) and explore the various Azure SQL Database pricing tiers and using the DTU calculator.

You’ll learn how to create Azure SQL Databases and methodologies for migrating your on-premises databases to Azure, different ways of connecting to Azure and methodologies for tuning, plus maintenance considerations and built-in/external monitoring and alerting.

Finally, you’ll get a high-level introduction to additional Azure features such as Azure SQL Database Warehouse, Azure Data Factory, and Power BI.

This course will provide you with enough knowledge and material that when you get back to the office, you’ll feel comfortable to help plan and implement a migration to Azure virtual machines and/or Azure SQL Database.

Instructor: Tim Radney

Need Help Justifying Training? Here’s a letter to your boss explaining why SQLskills training is worthwhile and a list of community blog posts about our classes.

Ready to register? Please see our Immersion Events Schedule for class dates and our comprehensive Immersion Events F.A.Q. for class costs and other frequently asked questions.


Curriculum

Module 1: Azure Virtual Machines

Understanding the technical and business benefits of leveraging Azure virtual machines is a critical part of making a decision of whether to migrate to the cloud. Topics covered include:

  • Compliance
  • Networking
  • Active Directory integration
  • Installing SQL Server
  • Configuring SQL Server
  • Maintenance considerations
  • HA/DR options
  • Performance scaling
  • Billing considerations and licensing

Module 2: Migrating to Azure Virtual Machines

Migrating to Azure virtual machines shouldn’t be a stressful task. By properly planning, and selecting the correct size of virtual machine, this should be an easy process. Topics covered include:

  • Collecting on-premises data for sizing
  • Benchmarking Azure virtual machines
  • Choosing the correct size of virtual machine
  • Migration strategies
  • Pros and cons

Module 3: Azure SQL Database

Understanding Azure SQL Database and how it differs from on-premises SQL Server is key to feeling comfortable with migrating production databases to a relational database cloud solution. Topics covered include:

  • Overview of Azure SQL Database
  • Features:
    • Restore services
    • Dynamic Data Masking
    • Row-Level security
    • Always Encrypted
    • Query Store
    • Index Advisor
    • Geo-Replication
    • Elastic pools
  • Unsupported features
  • Azure pricing
  • Creating Azure SQL Databases
  • Maintenance considerations
  • Automation
  • Monitoring and alerting

Module 4: Migrating to Azure SQL Database

Migrating to Azure SQL databases isn’t much different than migrating to Azure virtual machines. You need to know your workload and select the correct size of environment. By properly planning and selecting the correct configuration, this should be an easy process. Topics covered include:

  • DTU Calculator
  • Migrating databases to Azure SQL Database
  • Tuning options
  • Connectivity

Module 5: Additional Azure Features

There is more to the Microsoft Azure platform than just virtual machines and Azure SQL Database. Knowing several of the other key products in Azure can help you build a full data platform solution in the cloud. Topics covered include:

  • Azure SQL Database Warehouse
  • Azure Data Factory
  • Power BI

Ready to register? Please see our Immersion Events Schedule for class dates and our comprehensive Immersion Events F.A.Q. for class costs and other frequently asked questions.


Questions?

If you have any questions not answered by our F.A.Q., please contact us.