The NoSQL Showdown: AWS DynamoDB vs. Azure Cosmos DB

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

Azure SQL: Single DB vs. Elastic Pool

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

Insert data into Cosmos DB NoSQL API using Transactional Batch API with Python

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

Azure SQL MI Failover Group Pre-Requisites

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

Asynchronous Data Insertion into Cosmos DB NoSQL API with Python

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

Insert data synchronously into Cosmos DB NoSQL API with Python

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

Different methods for inserting data into the Cosmos DB NoSQL API using Python

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