Most RecentMost ViewedMost LikesBalanced Data Distributor (BDD) for SQL Server 2012 is Now AvailableFirst published on MSDN on Jun 20, 2012 The Balanced Data Distributor (BDD) transform has updated and released for SQL Server 2012.SSIS Presentations from SQL Bits Available OnlineFirst published on MSDN on Apr 17, 2012 Three slide decks from the SSIS presentations I did at SQL Bits X in London have been posted online.SSIS Case Study – InnovapostFirst published on MSDN on Apr 04, 2012 An interesting case study about how SSIS is used by Canada Post has recently been published.DQS Performance and Best PracticesFirst published on MSDN on Mar 12, 2012 Hi DQS users, I want to draw your attention to the Data Quality Services Performance Best Practices Guide that describes how to get the best performance out of DQS, especially when working with large data volumes.Using the PipelineComponentTime eventFirst published on MSDN on Aug 11, 2011 Today’s post is from Wee Hyong Tok – a Program Manager on the SSIS team based in Shanghai.Troubleshooting SSIS Package Performance IssuesFirst published on MSDN on Aug 07, 2011 Today’s post is from Wee Hyong Tok, a Program Manager with the SSIS team based in Shanghai.The Right Tool for the JobFirst published on MSDN on Jul 06, 2011 Most of this content comes from my Performance Design Patterns series.Pattern: Replacing NULL values with a Derived ColumnFirst published on MSDN on Apr 05, 2011 This pattern has been out there for so long I had contemplated taking it out of my Performance Design Patterns talk, but it looks like it still managed to help some people at SQL Saturday #71 last weekend.Why does my package run slower in BIDS than DTEXEC?First published on MSDN on Jan 15, 2011 Jamie Thomson recently suggested that you should run your packages using DTEXEC when doing performance testing, as it (typically) performs much better then when the same package is run in BIDS.Speeding up Derived Column TransformsFirst published on MSDN on Aug 20, 2010 A new technical note about splitting up transforms to increase performance has been posted on the SQLCAT site.
