Design, Deploy, and Optimize SQL Server on Microsoft Azure

Key Concepts Covered in this Course

Klaus Aschenbrenner

Microsoft Certified Master for SQL Server

I work with Microsoft SQL Server for more than 20 years, and I provide with my company SQLpassion consulting and training services around the whole world.

Since 2012 I’m also a Microsoft Certified Master for SQL Server.

Elevate Your Skills with My Exclusive Online Training Course!

Unlock the power of SQL Server on Microsoft Azure and master the art of designing, deploying, and optimizing SQL Server with my cutting-edge online training course!

Learn expert strategies for crafting robust SQL Server architectures in the Azure environment. Explore best practices for scalability, security, and performance. Dive into the step-by-step process of deploying SQL Server seamlessly on Azure. Gain hands-on experience with real-world deployment scenarios. Uncover the secrets to fine-tuning SQL Server performance in the Azure cloud. Maximize efficiency and responsiveness with advanced optimization techniques.


Amazing Course

โ€œIn this workshop Klaus manages to cover everything you need to know about how to run SQL Server on Microsoft Azure. With real-life examples it also becomes easy to follow. I would highly recommend this course to every DBA or developer.โ€

Mark from Montfoort, Netherlands

Course Details

Course Duration

2 Days

Course Price

EUR 1290 incl. 20% VAT

Course Level


Agenda & Breakdown

Day 1 – Azure SQL Database

  • ๐ŸŒ Microsoft Azure Fundamentals
    • Overview
    • Azure Storage
    • Service Tiers
    • Azure Regions & Region Pairs
    • Availability Zones
  • ๐Ÿš€ย SQL Server on Azure Virtual Machines
    • Virtual Machine Configuration
    • Storage Configuration
    • Extending On Premises Availability Groups to Microsoft Azure
  • โœจ Azure SQL Database
    • Overview
    • Creating a new SQL Database
    • Restoring existing On Premises databasesย 
    • Security Configuration & Connections
    • Compute and Storage Configuration
  • ๐ŸŽ“ Azure SQL Database Advanced Concepts
    • Elastic Pools
    • Serverless SQL Databases
    • Geo Replication
    • Failover Groups
    • Readable Secondaries
    • Automatic Backups and Retention Policies
    • Point in Time Recovery
  • ๐Ÿ‘‰ Performance Monitoring and Troubleshooting
    • Monitoring Database Metrics
    • Creating and configuring Alerts
    • Monitoring SQL Database through DMVs
    • Automatic Tuning Options
    • Query Store

Day 2 – Azure SQL Managed Instance

  • ๐ŸŒ Azure SQL Managed Instance
    • Overview
    • Creating a new SQL Managed Instance
    • Restoring existing On Premises databases
    • Security Configuration & Connection
    • Compute and Storage Configuration
  • ๐Ÿš€ Azure SQL Managed Instance Advanced Concepts
    • Virtual Cluster Architecture
    • Connectivity Architecture
    • Managed Instance Links
    • High Availability
    • Automatic Backups & Retention Policies
    • Failover Groups
  • โœจย SQL Hyperscale Service Tier
    • Overview
    • Architecture
    • Migrating to the Hyperscale Service Tier
    • Hyperscale Backup and Restore Operations
    • Implementing Read Scale-Out
  • ๐ŸŽ“ย Migrating SQL Server to Azure
    • When to choose
      • Azure Virtual Machines
      • SQL Database
      • SQL Managed Instance
      • Hyperscale Service Tier
    • Data Migration Assistent
    • Migrating to SQL Database
    • Migrating to SQL Managed Instance
    • Log Replay Service

This 2 day ong webinar is primarily for DBAs, Developers, and Consultants who want to learn how to run SQL Server on Microsoft Azure.

Date & Location

April 24 – 25, 2024

EUR 1290 incl. 20% VAT
Cancellation Fee: 100%
Course Language: English
Location: Online Live Class (Microsoft Teams)

๐Ÿ” Secure Your Spot Today!

Don’t miss this opportunity to elevate your SQL Server skills and become a Microsoft Azure virtuoso. Secure your spot now and embark on a transformative learning journey!