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…


Understanding Performance in Basic Tier for Azure Database PostgreSQL and MySQL

Azure Database for PostgreSQL and MySQL have similar architectures for performance tiers. While Microsoft recommends to choose between the General Purpose and the Memory Optimized versions, some users might consider Basic Tier servers as they believe their workload is not that aggressive against resource utilization. Basic Tier servers were built for testing, development or small-scale…

6

Azure Database for MySQL server has gone away

One of the common MySQL server errors is “MySQL server has gone away”. This is a pretty generic error and can happen because of a server error or a client-side error. While Azure has automated bots which are used to detect and address server side issues, this tutorial will discuss client-side issues that can cause…


How to Scale up Azure Database for MySQL from Basic Tier to General Purpose Tier

Scaling up from Basic Tier to General Purpose or Memory Optimized servers is not supported and the only way to achieve this is by exporting your databases from your Basic Tier server and restore the databases at a newly created server in the desired service Tier. You can use mysqldump to backup your databases and…

2

Azure SQL DB with more than 4 readable secondaries

If you try to create more than 4 geo-replicas in the Portal it will fail with the error message “Replication limit reached. The database ‘XXXXX’ cannot have more than 4 replication relationships.” There are 3 ways to resolve this problem:


Azure Database for PostgreSQL performance Quick Tips

To make sure that you are running your Azure Database for PostgreSQL at its best capabilities, please review the following recommendations and best practices. 1. Server Resource Utilization Make sure that your Azure Database for PostgreSQL instance does not run under a high utilization which can cause query execution latencies. Please visit the Azure Portal…


Unable to view LTR Backups for Azure SQL Database servers

Consider that you have configured the LTR Backup for your Azure SQL Database and you are not able to view it on the Portal. Figure 1: LTR configure policies pane   And when you click on available backups you do not see the list of backups. Figure 2: Available Backups pane This might be related…