New TFS 2008 VPC Images are available

Previously, Microsoft has posted an update to the Visual Studio 2008 Downloads page:  IMPORTANT: The VPC downloads listed above will expire on November 1, 2007, which is earlier than anticipated. It is important that you backup or move any data to a new location before that date. To move Team Foundation Server data, see Moving …
Continue reading New TFS 2008 VPC Images are available

Master Data Management 101: Standardize Units of Measure

Introduction      There’s quite a bit of hoopla about MDM lately, mostly due to awareness. While “Lacks needed data” was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), “Insufficient or inadequate master data” made a decent showing at second with 17 votes (see Table …
Continue reading Master Data Management 101: Standardize Units of Measure

Master Data Management 101: Standardize Units of Measure

Introduction      There’s quite a bit of hoopla about MDM lately, mostly due to awareness. While “Lacks needed data” was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), “Insufficient or inadequate master data” made a decent showing at second with 17 votes (see Table …
Continue reading Master Data Management 101: Standardize Units of Measure

Master Data Management 101: Standardize Units of Measure

Introduction      There’s quite a bit of hoopla about MDM lately, mostly due to awareness. While “Lacks needed data” was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), “Insufficient or inadequate master data” made a decent showing at second with 17 votes (see Table …
Continue reading Master Data Management 101: Standardize Units of Measure

Master Data Management 101: Standardize Units of Measure

Introduction      There’s quite a bit of hoopla about MDM lately, mostly due to awareness. While “Lacks needed data” was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), “Insufficient or inadequate master data” made a decent showing at second with 17 votes (see Table …
Continue reading Master Data Management 101: Standardize Units of Measure

SSIS Design Pattern – Read a DataSet From Variable In a Script Task

Introduction One of the things I appreciate about SSIS is the script elements. There is a lot of functionality built into the engine out of the box but I like the idea of having a Script Task on the Control Flow and a Script Component on the Data Flow just in case. Last month I used …
Continue reading SSIS Design Pattern – Read a DataSet From Variable In a Script Task

Accessing Parent Package Variables In Child Packages… Without Configurations

If you’ve needed to close the information loop in an SSIS Parent-Child package architecture (also known as Master Package Design), Steve Fibich has a post is for you! This is the neatest thing I’ve seen in a long time. Once a child package is called, the parent package variables are available for reference and update – without …
Continue reading Accessing Parent Package Variables In Child Packages… Without Configurations

From my PASS presentations: Custom Test Condition Code: ETL Counts (Team Edition for Database Professionals)

I’d like to thank the people that attended my sessions at the 2007 PASS Summit in Denver this week! I had a blast and hope you all did as well. The code will be available from the PASS website and on a DVD. For those in my sessions, I promised I would post the code …
Continue reading From my PASS presentations: Custom Test Condition Code: ETL Counts (Team Edition for Database Professionals)