BI Thoughts and Theories

I've been meaning to post this for a while, but real life keeps intruding. I did a presentation on SSIS performance for the Charlotte SQL Server User Group at the end of November. It went well, though I was trying to squeeze a 90 minute presentation into Read More...

I'll be doing a web cast for the Charlotte SQL Server User Group , our local PASS chapter, on SSIS Performance Tuning on Nov. 28, 2007 at 12:00 EST. From the abstract: "This presentation will cover the various aspects of performance tuning in SQL Server Read More...

A question came up recently on the SSIS forums on translating lookup codes into a description within the data flow. That is, given code "A", how do you translate it into a more descriptive value, such as "Apple"? As a general rule of thumb, if the the Read More...