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.
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
If you are running tasks manually on your databases, it’s time to automate. SQL Agent Jobs allow us to schedule T-SQL statements against the databases in Azure SQL MI so they run on their own. Today, I’m not going to waste time talking about the theory behind it. I’m just going to show you the … Read more
If you’re planning a database migration or architecting a new cloud-native solution, you’ve likely hit this exact crossroads: should you choose Azure SQL DB or Azure SQL Managed Instance? Both are fully managed PaaS offerings, but they serve very different use cases. Making the wrong choice early on can lead to architectural roadblocks, complex refactoring, … Read more
In this guide, we will walk through how to seamlessly integrate Microsoft Entra ID (formerly Azure Active Directory) with your SQL Managed Instance using the SSMS tool. Just follow the below steps to connect to SQL MI server. Step 1: Copy the SQL MI Hostname from Azure Portal Log in to the Azure Portal and … Read more
Configuring Microsoft Entra Admin for Azure SQL Managed Instance (MI) ensures secure identity management and streamlined access control. In this guide, we’ll walk through the steps to set up Entra Admin directly from the Azure Portal, making it easier to manage authentication and permissions for your SQL MI environment. Steps to Configure Microsoft Entra Admin … Read more
When designing a business continuity and disaster recovery (BCDR) strategy in Microsoft Azure, protecting your data from corruption, human error, and full-scale regional outages is non-negotiable. Whether you are running Azure SQL Database (SQL DB) or Azure SQL Managed Instance (SQL MI), Azure provides built-in, automated backup mechanisms to safeguard your workloads. There are three … Read more
Point-in-Time Restore (PITR) is designed for operational recovery and short-term resilience, and Long-Term Retention (LTR) is for storing or retaining backups for long term (up to 10 years) The same differences also apply to Azure SQL Database as well as Azure SQL MI. We know that both resources are PaaS services and the backups are … 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
In this blogpost, I will explain about the differences between the on prem SQL Server and the SQL Managed Instance hosted on Azure Cloud. Enterprise workloads are moving from on‑premises systems to cloud platforms. This change has reshaped how relational databases are managed. As on today, Microsoft offers two choices, SQL Server and Azure SQL … Read more