I have been working with Azure for a good number of years and felt that I wanted to share more of my experiences, since the migration to Azure (or to any cloud whatsoever) in the times of pandemic is growing…
Protecting SQL Server on Azure VMs
SQL Server Backup Throttling in Azure VMs (and in other virtualised environments)
Today the topic is something that is totally unexpected – the throttling of the SQL Server Backups. Why unexpected you might ask – well, unless you run workloads on Cloud VMs, you might be totally unaware of the problems that…
Resouce Governor IOPS_PER_VOLUME is not enough
SQL Server has originally introduced Resource Governor in the first decade of the 21st Century, with the release 2008 to be more precise and a number of changes to were made to the original engine ever since. Looking back I…
SQL Server 2019 – Improved Certificate Management
There was one little feature in SQL Server that went pretty much unnoticed by the most people, and the reason for that is not something to be mostly happy about – most people do not use this or any other…
Workload Classification in Azure Synapse Analytics (Resource Governor)
This blog post is part of the series dedicated to Azure Synapse Analytics that can be found at my Azure Synapse Analytics page. Continuing from the previous post in the Resource Governor in Azure Synapse Analytics – Workload Isolation in…