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
The Azure category covers tutorials, best practices, and insights on Microsoft’s cloud platform. From setting up databases and managing resources to exploring advanced services like Cosmos DB, Databricks, and AI integrations, this section is designed to help developers, architects, and IT professionals harness the full potential of Azure.
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 …
6 ways to host a website on Azure
Hosting a website on Microsoft Azure offers great flexibility, strong security, and the ability to scale globally. Whether you’re setting …
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 …