SQL Server Data Warehouse Concepts, Schema Design, and Implementation

A Data Warehouse acts as a centralized repository, is subject oriented, time variant and non-volatile repository. This article covers some concepts that will help you better design these structures.

Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension

In this next article, we look at creating balanced dimensions on demand.

The Data Warehousing Choice

What is your choice for data warehousing? Is it a cloud platform? Which one is attractive to you?

Data Warehouse Considerations - SCD Type 2 vs Overwrite Dimension Tables

How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.

The Load of Real Time Data Warehouses

How much load do real time updates place on a data warehouse? Steve has a few thoughts on the analysis of the Amazon Redshift dataset, Redset.

Dimensional Modeling Case Study Part 2 - Days Dimension

Learn how you can model days in a dimension that might need to be aggregated in different ways for your data warehouse operations.

A Overview of Amazon Redshift

This article gives an overview of Amazon Redshift, the cloud data warehouse in AWS.

How do you secure sensitive data in a modern Data Warehouse?

In 2019 Canadian Broadcasting Corporation (CBC) news reported a massive data breach at the Desjardins Group, which is a Canadian financial service cooperative and the largest federation of credit unions in North America. The report indicated, a "malicious" employee copied sensitive personal information collected by Desjardins from their data warehouse. The data breach compromised the […]

Pairing Data Vault and Biml for DW Agility

Agile data warehousing can be challenging. Pairing the right methodologies and tools can help. Here is how my team met the challenge by using Data Vault methodology and BIML scripting.

Exit Stage Right