---
title: "Arsalan Z (@arsalanz) | Hashnode"
description: "I love coding, automation & coffee. Read the latest articles by Arsalan Z on Hashnode."
url: "https://hashnode.com/@arsalanz"
---

@arsalanz

# Arsalan Z

@arsalanz · Joined January 2024

I love coding, automation & coffee.

### [List all databases with sizes](https://arsalanz.hashnode.dev/list-all-databases-with-sizes?utm_source=hashnode&utm_medium=feed)

To list all databases along with their size in bytes on a particular server. $resource\_group="rg-demo" $server="mssql-demo-dev" $databases=$(az sql db list --resource-group $resource\_group --server $server --query "\[\].{name:name}" -o tsv) foreach ($...

1 min read · [arsalanz.hashnode.dev](https://arsalanz.hashnode.dev/list-all-databases-with-sizes?utm_source=hashnode&utm_medium=feed)

[Sep 3, 2024](https://hashnode.com/posts/list-all-databases-with-sizes/66d70bbe516ffc9429ca1b2f)

### [Access artifacts from one project to another in azure devops](https://arsalanz.hashnode.dev/access-artifacts-from-one-project-to-another-in-azure-devops?utm_source=hashnode&utm_medium=feed)

Azure Artifacts Permissions Go to permissions of the project-scoped artifact and provide permissions to Build service of that project. Search in this format: | The project-level build identity is named \[Project name\] Build Service (\[Organization name...

1 min read · [arsalanz.hashnode.dev](https://arsalanz.hashnode.dev/access-artifacts-from-one-project-to-another-in-azure-devops?utm_source=hashnode&utm_medium=feed)

[Jul 10, 2024](https://hashnode.com/posts/access-artifacts-from-one-project-to-another-in-azure-devops/668e4689653a0108951d145a)

### [Setup and Run Terraform for Azure](https://arsalanz.hashnode.dev/setup-and-run-terraform-for-azure?utm_source=hashnode&utm_medium=feed)

Authentication Service Principal $env:ARM\_CLIENT\_ID='' $env:ARM\_CLIENT\_SECRET='' $env:ARM\_SUBSCRIPTION\_ID='' $env:ARM\_TENANT\_ID='' export ARM\_CLIENT\_ID='' export ARM\_CLIENT\_SECRET='' export ARM\_SUBSCRIPTION\_ID='' export ARM\_TENANT\_ID='' With Login ...

1 min read · [arsalanz.hashnode.dev](https://arsalanz.hashnode.dev/setup-and-run-terraform-for-azure?utm_source=hashnode&utm_medium=feed)

[Jul 8, 2024](https://hashnode.com/posts/setup-and-run-terraform-for-azure/668bb1d03eef9dba389a4d49)

### [Dynamically include variable groups for each env](https://arsalanz.hashnode.dev/dynamically-include-variable-groups-for-each-env?utm_source=hashnode&utm_medium=feed)

#build-stage.yml stages: - stage: Build ${{ if eq(parameters.enableVariableGroups, 'true') }}: variables: - ${{ each group in parameters.variableGroupNames }}: - group: ${{ group }} df #main-pipeline.yml stages: - templa...

1 min read · [arsalanz.hashnode.dev](https://arsalanz.hashnode.dev/dynamically-include-variable-groups-for-each-env?utm_source=hashnode&utm_medium=feed)

[Mar 20, 2024](https://hashnode.com/posts/dynamically-include-variable-groups-for-each-env/65facea544a5c1ada7e188d3)

### [SonarScanner in Dockerfile](https://arsalanz.hashnode.dev/sonarscanner-in-dockerfile?utm_source=hashnode&utm_medium=feed)

JavaScript FROM node:16.16.0 AS builder # Set an ARG to decide whether to run SONARSCAN ARG SONAR\_SCANNER\_VERSION=5.0.1.3006 ARG SONARSCAN=false ARG SONAR\_TOKEN ARG SONAR\_PROJECT\_KEY ARG SONAR\_HOST\_URL # Install Sonar Scanner RUN if \[ "$SONARSCAN" =...

1 min read · [arsalanz.hashnode.dev](https://arsalanz.hashnode.dev/sonarscanner-in-dockerfile?utm_source=hashnode&utm_medium=feed)

[Mar 20, 2024](https://hashnode.com/posts/sonarscanner-in-dockerfile/65facd6bfcda1df810f32c98)
