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 of structuring terraform with an aim to have a terraform project containing modularization and logical separation of resources with one example. The importance of project structure can not be understated,…

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 series is to serve as a reference documenting the very first steps involved with deploying azure sql database resources and finishing with some useful tips and tricks to make your…

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 work your sql servers are performing when evaluating them prior to a migration. Ideally you will have a tool that will capture key metrics such as your servers wait statistics…