Troubleshooting Connectivity Common Scenarios

Connectivity troubleshooting. Connectivity issues are quite common in Azure DB and SQL in general. We have a great article that can assist in resolving these which is here: https://support.microsoft.com/en-us/help/10085/troubleshooting-connectivity-issues-with-microsoft-azure-sql-database This article is great, and I encourage you to review its content and consider using it when you have a connectivity problem in the future. However, I’d…


GRANT SUPER privilege on Azure Database for MySQL

The SUPER privilege is not supported on Azure Database for MySQL. The closest you can get is to create another admin level user with the same rights as the server admin you created to do this you can run: You can get the privileges the admin account has by logging in as the admin account…


Example Python Program Reading SQL Azure Blob Auditing Data

I recently had a case that a customer needed a way to read the blob auditing data from Linux. This was the quickest and easiest way I could think of. First install msodbcsql following the instructions here https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server You will also need to install the pyodbc module.


Protecting deletions of Azure SQL Resources

In Azure, there is a feature called Azure Resource Management Locks which can help prevent accidental deletion resources such as a SQL Server by adding a level of protection. While it may not happen all the time, sometimes we make mistakes and delete the wrong server. Be it that there was a typo in an…


Database Blob Auditing Policy using .NET C#

We have a good example on how to use C# to create an Azure SQL database with the Microsoft Azure SQL Management Library for .NET at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-csharp Let extend this example and see how to set database blob auditing policy: Please replace the {removed} with your blob storage account parameters. The recommended set of action groups…


Azure Database for MySQL – Can’t restore database with error “Got error 1 from storage engine”

Microsoft has recently released the preview of Azure Database for MySQL. We noticed that customers who are migrating from other MySQL servers have been facing the error: “Got error 1 from storage engine” While indicated to be a storage capacity issue on a MySQL server when researching this error, in Azure Database for MySQL this…