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.
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
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
Hosting a WordPress site on shared hosting is fine for beginners, but when you need serious reliability, security, and scalability, moving to the cloud is the next logical step. Microsoft Azure makes it incredibly easy to spin up a WordPress instance, but the real challenge for many is getting that instance properly connected to a … Read more