joel.fail

The stories of my failures
Data Engineering Microsoft Azure Microsoft SQL Server

Work-around for Id columns in Dimensions using Synapse Serverless SQL engine

Azure Synapse is one of the latest flagship tools for analytics within the Azure Cloud. Synapse analytics is an all-in-one...
Read More
Data Engineering General Microsoft SQL Server

Each problem has different approaches

Last day on LinkedIn, I saw a post in my feed about a woman who was making her transistion into...
Read More
Data Engineering General Microsoft Azure Microsoft SQL Server

Using mini dimension for fast-changing attributes

Introduction This blog post will be about the use of mini-dimensions for fast-changing attributes, also known as the type 4...
Read More
Data Engineering General Microsoft Azure Microsoft SQL Server

Tracking history in dimensions

One of the most important aspects in data warehousing and Business Intelligence, is the ability to look back in time....
Read More