Azure DevOps: Merging code to Main branch from a specific branch only

(2022-July-25) I really liked reading printed PC Magazines (https://www.pcmag.com/) or Computerworld newspapers (https://www.computerworld.com/) when I was in school. Those magazines pictured IT System or Database Admins as a special group...

Including reference data into a database deployment process or passing lookup tables to Production

(2022-Jun-20) As it takes a village to raise a child, it also takes a team to develop a good SQL Server database project. Previous efforts to maintain manual or custom SQL...

Metadata-driven pipelines in Azure Data Factory | Part 3

(2022-Jun-06) This blog post is a collaborative effort of several people, some of them I currently work with, and others' contributions came from their writing, so it’s more than natural...

Populating PostgreSQL JSONB column using Azure Data Factory Data Flow

(2022-May-31) 
Personal notes of one of the recent ADF JSON pipeline development to remember how to use it next time.
Requirements:

Sourcing data comes from a SQL Server database
The destination is a...

Metadata-driven pipelines in Azure Data Factory | Part 2

(2022-May-08) If you happened to read the Part 1 of this blog series, the main message of it was the Azure Data Factory Copy activity was not just a simple...

Metadata-driven pipelines in Azure Data Factory | Part 1

(2022-Mar-04) Looking in the Oxford dictionary, Metadata can be described as "​information that describes other information in order to help you understand or use it", as well as Pipeline is "a series...

Fixing a giant or running a SQL Server project deployment with Temporal tables

(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a 50-foot tall alien robot, whom he eventually befriended, he didn't know about a very special...

Trusting the Fine Print or connecting Azure Data Factory with Salesforce

(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” - David Eldersveld on Twitter. That puzzled me, but only for a little while, since I...

Can I create a CI/CD pipeline to deploy Python Function to Azure Function App using Windows self-hosted Azure DevOps agent?

(2022-Jan-10) My short answer to this question is Yes and No. Yes, you can use Windows self-hosted Azure DevOps agent to deploy Python function to the Linux based Azure Function...

“Could not find the modules: 'Az.Accounts' with Version: ''” error message and a story to remember

(2021-Dec-20) Part of the continuous integration and delivery for Azure Data Factory involves pre-deployment and post-deployment steps. Their main role is to stop triggers before deployment and restart them afterward,...