DBA in the cloud

DBA in the cloud is a blog about my journey to the cloud as a DBA. Covering infrastructure as a code with the use of Terraform. CI/CD deployment pipelines in Azure DevOps. Automation with PowerShell and Python. And environment testing with the use of PowerShell Pester framework.

Blog

How to expose secret variables in Azure DevOps

How to expose secret variables in Azure DevOps CI/CD pipeline with use of powershell step.

How to build and test SQL server within Azure DevOps CI/CD pipeline

How to create a cloud lab with customised SQL Server VM, domain controller and Azure DevOps build agent in Azure with use of Terraform as part of CI/CD pipeline and test it with Pester 5.

How to create a cloud lab with customised SQL Server VM, domain controller and Azure DevOps build agent in Azure with use of Terraform

How to create and customize Azure SQL Server VM with use of PowerShellDSC and T-SQL. And how to add it to a cloud lab with domain controller and Azure DevOps build agent in Azure with use of Terraform.

How to configure cloud lab with Azure DevOps agent and DC in Terraform

How to create a test environment/cloud lab with a domain controller and Azure DevOps (VSTS) agent in Terraform.

How to configure Azure VM extension in Terraform

How to configure Azure VM extension with the use of Terraform. Step by step guide how to add VM to a domain, configure the AV agent and run a custom script.

Test configuration in Azure DevOps CI/CD pipeline with use of Pester framework

Step by step guide how to add environment Pester tests into Azure DevOps CI/CD pipeline.

Azure DevOps pipeline to build and destroy SQL server

How to build and destroy SQL server in Azure DevOps pipeline with use of Terraform scripts.

Automated SQL servers build in Azure with a single Terraform command

How to build multiple SQL servers in Azure with a single Terraform command.

Naming and tagging in Azure

Naming convention you can implement in Azure with use of Terraform scripts.

Building SQL server in Azure with Terraform

How to build stand-alone SQL server in Azure - infrastructure as a code with the use of Terraform.

Get In Touch!

If you need help with migrating to the cloud or managing your SQL servers drop me a line.