SQLServerCentral.com Articles tagged Data Warehouse

Low Profile Architecture

Tue, 02 Apr 2013 06:00:00 UT

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.

ETL Performance Auditing - Part 1: Introduction to ETL Auditing

Tue, 05 Jun 2012 06:00:00 UT

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

RegEx for DBAs

Tue, 08 May 2012 06:00:00 UT

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

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Using The Kimball Dimensional Modeling Tool

Mon, 31 Oct 2011 06:00:00 UT

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.

Data Warehouse Development: Version 0

Thu, 07 Apr 2011 06:00:00 UT

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.

Creating Inferred Dimension Members with SSIS

Wed, 08 Dec 2010 07:00:00 UT

This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.