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.
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
In this blogpost, you will learn about inserting data synchronously into Azure Cosmos DB NoSQL API with Python code. Pre-requisites: Results: Insertion of 1,000 JSON records completed in 4:33 minutes. Note: You can setup your local environment using any Python supported IDE such as VS Code. I don’t want to go through VS Code and … Read more
In this blogpost, I will explain the different methods to insert data into the Azure Cosmos DB NoSQL API using Python code. Azure Cosmos DB is a global distributed database created by Microsoft which supports multi-model databases like Gremlin, Cassandra, Table, PostgreSQL and Mongo DB hosted on Azure Cloud. To insert data into Azure Cosmos … Read more