Azure SQL Database SLA

Can you improve on the baseline (service level agreement) SLA of 99.99 % for Azure SQL Database? How can you get 99.995% as shown below, from official Microsoft documentation?

(source: https://azure.microsoft.com/en-gb/blog/understanding-and-leveraging-azure-sql-database-sla/)
Continue reading

Azure SQL Database Networking

Have you realised the changes Microsoft have made to the firewall and networking section of Azure SQL Database? I found this quite stealthy and took me by surprise. I did encounter an edge case scenario where it lead to issues once I made some tweaks but that was a rare thing.

Continue reading

Azure Databricks to Azure SQL DB

Recently I got to a stage where I leveraged Databricks to the best of my ability to join couple of CSV files together, play around some aggregations and then output it back to a different mount point ( based on Azure Storage) as a parquet file, I decided that I actually wanted to move this data into Azure SQL DB, which you may want to do one day.

Continue reading

Azure Advisor – for Azure Data Platform

Wouldn’t it be nice if we could access one main dashboard / report that pulls in information from many tools such as security centre, SQL advisor and cost management tools? Well you can, thus giving you a focal point to implement best practices, called Azure Advisor. This is not specifically for Azure SQL Database, you can leverage this for most resources within Azure.  Later in this blog post you see that I will use it as a focal point for my database infrastructure in Azure.

In the Azure portal under services look for “advisor”

Continue reading