SQLServerCentral: Articles tagged Data Warehouse

Low Profile Architecture

The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month. Read more...

By Igor Zaychik 2013/04/02 | Source: SQLServerCentral.com | Category: sql

Rating:

|

Discuss |

Briefcase | 2,855 reads

ETL Performance Auditing - Part 1: Introduction to ETL Auditing

This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup. Read more...

By Frank A. Banin 2012/06/05 | Source: SQLServerCentral.com | Category: etl performance

Rating:

|

Discuss |

Briefcase | 8,736 reads

RegEx for DBAs

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions Read more...

By David Poole 2012/05/08 | Source: SQLServerCentral.com | Category: regex

Rating:

|

Discuss |

Briefcase | 9,875 reads

Using The Kimball Dimensional Modeling Tool

Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems. Read more...

By Jim Nichols 2011/10/31 | Source: SQLServerCentral.com | Category: bi

Rating:

|

Discuss |

Briefcase | 6,215 reads

Data Warehouse Development: Version 0

What do you do first when developing a data warehouse? MVP Andy Leonard brings us a look at the foundation he uses, which might surprise you. Read more...

By Andy Leonard 2011/04/07 | Source: SQLServerCentral.com | Category: data warehouse

Rating:

|

Discuss |

Briefcase | 8,711 reads