---
title: "Bob Blackburn (@BobBlackburn) | Hashnode"
description: "Principal Azure Data Engineer. Read the latest articles by Bob Blackburn on Hashnode."
url: "https://hashnode.com/@BobBlackburn"
---

@BobBlackburn

# Bob Blackburn

@BobBlackburn · Joined April 2024

Principal Azure Data Engineer

### [Azure Data Factory CI/CD with GitHub and Azure Pipelines](https://bobblackburn.com/azure-data-factory-ci-cd-with-github-and-azure-pipelines-b44356c3234c?utm_source=hashnode&utm_medium=feed)

Without source control for Azure Data Factory (ADF), you only have the option to publish your pipeline. And, it has to validate. Now with source control, we can save intermediate work, use branches, and publish when we are ready. The next step is CI/...

6 min read · [bobblackburn.com](https://bobblackburn.com/azure-data-factory-ci-cd-with-github-and-azure-pipelines-b44356c3234c?utm_source=hashnode&utm_medium=feed)

[Aug 19, 2024](https://hashnode.com/posts/azure-data-factory-ci-cd-with-github-and-azure-pipelines-b44356c3234c/66c2c34673c0d95001da3c4e)

### [CI/CD with GitHub Database Projects and Azure Pipelines](https://bobblackburn.com/ci-cd-with-github-database-projects-and-azure-pipelines-aeb5a5fed01f?utm_source=hashnode&utm_medium=feed)

With the high pace of development, data architects/engineers have to be able to keep up with our DevOps counterparts. We also want the many benefits of CI/CD for databases such as fewer errors, stable builds, better release management, and less manua...

6 min read · [bobblackburn.com](https://bobblackburn.com/ci-cd-with-github-database-projects-and-azure-pipelines-aeb5a5fed01f?utm_source=hashnode&utm_medium=feed)

[May 19, 2024](https://hashnode.com/posts/ci-cd-with-github-database-projects-and-azure-pipelines-aeb5a5fed01f/664a708c4540d3aea585c774)

### [Databricks Zip File Validation](https://bobblackburn.com/databricks-zip-file-validation-620c7c3f91aa?utm_source=hashnode&utm_medium=feed)

In many IoT systems, you will receive feeds that are in a zip format. Sometimes they are empty. We want to validate they contain a file before we start processing them because it involves moving the file around different file systems, running a shell...

2 min read · [bobblackburn.com](https://bobblackburn.com/databricks-zip-file-validation-620c7c3f91aa?utm_source=hashnode&utm_medium=feed)

[Apr 29, 2024](https://hashnode.com/posts/databricks-zip-file-validation-620c7c3f91aa/662fc329fa2ca73a8e73a786)

### [3 Steps to Run PowerShell in Azure Data Factory](https://bobblackburn.com/3-steps-to-run-powershell-in-azure-data-factory-e7c73d38e548?utm_source=hashnode&utm_medium=feed)

Azure Data Factory has many capabilities. But no tool is the best at everything. Sometimes you have an existing script that needs to be automated or PowerShell is the best programming option for the task at hand. Currently, ADF does not have a PowerS...

3 min read · [bobblackburn.com](https://bobblackburn.com/3-steps-to-run-powershell-in-azure-data-factory-e7c73d38e548?utm_source=hashnode&utm_medium=feed)

[Apr 29, 2024](https://hashnode.com/posts/3-steps-to-run-powershell-in-azure-data-factory-e7c73d38e548/662fc2dae7a3f6576176ad43)

### [SQL Server Indexing: 5 Steps to Better Performance](https://bobblackburn.com/sql-server-indexing-5-steps-to-better-performance-338f098c1f7b?utm_source=hashnode&utm_medium=feed)

Customers don’t want to wait more than a few seconds for an application to process and move to the next step. And we keep getting squeezed on our batch window to do all our daily processing. We cannot just throw more hardware at the problem. It may b...

6 min read · [bobblackburn.com](https://bobblackburn.com/sql-server-indexing-5-steps-to-better-performance-338f098c1f7b?utm_source=hashnode&utm_medium=feed)

[Apr 29, 2024](https://hashnode.com/posts/sql-server-indexing-5-steps-to-better-performance-338f098c1f7b/662fc25bbaaa9af47eae7749)
