Azure SQL Database Read Only Replica

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-read-scale-out As part of the High Availability architecture, each database in the Premium and Business Critical service tier is automatically provisioned with a primary replica and several secondary replicas. The secondary replicas are provisioned with the same compute size as the primary replica. The Read Scale-Out feature allows you to load-balance SQL Database read-only workloads using the capacityContinue reading “Azure SQL Database Read Only Replica”

How to Restore the Azure SQL Managed instance DB using Azure CLI/Poratl

https://docs.microsoft.com/en-us/azure/sql-database/scripts/sql-database-restore-database-cli Limitations Point in time restore to a managed instance has the following limitations: When you’re restoring from one managed instance to another, both instances must be in the same subscription and region. Cross-region and cross-subscription restore aren’t currently supported. Point-in-time restore of a whole managed instance is not possible. This article explains only what’sContinue reading “How to Restore the Azure SQL Managed instance DB using Azure CLI/Poratl”

semaphore timeout error message

Customer is able to connect the Azure SQL Database any other machine successfully.Here, the client request is not reaching to the Gateway if it is failing at Gateway level we can say that there is issues with the SQL DB gateway.https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture This is not because DB memory resource pressure.  At pre-login handshake stage, the requestContinue reading “semaphore timeout error message”

Introduce Yourself (Example Post)

This is an example post, originally published as part of Blogging University. Enroll in one of our ten programs, and start your blog right. You’re going to publish a post today. Don’t worry about how your blog looks. Don’t worry if you haven’t given it a name yet, or you’re feeling overwhelmed. Just click theContinue reading “Introduce Yourself (Example Post)”

Introduce Yourself (Example Post)

This is an example post, originally published as part of Blogging University. Enroll in one of our ten programs, and start your blog right. You’re going to publish a post today. Don’t worry about how your blog looks. Don’t worry if you haven’t given it a name yet, or you’re feeling overwhelmed. Just click theContinue reading “Introduce Yourself (Example Post)”

Introduce Yourself (Example Post)

This is an example post, originally published as part of Blogging University. Enroll in one of our ten programs, and start your blog right. You’re going to publish a post today. Don’t worry about how your blog looks. Don’t worry if you haven’t given it a name yet, or you’re feeling overwhelmed. Just click theContinue reading “Introduce Yourself (Example Post)”