Presenting at the Pacific Northwest SQL User Group May 12th

The Pacific Northwest SQL Server Users Group has invited me to come speak to them about SSIS next week (Wednesday, May 12th). I’ll be presenting a preview version of my Performance Design Patterns talk that I put together for the MS BI Conference in June. If you’re interested in attending, please check out their chapter…


SQL Server 2008 R2 launches

SQL Server 2008 R2 was released to manufacturing today! For more R2 information, please see: SQL Server 2008 R2 Website SQL Server 2008 R2 Digital Tour SQL Server Team Blog SQL Server Performance Blog R2 was really focused on self-service business intelligence for reporting and analysis, and as I mentioned in a previous post, one…


SSIS sessions at Tech·Ed 2010 in New Orleans

I’m really looking forward to presenting at Tech·Ed again this year! As you probably already know, the Microsoft BI Conference is happening at the same time / place, which means the conference will have even more BI content than it usually does. I’m currently signed up to present a break out session: BIE302 | Beyond…


Exporting to Excel 2007 – .xlsx vs. .xlsb

Douglas blogged about this a while back, but it’s come up a couple of times in the last little while, so I thought I’d repeat it here. The Excel 2007 default output format for the SSIS Excel Destination is Excel Binary Format (.xlsb). If you’re creating a new Excel file, and have given it an…


Version 1.1 of the Connectors for Oracle and Teradata by Attunity now available

A new version of the SSIS connectors for Oracle and Teradata is now available from the Microsoft download site. Changes Performance Improvements for Oracle and Teradata Components Optimize conversion functions in the Oracle and Teradata source and destination components. A major performance enhancement for the Oracle destination component when set to work in fast-load mode….


How do I disable all logging on my packages?

A quick post today – I received this question from a customer earlier today, and it took me a little while to figure it out. We have a number of packages that use a SQL Server logger. We want to turn logging off, but don’t want to modify all of our packages. Is there an…