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

What is the difference between SQL Server and SQL Managed Instance?

In this blogpost, I will explain about the differences between the on prem SQL Server and the SQL Managed Instance hosted on Azure Cloud. Enterprise workloads are moving from on‑premises systems to cloud platforms. This change has reshaped how relational databases are managed. As on today, Microsoft offers two choices, SQL Server and Azure SQL … Read more

Different database restore methods in Azure SQL MI

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

Step-by-Step Guide: Creating an Azure SQL Managed Instance (Pay-As-You-Go & Free Offer)

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

How to Create an Azure Database for MySQL Flexible Server in Azure Portal

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

Azure SQL MI Standby replica and Read replica functionality

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

You need to create a pair of azure sql managed instances in an auto-failover group. Where do you deploy the primary and secondary instance?

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

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