SQLBits 2024
Infra as code, control it from the tower.
This session covers deploying an Azure data solution with Infrastructure as Code with emphasis on security but also ease of maintenance.
Besides slides it also offers a demo and the code is on offer for download to give you, the delegate, a head start.
Tower to ATTN, taxi via India, Alpha and Charly to runway 24 Right. Cleared for take off to FAB. Have a good flight!
Have you been deploying your Azure databases and all connected resources through the portal?
Are you fed-up with clicking, weird resource naming and mostly, with having to deal with changes manually?
It's time to code, deploy and maintain your Azure (data) Infrastructure with confidence!
If you are working in Azure and you have anything to do with data, security and the infrastructure, this session is for you!
Azure Infrastructure as Code offers a plethora of possibilities, but the first time I checked it out, all I saw were Azure Resource Manager (ARM) templates. Hard to read, harder to write. They gave me headaches. It seems I wasn't the only one with that problem, because there are excellent tools to help you out! My favourite, and the one I'm using in this session is Terraform.
Now why is this presenter talking about this? I've deployed a number of customer environments with this language. Whenever there's a security update, like a new policy for example, I can deploy this to all customers in minutes. I'll only have to code this once and can easily deliver it many times, saving them time and money. Resources we can spend in other areas like ETL, ELT etc.
During the session, I'll demonstrate the basics of a data deployment, following the spirit of the Microsoft Well Architected Framework. I'll show you my way of working, the structure and and the end result. As securing resources and data is paramount in any cloud solution, it'll have plenty of attention in this session as well.
There is no need to try and photograph what's happening on screen, all the scripts will be available after the session.
Have you been deploying your Azure databases and all connected resources through the portal?
Are you fed-up with clicking, weird resource naming and mostly, with having to deal with changes manually?
It's time to code, deploy and maintain your Azure (data) Infrastructure with confidence!
If you are working in Azure and you have anything to do with data, security and the infrastructure, this session is for you!
Azure Infrastructure as Code offers a plethora of possibilities, but the first time I checked it out, all I saw were Azure Resource Manager (ARM) templates. Hard to read, harder to write. They gave me headaches. It seems I wasn't the only one with that problem, because there are excellent tools to help you out! My favourite, and the one I'm using in this session is Terraform.
Now why is this presenter talking about this? I've deployed a number of customer environments with this language. Whenever there's a security update, like a new policy for example, I can deploy this to all customers in minutes. I'll only have to code this once and can easily deliver it many times, saving them time and money. Resources we can spend in other areas like ETL, ELT etc.
During the session, I'll demonstrate the basics of a data deployment, following the spirit of the Microsoft Well Architected Framework. I'll show you my way of working, the structure and and the end result. As securing resources and data is paramount in any cloud solution, it'll have plenty of attention in this session as well.
There is no need to try and photograph what's happening on screen, all the scripts will be available after the session.