The auto-failover groups feature for the Azure SQL database can be configured with an automatic failover policy. Azure triggers failover after the failure is detected and the grace period has expired. Grace period is determined by a setting called ‘GracePeriodWithDataLossHours’ that cannot be set under one hour. Why is it not allowed to set a […]
A list of items that people often get wrong. If you have a suggestion, let me know, and I will add them to this page.
View Event: Azure SQL Database-Business Continuity During Disaster Azure SQL Database is a relational database-as-a-service (DBaaS) based on the latest version of the Microsoft SQL Server Database Engine. You can build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure. While considering Azure SQL Database, two of the […]
View Event: Azure SQL Database-Business Continuity During Disaster Description Azure SQL Database is a relational database-as-a-service (DBaaS) based on the latest version of the Microsoft SQL Server Database Engine. You can build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure. While considering Azure SQL Database, two of […]
As per Microsoft documentation, Diagnostic Connection for Database Administrators is available for the Azure SQL database. If you are not familiar with DAC, read this official documentation from Microsoft. By default, the connection is only allowed from a client running on the server. Network connections are not permitted unless they are configured by using the […]
