Archive | Design Tips RSS feed for this archive

SSIS Design Tip – Build For Restartability

SSIS package restartability is an important thing to think about as you think about design. It will allow for supporability, as well as ease and speed in new development.

Leave a Comment Continue Reading →

Data Warehouse – AutoShrink how-to

Introduction Space management is always a challenge in any system, however, in systems that are designed to grow-grow and grow, it seems to be a particularly big challenge as to how best manage space.  This post will give you an overview how to set the auto-shrink correctly to allow for even distribution of data within […]

Leave a Comment Continue Reading →

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 →