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…

0

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…


SQL Azure Blob Auditing Basic Power BI Dashboard

We have created a simple Power BI template for viewing Blob Auditing data. You can download the template here. This template is based on the query: Which will let you process your blob auditing files from T-SQL. To use the Power BI report first download Power BI Desktop https://powerbi.microsoft.com/en-us/desktop/ Once installed open the template file…


Sizing an Elastic Pool eDTU and Storage resources use Graphical runbook

This runbook sizing an elastic pool set Maximum DTUs utilized by all databases in the pool  . And set Maximum storage bytes utilized by all databases in the pool. You can look up the available characteristics and tiers on https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool   This runbook takes the following parameters:   ResouceGroupName: The name of the resource group that the…


Deadlock analysis for SQL Azure Database

If you have ever had a deadlock in Azure SQL Database you know they can be frustrating to get more information about what is causing the issue. Recently working on a case I built a few queries to help analyze the deadlocks you are having and drill down to the database objects that are locked…


Lesson Learned #26: How to change the definition of table triggers at the same time

Today, we have been working a very interesting case, when our customer is migrating their database to Azure SQL Database. We have found an incompatibility issue, because all triggers have an error handler with this syntax: raiserror @errno @errmsg to inform the error happened, but, this syntax is not supported for Azure SQL Database. To fix this…


Database scale error: The database cannot proceed with pricing-tier update as it has memory-optimized objects

You cannot scale SQL Azure databases from Premium to Standard with Memory optimized objects. You will get the error: Database scale operation from Premium P1: 125 DTU, 500 GB to Standard S2: 50 DTU, 250 GB failed for <database name>. Error message: The database cannot proceed with pricing-tier update as it has memory-optimized objects. Please…