Blog

Fixing the Write-Host Invalid Color Error in PowerShell

Azure DevOps

PowerShell

FabricPBIP

Fabric

Error

We’ve all encountered those quirky errors that crop up like this Write-Host color error in PowerShell. If you’ve seen an error that looks something like:

Creating an SSH Connection in Azure DevOps Pipelines to Azure App Service

azure

Azure DevOps

CI/CD

Azure Web Apps

quarto

github

Docker

Open an SSH Connection during an Azure Devops Pipeline deployment to Azure App Services for Advanced Configurations

Performance Monitoring for Copy Activities in Azure Data Factory

azure

adf

data factory

synapse

performance

monitoring

In Azure data orchstration, ensuring the efficient transfer of data between systems is crucial. This is where Azure Data Factory (ADF) and Azure Synapse Analytics shine.…

Copying Schemas between SQL Databases

azure

sql

database

Do you want to know how to copy Schemas between SQL Databases? What is the best way to copy data and their table definitions between SQL Databases

Deploying Quarto to Azure Static Web Apps

azure

quarto

github

Learn how to install and render Quarto documents using Github Actions and Workflows

Essential Non-Technical Tools for Data Consultants

stashpad

goodnotes

iPad

Notes

Non Tech

Greenshot

Zoomit

Essential Non-Technical Tools for technolgy Consultants that I’m currently using to help with my workflow

How to install and render quarto projects with Github Workflows

azure

quarto

github

Learn how to install and render Quarto documents using Github Actions and Workflows

Essential Non-Technical Tools for Data Consultants

azure

quarto

github

Essential Non-Technical Tools for technolgy Consultants that I’m currently using to help with my workflow

How to deploy Quarto Blog to Azure Static Web Apps

azure

quarto

github

Learn about Quarto and how to configure your Free Azure Static Web App to deploy a blog

Handling UK Bank Holidays in Azure Data Factory & Synapse

azure

adf

data factory

api

Synapse

Sometimes you have processes that you don’t need to run in certain scenarios. The past year I’ve been working with market trading data. Trading in exchanges happens every…

Using Dynamic column metadata from sp_columns in ADF (to ignore calculated columns) while using copy activities

azure

adf

data factory

sql

Recently, I encountered an issue where we had to copy data from one Azure SQL database to another using Azure Data Factory (ADF) V2. The entire process was dynamic using…

Back to the Data

news

Welcome back to a long overdue blog rebuild. I’ve attempted to rebuild this blog 3 times so far in the last 3 years. So finally I have finished it (if you’re reading this).