DBA in the cloud is a blog about my journey to the cloud. From on-premisses DBA to the DevSecOps consultant. Covering infrastructure as a code with the use of Terraform. CI/CD deployment pipelines in Azure DevOps. Automation with PowerShell and Python. And plenty of security tools in the DevSecOps space to cover security hardening.
How to configure budget and alerts for Azure resource group in terraform code to provide cost visibility (FinOps).
Posted by Nikos Tsirmirakis on 2023-10-30
How to implement cost visibility and automated cost policy validation in development pipelines for IaC (Infrastructure as a Code) resources with the use of infracost tool.
Posted by Nikos Tsirmirakis on 2023-10-03
How to install Azure Monitor Agent virtual machine extension, configuring data collection rule and Log Analytics workspace with Terraform to collect Windows events.
Posted by Nikos Tsirmirakis on 2023-01-16
How to implement DAST security scanning for web application/portal with the use of the Dastardly tool as a part of Azure DevOps CI/CD pipeline.
Posted by Nikos Tsirmirakis on 2022-11-28
DevSecOps - Overview of DevSecOps concept and main elements
Posted by Nikos Tsirmirakis on 2022-11-14
DevSecOps - How to scan a container for vulnerabilities and publish results as a part of Azure DevOps CI/CD pipeline.
Posted by Nikos Tsirmirakis on 2021-09-08
DevSecOps - How to validate terraform script and run security static code analysis with use of tfsec as a part of Azure DevOps CI/CD pipeline.
Posted by Nikos Tsirmirakis on 2021-07-12
How to expose secret variables in Azure DevOps CI/CD pipeline with use of PowerShell step.
Posted by Nikos Tsirmirakis on 2021-02-01
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.
Posted by Nikos Tsirmirakis on 2021-01-18
How to create, customize Azure SQL Server VM and add it to a cloud lab including domain controller and Azure DevOps build agent in Azure with use of Terraform.
Posted by Nikos Tsirmirakis on 2020-11-10
How to create a test environment/cloud lab with a domain controller and Azure DevOps (VSTS) agent in Terraform.
Posted by Nikos Tsirmirakis on 2020-08-10
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.
Posted by Nikos Tsirmirakis on 2020-06-25
Step by step guide how to add environment Pester test into Azure DevOps CI/CD pipeline.
Posted by Nikos Tsirmirakis on 2020-05-05
Step by step guide how to build and destroy Microsoft SQL server in Azure DevOps pipeline with use of infrastructure as a code Terraform scripts.
Posted by Nikos Tsirmirakis on 2020-03-09
Automated SQL servers build in Azure with a single Terraform command
Posted by Nikos Tsirmirakis on 2020-01-27
Naming and tagging in Azure with use of Terraform script
Posted by Nikos Tsirmirakis on 2020-01-06
Step by step guide how to build standalone SQL server in Azure with use of Terraform script
Posted by Nikos Tsirmirakis on 2019-11-20
If you need help with DevSecOps, Azure cloud or your SQL servers drop me a line.