The cloud enables us to quickly and easily, create and destroy resources when we need them.
Automating this process reduces manual mistakes and the need for user input.
You can use Terraform to put Azure SQL Databases into Infrastructure as Code, then deploy them with Azure DevOps with any additional steps that your business requires for approvals or other processes
Once you can create your Azure SQL Database programmatically, a cool next step would be to be able to grant and remove access using automation as well.
With a sprinkling of dbatools and a couple of configuration changes, you can also set this up in Azure DevOps
This session will take you through the steps required to build an automated solution to create an Azure SQL Database with a Service Principal and create users and apply permissions using Azure DevOps, Terraform, Azure Key Vault and PowerShell.
Be-Whiskered PowerShell Ninja
Rob was a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people. He is a Cloud and Data Center MVP and a Data Platform MVP, an officer for the PASS DevOps Virtual Chapter, co-leader of Data South West and PSConf EU organiser and has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and Powershell communities.
He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer and flying a drone in the winter.
He has a fabulous beard
Slides and Scripts – beard.media/presentations
Book Discussed – beard.media/book
The Actual Presentation