DBA in the cloud

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.

Blog

FinOps - Budget and Alerts

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

FinOps - IaC pipeline cost control

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

Azure Monitor Agent VM extension with Terraform

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

DevSecOps - DAST scanning in Azure DevOps

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 - inviting security to the DevOps party

DevSecOps - Overview of DevSecOps concept and main elements

Posted by Nikos Tsirmirakis on 2022-11-14

How to scan a container for vulnerabilities and publish results as a part of Azure DevOps CI/CD pipeline

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

How to validate terraform script and run security static code analysis as a part of Azure DevOps CI/CD pipeline

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

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 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.

Posted by Nikos Tsirmirakis on 2021-01-18

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

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 configure cloud lab with Azure DevOps agent and domain controller in Terraform

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 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.

Posted by Nikos Tsirmirakis on 2020-06-25

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

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

Posted by Nikos Tsirmirakis on 2020-05-05

Azure DevOps pipeline to build and destroy SQL server

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

Automated SQL servers build in Azure with a single Terraform command

Posted by Nikos Tsirmirakis on 2020-01-27

Naming and tagging in Azure

Naming and tagging in Azure with use of Terraform script

Posted by Nikos Tsirmirakis on 2020-01-06

Building SQL Server in Azure with Terraform

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

Get in touch

If you need help with DevSecOps, Azure cloud or your SQL servers drop me a line.