Been a while since my last post – got a few in the backlog now though so will have a trickle of articles coming through
Tag: Azure
Building the Lakehouse Architecture With Azure Synapse Analytics
We’re all largely familiar with the common modern data warehouse pattern in the cloud, which essentially delivers a platform comprising a data lake (based on
Change Data Capture Upsert Patterns With Azure Synapse Analytics and Databricks
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
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
SQL Of The North 