Archive | March, 2010

Warehouse Design Tip -Schema’s

Data Warehouse design tip, and example for the use of schemas. The ability to override a description in a dimension.

1 Comment Continue Reading →

SSIS – Package Configurations

SSIS package configurations allow for portability of packages, password management, and security.

4 Comments Continue Reading →

2008 Resource Governor – Does it work?

The resource governor in SQL Server 2008 is a powerful tool to help you gain control over your query runtimes.

1 Comment Continue Reading →

SSIS Checksum – a must have skill

Overview When loading from source systems that don’t yet have the SQL Server 2008 Change Data Capture (CDC) enabled, using a checksum calculation to determine if data has changed is a critical Data Warehouse load concept to understand.  This will allow you to read the source, that can have dozens of columns, and with a […]

7 Comments Continue Reading →

Data Quality -Dynamic Business Validation

Table driven, dynamic validations to find post-load data issues.

Leave a Comment Continue Reading →

Database Driven Aggregations

Introduction Have you ever had a series of aggregate (tsql) queries to run?  Do you want to be sure they all run in the right order?  Do you want to make the changes “dynamic” (no code changes required)?  Certainly you can build an SSIS package that calls sql with the control-flow and control dependencies, however, […]

Leave a Comment Continue Reading →

Help – My disk performance VI

Part VI in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers additional monitoring, and wraps ups some leftovers from this series.

4 Comments Continue Reading →

Help – My disk performance V

Part V in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers basic monitoring.

4 Comments Continue Reading →

Help — My disk performance IV

Part IV in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database filegroups and files.

7 Comments Continue Reading →

Help – My disk performance III

Part III in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database partitioning and compression.

2 Comments Continue Reading →