Lesson Learned #51: Managed Instance – Import via Sqlpackage.exe doesn’t allow autogrow

Some days ago, I have been working in a service request that our customer faced the following issue: They’ve downloaded the newest version of Sqlpackage.exe tool (18.0) and they’re trying to import a bacpac into their Azure SQL Managed Instance. It has started successfully but it’s hanging while it reaches 32,768 MB size of primary…


Lesson Learned #50: Adding PK led to transaction log full error

Hello, It is common to have this type of cases where our customer has millions of rows in a table and when they need to add a column and they reached the error transaction log full. Depending on the Azure SQL Database tier you have two important factors to be aware of for having this process completed: Transaction Log Size and…


Move to Azure Resource Manager REST APIs for Azure SQL Database

Some customers already noticed that we are retiring Azure Service Manager REST APIs for Azure SQL Database on December 1, 2019 and may get confused about what this means. In case you haven’t seen the notice yet, you can take a look at https://azure.microsoft.com/en-us/updates/move-to-azure-resource-manager-rest-apis-for-azure-sql-database/ We have a documentation page that states some of the differences…