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.
Archive | Design Tips RSS feed for this archive
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 […]
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.