When migrating to Azure SQL Managed Instance (SQL MI), Linked Servers often become a critical requirement for maintaining cross-environment connectivity. They act as a vital bridge, allowing you to execute queries or call stored procedures across diverse environments whether that is an on-premises database, Azure SQL DB, SQL Server on an Azure VM, or another … Read more
In this guide, I will walk you through the exact Azure CLI commands I use to deploy a single-region Cosmos DB NoSQL account. I have personally tested and executed all of these commands in my own Azure CLI environment, so you can safely copy and paste them directly into your terminal. Prerequisites Before executing these … Read more
In this comprehensive engineering guide, we will completely bypass the Azure Portal clicks and build a production-ready, serverless Azure Cosmos DB for NoSQL account using the Azure CLI. In this blog post, I tested the commands for creating a single-region Cosmos DB serverless account. The Azure CLI commands are tested, and resources get deployed as … Read more
In the modern digital landscape, applications rely on databases to remain functional at all times. However, unforeseen events such as hardware failures, regional power outages, or accidental human errors can disrupt normal operations. To protect data and ensure business continuity, Microsoft Azure SQL Managed Instance offers a robust set of recovery tools. Here are the … Read more
In this post, I am going to share my hands-on experience measuring the actual downtime you can expect when scaling an Azure SQL Managed Instance (SQL MI) up or down. Specifically, I will be walking you through a real-world test of scaling storage size and vCores using a free-tier SQL Managed Instance. I will append … Read more
Ensuring that SQL Managed Instance (SQL MI) replication is properly synchronized between the primary and secondary instances is critical for maintaining high availability, disaster recovery, and data integrity. Replication allows your databases to stay consistent across environments, but if synchronization fails, it can lead to downtime or data loss. The actual article where Microsoft published … Read more
If you have migrated your databases to the cloud, you already know the incredible benefits of Azure SQL Managed Instance (SQL MI). It offers near 100% compatibility with the latest SQL Server engine, automated patching, and robust security. Now, here comes the biggest risk and it is the final bill on your invoice for consuming … Read more
Hosting a website on Microsoft Azure offers great flexibility, strong security, and the ability to scale globally. Whether you’re setting up a simple static portfolio, moving a technical blog, or building a complex microservices setup, Microsoft’s cloud platform has services designed to fit your specific needs. In Microsoft Azure, we have several ways to host … Read more
Linked servers enable Azure SQL Managed Instance (SQL MI) to seamlessly execute distributed queries and commands against remote database servers, such as other SQL MIs, Azure SQL Databases, or on-premises SQL Server instances. I’m discussing the creation of a linked server from one SQL Server to another. This blog post doesn’t cover creating a linked … Read more
When I was working on creating and scheduling an agent job, I encountered the below error message. Error Message Create failed for Job ‘GUI_Demo_Daily_Insert’. (Microsoft.SqlServer.Smo) Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The specified ‘@owner_login_name’ is invalid (valid values are returned by sp_helplogins [excluding Windows NT groups]). (Microsoft SQL … Read more