Entra ID Connection Strings for Azure SQL Managed Instance

Moving away from legacy SQL authentication and adopting Microsoft Entra ID (formerly Azure Active Directory) is one of the best moves you can make to secure your Azure SQL Managed Instance. Using password-less authentication, Managed Identities and robust RBAC policies makes your data significantly safer. However, getting the connection strings and package dependencies exactly right … 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

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

Offline Migration of AWS DynamoDB to Azure Cosmos DB NOSQL API

In this blog post, I will explain how you can migrate your AWS Dynamo DB to Azure Cosmos DB No SQL API in offline. The solution leverages GitLab CI/CD pipeline from downloading Dynamo DB data from S3 bucket to uploading JSON data into Azure Cosmos DB NoSQL API container. Now, we know that both Cosmos … Read more