On November 27 – 28, 2024 and on December 4, 2024 I will run two SQLpassion Live Trainings about SQL Server on Microsoft Azure and SQL Server Availability Groups.
SQL Server on Microsoft Azure – Course Overview:
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.
- Microsoft Azure Fundamentals
- Overview
- Azure Storage
- Service Tiers
- Azure Regions and 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/li>
- 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
- Geo Replication
- Monitoring SQL Database through DMVs
- Automatic Tuning Options
- Query Store
- 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
- Data Migration Assistant
- Migrating to SQL Database
- Migrating to SQL Managed Instance
- Log Replay Service
SQL Server Availability Groups – Course Overview:
Achieving High Availability with previous versions of SQL Server was always complex: you had Clustering, Database Mirroring, Log Shipping, and Replication. Beginning with SQL Server 2012 Microsoft changed everything and introduced a new High Availability technology called Availability Groups. During this Live Training you will learn how to install, configure, and manage fault-tolerant installations of SQL Server in combination with Availability Groups.
- Introduction
- Installation & Configuration
- Availability Groups
- Availability Modes
- Failover Modes
- Working with Availability Groups
- Active Secondaries
- Quorum Configuration
- Automatic Seeding
- Load Balancing
- Troubleshooting & Monitoring
Please checkout the links for the SQL Server on Microsoft Azure and the SQL Server Availability Groups Training for more details about the online training (detailed agenda, date, pricing) and how to sign-up.
Please use the coupon code “SQLpassion_10%” until August 31, 2024 to get a 10% discount for each online training.
Thanks for your time,
-Klaus
