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…
Cleaning up Backups from Azure Blob Storage
Continuing the topic of the Backups to Azure Blob Storage that I have kind of kicked off with the post Striping Backups to Azure Blob Storage, I want to touch on the important aspect of “keeping it clean” – thus…
Striping Backups to Azure Blob Storage
I love Azure Blob Storage. It is a great source for the Data Disks for the Azure VMs (IaaS), Data Files for Azure SQL Database Managed Instance and of course for the key things that guarantees the business running –…