September 2008 - Posts

• SQLBI: Yet Another DWH Methodology?

  It is several years now that I and Marco Russo enjoy ourself developing BI solutions and teaching our customers how to build them. We started with Kimball methodology, then we tried Inmon's one and finally a mix of both, tailored to ours and our customer Read More... Posted Saturday, September 27, 2008 12:21 AM by AlbertoFerrari | 0 Comments

• SSIS: living in a parallel world? Not yet...

  Today I come into a nice bug (misfeature?) of SSIS 2008 and I'd like to share it with you. Let's start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read from two inputs, compare them and produce Read More... Posted Sunday, September 14, 2008 10:57 PM by AlbertoFerrari | 4 Comments Filed under: SQL Server, TableDifference, SSIS, Components, SQL