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)

PASS Presentation – Team Edition for Database Professionals

I am honored and so excited to be presenting a couple sessions at the PASS Summit in Denver next month! One presentation is entitled Applied Team Edition for Database Professionals. The focus is TEDP in action for database development. I cover a lot of the material in my Testing the Database chapter of the new Wrox book: Professional …
Continue reading PASS Presentation – Team Edition for Database Professionals

PASS Presentation – SSIS Development And Testing

I am honored and so excited to be presenting a couple sessions at the PASS Summit in Denver next month! One presentation is entitled Integrate Your SSIS Development. The focus is on SSIS development and testing. I touch on continuous integration and test-first development – using Team Foundation Server for the CI and Team Edition for Database Professionals to …
Continue reading PASS Presentation – SSIS Development And Testing

Bad IT Project Management

My sister-in-law recently passed the PMP certification (congratulations Heather!). I’m waiting for a call from her asking if we need to add resources. The resources comment above is a joke, but it isn’t really that funny. It’s indicative of my decades of experience with bad IT project managers. I believe and hope I have worked …
Continue reading Bad IT Project Management