In today’s data-driven world, ensuring your SQL Server is always available, recoverable, and resilient is a top priority—whether it’s running on-premises, in the cloud, or across hybrid environments. SQL Server 2025 builds on Microsoft’s long-standing commitment to data protection and availability, delivering innovative features to simplify HA/DR configuration, enhance performance, and ensure business continuity across any infrastructure.
Join this session to explore how SQL Server 2025 empowers you to design and implement robust HA and DR solutions tailored to your needs.
We’ll cover:
New Features in SQL Server 2025:
- Persisted Statistics on Secondary Replicas: Ensure consistent performance during failovers.
- Optimized Locking: Boost concurrency and uptime with TID Locking and Lock After Qualification.
- Fabric Mirroring: Achieve near real-time replication to Microsoft Fabric’s OneLake for DR and zero-ETL analytics.
- Automatic Backups via Azure Arc: Streamline disaster recovery with cloud-managed automation
Azure-Specific HA/DR Options:
- Simplify business continuity in the cloud using Availability Groups, clusters, log shipping, and the SQL IaaS agent extension—going from zero to highly available in minutes.
Hybrid and On-Premises Enhancements:
- Leverage improvements from SQL Server 2022 and beyond, including Distributed Availability Groups, Contained Availability Groups, Peer-to-Peer replication, T-SQL Snapshot Backup, and Accelerated Database Recovery (ADR), plus the Managed Instance Link for hybrid scenarios.
Business Continuity with Azure Arc:
- Centralize management, automate patching, and monitor HA/DR deployments across hybrid environments to minimize downtime and maintain data integrity.
This session will also provide a brief history of SQL Server’s availability innovations, clarify key HA and DR concepts, and share real-world scenarios and best practices. Whether you’re navigating Azure’s diverse HA/DR options or optimizing on-premises and hybrid deployments, you’ll leave with actionable strategies to elevate your organization’s data resilience using SQL Server 2025.
You will learn:
- How to implement and utilize new features like persisted statistics, optimized locking, Fabric mirroring, and automatic backups via Azure Arc to enhance system availability, performance, and disaster recovery.
- Understand how to effectively use Azure’s HA/DR options, such as Availability Groups, clusters, log shipping, and the SQL IaaS agent extension, to quickly set up and manage highly available SQL Server instances in the cloud.
- Discover strategies for maintaining business continuity using Azure Arc, including centralized management, automated patching, and monitoring of SQL Server deployments across on-premises, cloud, and hybrid infrastructures