Posts

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 DDL scripts to create a database have fallen into oblivion. Git-based development practice and automation to deploy incremental database changes to target environments have become the norm. A development team now can easily segregate their efforts to deliver database solutions faster and more consistently using the SQL Server Database projects in Visual Studio - https://visualstudio.microsoft.com/vs/features/ssdt/ .

Metadata-driven pipelines in Azure Data Factory | Part 3

Populating PostgreSQL JSONB column using Azure Data Factory Data Flow

Metadata-driven pipelines in Azure Data Factory | Part 2

Metadata-driven pipelines in Azure Data Factory | Part 1

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

Trusting the Fine Print or connecting Azure Data Factory with Salesforce

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

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

Fail activity in Azure Data Factory and Why would I want to Fail

Error [IM002] [Microsoft][ODBC Driver Manager] "Data source name not found and no default driver specified" and who do you trust?

Lambda Architecture in data systems and possible meaning of this name

Data Modeling at your fingertips

New Azure Data Factory home page, what's in it for me?

Executing Azure Data Factory pipelines by Power App / Automate Flow

Azure Function Drain mode

Blog post about Copying Azure files to SharePoint, comparing Logic App and Power Automate Flow for this, and Trust No One

Creating a generic (template) pipeline in Azure Data Factory to send email messages with attached files from Azure Storage account

Recent updates on my work with Data Vault and Azure Data Factory

Using Logic App to send multiple attachments from Azure Storage Account

How to add a Constant value to Dynamic JSON array in Azure Data Factory

How I tested Parse data transformation in Azure Data Factory

Upgrading Durable Function Extension of my Azure Function App

Passing JSON arrays between pipelines in Azure Data Factory

About Friendship and Using Optional Stored Procedure parameters in Azure Data Factory

Power of Unlearning

Logical crossroads in Azure Data Factory (IF and Filter operations)

These little things about Azure Data Factory

Logging the history of my past SQL Saturday presentations

Using Azure Durable Functions with Azure Data Factory - HTTP Long Polling

Using Durable Functions in Azure Data Factory - Support for long running processes in Azure Functions