Getting started with GitHub Actions on Azure

When I started in IT, I could fairly easily acquire knowledge on my own. I bought an Intel NUC, installed VMware ESX, virtualized a few Windows servers and clients, and built my own Citrix workspace solution. This allowed me to imitate a system administrator at home. However, the world and my field of work have changed significantly since then. The system administrator now stands next to the brontosaurus in the museum, and my NUC has a chipset that cannot run Windows 11. The market now demands DevOps Engineers and Cloud Engineers. But how can you gain this knowledge in an accessible way? Simple. GitHub, GitHub Actions, and Azure. CI/CD at your kitchen table. ...

February 26, 2026 · 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. Check and add modules. Set the variables in the automation account. Create a runbook. Schedule the runbook. Note: This is not a step-by-step tutorial but more a high-over instruction. ...

January 26, 2024 · 5 min · Mark Tilleman