Introduction: The World Series (1979) and Photography Willie “Pops” Stargell started my interest in photography (…a funny way to start a post on a SQL Server blog site, but bear with me). Pops Stargell led the 1979 Pittsburgh Pirates to win the World Series. He was the MVP that year as well. My Mom, in …
Continue reading Context and Grain
Author:Andy Leonard
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
Richmond Code Camp 4
Richmond Code Camp 4 is Saturday 6 Oct 2007, 8:00 AM – 6:00 PM at ECPI-Innsbrook in Glen Allen, VA (Richmond’s West End). If you’re going to be in the area, stop by and catch a session or two! :{> Andy
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)
