Testing App Cloud Readiness for Failover Resiliency with SQL Managed Instance

Testing App Cloud Readiness for Failover Resiliency with SQL Managed Instance

In this episode with Dani Ljepava, we will show you how to manually trigger a planned failover on SQL Managed Instance to test your applications for fault tolerance and will talk about best practices for your applications to achieve tolerance to transient faults typical for the cloud environments. Transient faults in the cloud (for example software patching, security updates, failover, and similar) include a momentary loss of network connectivity, temporary unavailability of a service, or timeouts when service is busy. These faults are often self-correcting due to which your applications need to be able to handle such occurrences with the appropriate retry logic. While migrating legacy apps to the cloud or developing new cloud-born apps, it is strongly advised to ensure that your applications follow the best practices disclosed in this episode helping you build cloud-ready apps.

In this episode with Dani Ljepava, we will show you how to manually trigger a planned failover on SQL Managed Instance to test your applications for fault tolerance and will talk about best practices for your applications to achieve tolerance to transient faults typical for the cloud environments. Transient faults in the cloud (for example software patching, security updates, failover, and similar) include a momentary loss of network connectivity, temporary unavailability of a service, or timeouts when service is busy. These faults are often self-correcting due to which your applications need to be able to handle such occurrences with the appropriate retry logic. While migrating legacy apps to the cloud or developing new cloud-born apps, it is strongly advised to ensure that your applications follow the best practices disclosed in this episode helping you build cloud-ready apps.

[00:46] ​ About Dani Ljepava

[01:30] ​ Transient errors in the cloud

[02:50] ​ Cloud Ready Apps

[04:07] ​ Understanding failover as part of HA on SQL MI

[06:00] ​ Demo: User-initiated failover on SQL Managed Instance

[11:35]  How to check if failovers occurred

[12:35] ​ Best practices

azure sql aft-sql sql

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

How to set up Azure Data Sync between Azure SQL databases and on-premises SQL Server

In this article, you learn how to set up Azure Data Sync services. In addition, you will also learn how to create and set up a data sync group between Azure SQL database and on-premises SQL Server.

Creating and Cataloging SQL pools in Azure SQL Server

In this article, we will show how to create a new SQL Pool within an existing Azure SQL Server as well as catalog the same using the Azure Purview service

Demo: Configure Azure SQL with Azure CLI | Azure SQL for beginners (Ep. 17)

In this video, see how to configure your Azure SQL connectivity leveraging the Azure CLI and PowerShell notebooks in Azure Data Studio. For the full Azure SQ...

Learning How to Transition Your SQL Server Skills to Azure SQL

Are you interested in learning how to translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL Managed Instance? In this episode, Bob Ward, Anna Hoffman, and Marisa Brasile announce all-new content on YouTube, Github, and Microsoft Learn to help you become an Azure SQL professional.