Azure SQL Managed Instance RTO and RPO details
In the modern digital landscape, applications rely on databases to remain functional at all times. However, unforeseen events such as …
Azure Databases
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.
Scaling Downtime in SQL Managed Instance
In this post, I am going to share my hands-on experience measuring the actual downtime you can expect when scaling …
Check Replication status between SQL MI Primary and Secondary
Ensuring that SQL Managed Instance (SQL MI) replication is properly synchronized between the primary and secondary instances is critical for …
7 Proven Strategies to Reduce SQL Managed Instance Costs
If you have migrated your databases to the cloud, you already know the incredible benefits of Azure SQL Managed Instance …
How to create a SQL MI Linked Server using TSQL Scripts
Linked servers enable Azure SQL Managed Instance (SQL MI) to seamlessly execute distributed queries and commands against remote database servers, …
Fix owner login issue in Agent Job using Entra ID in SQL MI
When I was working on creating and scheduling an agent job, I encountered the below error message. Error Message Create …
How to Create and Schedule a SQL Agent Job in Azure SQL MI
If you are running tasks manually on your databases, it’s time to automate. SQL Agent Jobs allow us to schedule …
Azure SQL DB vs Azure SQL Managed Instance (With Diagrams)
If you’re planning a database migration or architecting a new cloud-native solution, you’ve likely hit this exact crossroads: should you …
How to connect to Azure SQL MI with SSMS using Entra ID
In this guide, we will walk through how to seamlessly integrate Microsoft Entra ID (formerly Azure Active Directory) with your …
Microsoft Entra Admin Setup for Azure SQL MI in Portal
Configuring Microsoft Entra Admin for Azure SQL Managed Instance (MI) ensures secure identity management and streamlined access control. In this …