Brian Knight's Performance Tuning SSIS talk from Tech Ed 2010 has been posted online . Performance Tuning Microsoft SQL Server Integration Services In this demo-rich presentation, learn some of the common and not so common ways to tune SQL Server...

The Performance Design Patterns talk I did at Tech Ed 2010 has been posted online . This is pretty much the same talk I gave at SQL Saturday #43 , so if you had attended and were looking for the slides, you can find them on the MS TechEd site. Enjoy...

Another talk at the MS BI Conference that I really found useful was Jeff Bernhardt’s talk about the different data integration technologies at Microsoft . Data Integration at Microsoft: Technologies and Solution Patterns There are many reasons to contemplate...

One of the sessions I did at the MS BI Conference last week is now available online at msteched.com . Beyond Scripting: Developing Reusable Extensions for Microsoft SQL Server Integration Services Have you written scripts for your ETL process that you...

While developing some custom transforms for my talks at the BI Conference next week , I hit a problem where I was getting an a failed HRESULT (COM Exception) in my PreExecute () method on a call to BufferManager.FindColumnByLineageID (). HRESULT 0xC020402D...

I’m happy to be presenting at SQL Saturday on June 12th. I’ll be presenting a modified version of the SSIS Performance Design Patterns I’ll be giving at the MS BI Conference in New Orleans next week. There seems to be a whole SSIS track at SQL Saturday...