-
How storage options in Azure impact SQL Server performance
SQL Server in azure using an IaaS deployment comes with many pros (and cons) over PaaS offerings. One of the nice things about IaaS is […]
-
Database Deployment via Terraform – Part 2
In Part 1 we looked at deploying an azure sql database and logical server via some very primitive terraform. This post looks at different methods […]
-
Database Deployment via Terraform – Part 1
This post is the first in a mini series talking about the steps involved in deploying Azure SQL Databases via Terraform. The idea behind this […]
-
How to analyse Stored Procedure performance: part 2
Part 2 of this series is going to focus on Query Store and the execution statistics available to analyse performance. Without going into too much […]
-
How to analyse Stored Procedure performance: part 1
We’ve all been there in the trenches. You get the call ‘the app is slow’, and within 10 seconds management are breathing down your neck. […]
-
Baselining SQL Server for Azure
When migrating SQL Server workloads to Azure there is a trade-off between optimizing for performance and optimizing for costs. You need to know how much […]
