Marks Multiverse

Welcome to my website, where I try to share everything I think is worth sharing.

Automate Azure Image Builder in Bicep with custom builder resource group

Of course we want to secure and keep our Azure tenant tidy with the help of Azure Policies. And without any hesitation I preach to automate everything! But what if these two mindsets conflict with one another? What if there is an Azure Policy in place that demands a naming standard or tags for resource groups that causes an automated Azure Image Builder deployment to fail? With Azure Image Builder (AIB) we can automate the process of building images for use in an Azure Virtual Desktop environment for instance....

February 16, 2024 · 6 min · Mark Tilleman

Automate creation of test databases on Azure SQL with Active Directory security groups

For database testing it is customary to make periodic copies of the production database and use the latest copy as a test database. But how does that work in a scenario where you use Azure SQL and a traditional Active Directory instance? And on top of that you obviously want to automate that process! Steps Steps involved: Create an Automation Account. Give the automation account the right permissions. Make the automation account administrator on the SQL server....

January 26, 2024 · 5 min · Mark Tilleman