Managed Instance - Matt Mansoomi

Matt Mansoomi

Managed Instance

Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service. SQL Managed Instance has near 100% compatibility with the latest SQL Server (Enterprise Edition). Here I am writing about most common issues for MI which I observe.

Connect to Managed Instance with Public End Point

Managed Instance

Connect to Managed Instance with Public End Point

If once you tried to connect to managed instance, you got the below error message, this post might help you to fix the issue. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance

Don’ not see Start stop button in managed instance?

Cost Saving in Azure

Don’ not see Start stop button in managed instance?

Microsoft had an awesome news in November 2022 for those who use managed instance. You can stop/start instance from Azure Portal or PowerShell. That’s a huge change as you can save on billing costs when you're using Azure SQL Managed Instance. See all details here. As

Change the planned maintenance time for Azure SQL and MI

planned maintenance

Change the planned maintenance time for Azure SQL and MI

As you’re aware one of the adventures of PaaS is the user doesn’t need to do anything for maintenance. Cloud service provider in our case Azure will do all patching and maintenance for you! Planned maintenance event keeps Azure SQL Database and Azure SQL Managed Instance services secure,

Quota limitations for SQL Managed Instance

create Managed Instance

Quota limitations for SQL Managed Instance

Last week I worked on a new issue, the customer was not able to create Managed Instance, they got this error message: Managed Instance is not available for the chosen subscription and region. Please try again with some other subscription or use Microsoft Support to request region access. Limitation for

Restore managed instance database from blob storage

Restore Database

Restore managed instance database from blob storage

Let’s assume you already configured your managed instance, and you got access to the server with SSMS, now you want to restore your first database from Azure blob storage to MI. It’s very straight forward process, for restoring database to managed instance you have several methods but in

How does CDC impact the transactional logs?

How does CDC impact the transactional logs?

I got case that the customer has issue with transaction log in Managed Instance, basically the transactional log increases to 500 Gb! When they checked with sys.log_reuse_wait_desc they found it was waiting on replication but their first question was we have not replication on database. If

Cannot connect to Managed Instance

Connection Issue

Cannot connect to Managed Instance

Sometimes connecting to Managed Instance can be confusing. Lots of things about connection to Azure Managed Instance like Public endpoint, Private endpoint, proxy, redirect and so on! And probably that’s why sometimes users don’t know what’s the issue? I believe if they can have some idea about

Grant SQL managed identity to Storage Blob Data Contributor role

Grant SQL managed identity to Storage Blob Data Contributor role

In some scenarios like this you need to grant SQL managed identity Storage Blob Data Contributor role on the Storage account, for doing this you need to create the storage account first, then from the left blade choose “Access Control (IAM)” and “Add role assignment” like the below screenshot. From