Welcome back to another deep dive on Cloud Nerchuko. If you have ever tried setting up a Linked Server from an Azure SQL Managed Instance (MI) to an Azure SQL Database using a System-Assigned Managed Identity, you know that Azure networking can sometimes feel like navigating a maze of invisible walls. Recently, I went through … Read more
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
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