From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training about Design, Deploy, and Optimize SQL Server on Microsoft Azure. Unlock the power of Microsoft Azure and master the art of designing, deploying, and optimizing SQL Server with this cutting-edge online live training course!
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 Assistent
- Migrating to SQL Database
- Migrating to SQL Managed Instance
- Log Replay Service
Please checkout the Live Training website Design, Deploy, and Optimize SQL Server on Microsoft Azure for more details about the live training (detailed agenda, date, pricing) and how to sign-up.
Thanks for your time,
-Klaus