Monthly Archives: March 2009

Updating Custom Assembly References in SSIS

Just a quick tip related to a recent problem I had with a custom task I developed for SSIS. I had to recompile it recently, and in the process, managed to change the public key associated with the assembly. Since … Continue reading

Posted in Uncategorized | Comments Off on Updating Custom Assembly References in SSIS

SSWUG Business Intelligence Virtual Conference and SDS

It’s been a busy first quarter, but I should have a little more time available to blog now.  I’ve just completed shooting my sessions for the SSWUG Business Intelligence Virtual Conference, which has been one of the things occupying my … Continue reading

Posted in Uncategorized | Comments Off on SSWUG Business Intelligence Virtual Conference and SDS

Scale Up or Scale Out for SQL Server Data Warehouses

Historically, scale up has been the model for Microsoft data warehouses. Running a large, multi-terabyte data warehouse meant buying a lot of hardware for a single server, and hoping that it would be enough, once the warehouse was fully loaded … Continue reading

Posted in Uncategorized | Comments Off on Scale Up or Scale Out for SQL Server Data Warehouses