BI Thoughts and Theories

The 1.0 bits for ssisUnit are now on CodePlex . The Release page for it includes versions for SQL Server 2005 and 2008. The biggest feature in this release is a GUI for creating the unit tests. The test files are still XML, but the GUI abstracts away Read More...

A number of the SSIS MVPs were asked to contribute a white paper to MSDN a few months ago, and those articles were published recently. You'll notice a common thread in most of the topics: Considerations for High Volume ETL Using SQL Server Integration Read More...

While at TechEd this summer, I participated in a panel discussion on testing the database and related technologies. The panel also included Gert Drapers and Jamie Laflen of the Visual Studio Team System - Database Edition team, David Reed (who manages Read More...