Presenting at Microsoft Tech Ed

I’m happy to once again have the chance to talk about SSIS at Tech Ed North America. I’ll be presenting two sessions this time around – a Denali focused break-out session, and an interactive session about how to scale out SSIS, which I’ll be co-presenting with Joe Quint. DBI317 – What’s New in Microsoft SQL…


Speaking at SQL Saturday #71 – Boston

I’m really excited to get to present at another SQL Saturday event — this time in Boston! I really enjoyed the events in Redmond, and I’m looking forward to presenting two sessions this time around. In the morning I’ll be co-presenting SSIS – The New Stuff with Andy Leonard. We’ll take a look at some…


SQL Server Customer-Ready videos on Channel 9

Channel 9 has posted a series of videos that talk about what’s coming up in SQL Server Denali. These short (< 10 minutes each) videos are done by members of the engineering team, and are meant to give customers a peek into the goals and visions on why certain SQL Server features were implemented. The…


Learn SQL Server 2008 R2 Integration Services Now

The Data Platform Evangelism team has published the third unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a SQLInsights) on MSDN. The SQL Server 2008 R2 Business Intelligence Training Course (SQLInsights) will help you learn how to build your first Microsoft Business Intelligence solution. SQLInsights is a great resource for developers, consultants…


How do I log to multiple locations?

Problem: I want all errors in my package to be reported to the Windows Event Log, and all other events to be logged to SQL Server. Logging all messages to multiple locations is pretty simple. On the Configure SSIS Logs dialog (SSIS –> Logging …), you can add any number of loggers. The tricky part…


Tech Ed 2011 – Session Preference Survey

There is a Session Preference survey up on the Tech Ed North America 2011 site. This is a great way to provide input to the session selection committee. If you plan on attending Tech Ed NA, be sure to fill it out before the survey closes (February 17th).


Why does my package run slower in BIDS than DTEXEC?

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. If you haven’t already read it, go do that now. It has a pretty picture in it and everything. I’ll wait. The purpose of…


LEFT Function in SSIS Expressions

There are a number of small changes to Integration Services in SQL Server Denali that might not be immediately apparent. One of these is the new LEFT function in the SSIS Expression language.   This new function provides a simpler way to get the first part of string expression – prior to Denali, you’d use…