Category: Architecture

Multi-Source partitioned Azure Analysis Services tables – cold data from Azure Data Lake Store, hot data from Azure SQL Database

Modern data analytics platforms often follow a hub and spoke architecture in which a data hub is used as central

What is a Data Lake? Pentaho CTO James Dixon is credited with coining the term “Data Lake”. As he describes

Since my last blog post about a SSIS package design pattern I’ve received quite some positive reactions and feedback. Microsoft

I recently had a chat with some BI developers about the design patterns they’re using in SSIS when building an

Enter your email address to follow this blog and receive notifications of new posts by email.

Email Address:

Search for: