The Azure Databases category explores Microsoft’s managed database services in the cloud, helping developers and architects design scalable, secure, and cost‑efficient data solutions. From globally distributed NoSQL with Cosmos DB to relational options like Azure SQL Database, PostgreSQL, and MySQL, this section provides tutorials, best practices, and insights for building modern applications.
In the world of cloud-native databases, “Backup” is only half the story. The true value lies in Restoring the database as to recover data quickly, accurately, and with minimal downtime. As SQL MI is a PaaS service offered by Microsoft, the SQL MI user database backups are automatically handled by Azure. Choosing the right backup … Read more
Azure SQL Managed Instance (SQL MI) is the ideal “bridge” for organizations looking to move their on-premises SQL Server workloads to the cloud with minimal code changes. Combining the best of SQL Server with the benefits of a fully managed Platform-as-a-Service (PaaS), it offers high compatibility and automated management. In this guide, we will walk … Read more
Creating an Azure Database for MySQL Flexible Server is a straightforward process that offers more granular control and flexibility for your database management. This guide walks you through the steps to set up your server in the Azure portal. Step 1: Search for MySQL Flexible Servers Sign into your Azure portal and search for “Azure … Read more
Assume you have created Azure SQL Managed Instance in two regions (One is Primary region for read/write workloads, and another is for a secondary region for read workloads) with a failover group. Now, the application can connect to the Primary region SQL MI and perform read or write operations on the databases of SQL Managed … Read more
To deploy a pair of Azure SQL Managed Instances (MI) in an auto-failover group, you must deploy the primary and secondary instances in different Azure regions. While technically you can choose any two regions, the standard best practice is to use Azure Paired Regions (e.g., East US and West US). Failover Groups Overview & Best … Read more
Welcome back to Cloud Nerchuko! As data engineers and cloud architects, we are constantly making critical decisions about where our data lives. When migrating heavy workloads or building cloud-native applications from scratch, traditional relational databases don’t always cut it for massive scale. Enter the fully managed NoSQL heavyweights: AWS DynamoDB and Azure Cosmos DB. Both … Read more
Choosing between a Single Database and an Elastic Pool in Azure SQL is one of the most consequential decisions an architect can make. It isn’t just a technical configuration; it is a financial strategy. If you choose incorrectly, you either end up with a performance hit or a massive monthly bill for resources that are … Read more
In this blogpost, you will understand about how to insert data into Cosmos DB NoSQL API using Transaction Batch API with Python language. I got the JSON data which has only one row per partition in the Nike Discounts file. Please experiment the batch API by changing the distribution of the JSON records. (Ex. Put … Read more
In this blogpost, you will understand about the pre-requisites to create a failover group successfully in Azure SQL Managed Instance. If you are designing a Disaster Recovery (DR) strategy for Azure SQL Managed Instance (SQL MI), you have likely settled on Auto-Failover Groups as your solution. It’s the gold standard: it gives you a read-write … Read more
In this blogpost, we will understand about how to insert data asynchronously into Cosmos DB No SQL API with Python. Pre-requisites: Please refer previous article on Insert data synchronously into Cosmos DB NoSQL API with Python to understand synchronous data insertion to Cosmos DB NoSQL API using python code. Results: Insertion of 1,000 JSON records … Read more