Change Data Capture (Referred to as CDC for the rest of this article) is a common pattern used to capture change events from source databases
Category: Synapse
Cross Database Queries With Azure Synapse (Serverless)
I had a recent challenge from a customer that involved the need to join together datasets from different regions and present them as a unified
From Warehouse To Lakehouse – ELT/ETL Design Patterns With Azure Data Services
I like a good pattern. I also like a good framework. From a data perspective, nothing lends itself better to having both of these as
Building A Logical Data Warehouse With Azure Synapse Analytics
In a previous post I blogged about “Building the Datawarehouse-less Datewarehouse“, which is pattern I’ve always liked wherein we can build a logical star schema
Automating Synapse Analytics Compute Management With Azure Data Factory
Note – whilst I use the term Azure Data Factory in this article, the approach is supported by both Azure Data Factory AND Synapse Pipelines
Adding new python libraries to azure synapse spark pools
This is just a short post, but it’s a prelude to a larger one I’m writing on record-linkage using Synapse Spark Pools with this step
SQL Of The North 