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 …
Azure SQL
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, …
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 …
When to use PITR and Geo-Restore in Azure SQL MI or SQL DB
When designing a business continuity and disaster recovery (BCDR) strategy in Microsoft Azure, protecting your data from corruption, human error, …
PITR vs LTR differences in Azure SQL Managed Instance or SQL DB
Point-in-Time Restore (PITR) is designed for operational recovery and short-term resilience, and Long-Term Retention (LTR) is for storing or retaining …
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 …