Improving the performance of packages is always a focus of ETL developers. It should go without saying that your first duty is to make the package work... after which you can then make it work fast. In an effort to help you out with the latter, I've got two presentations I'm set to deliver this month. The first is to Colin Stasiuk's (blog|twitter) Edmonton PASS chapter, and the second is at SQL Saturday #65 in Vancouver.
Diagnosing and Addressing Performance in SSIS
On February 16th, the Edmonton PASS chapter is hosting me virtually to talk on the subject of optimizing SSIS packages. You too can attend this webcast even if you're not there - I can guarantee that, because if it's not broadcast, I won't be able to deliver it, because I'm not going to be there in person either.
I'll be covering one of the essential steps that too often seems to get overlooked in trying to make SSIS packages "go fast"... and that's knowing how to find out where they're actually "going slowly." If you don't know why this is important, or don't know there are techniques that can help you do this, you should probably make time to sign up.
I'll have to make a dig or two at Colin's expense during the webcast. He trimmed my bio down on his site... he must not appreciate my humour. Please feel free to feed me some fodder in the comments.
UPDATE: Presentation materials on SkyDrive
Data Warehouse ETL with Integration Services
On February 26th, the famous SQL Saturday franchise will make its first stop in Vancouver at the Pinnacle Mariott. If you're anywhere close to the area and touch SQL Server, you need to be here. The following week is the Microsoft MVP Summit in Redmond, which the organizers of Vancouver's SQL Saturday exploited to the fullest. A ton of SQL MVPs will arrive a little sooner than normal to the Summit just to be able to make the short trip up to Vancouver. Some of them will be presenting - for example, SQL rock stars like Brent Ozar and Brad McGehee. Others couldn't get a speaking slot, but they're coming anyway, and they're all open to conversation.
I was fortunate enough to leverage my "local" credentials to get a session on performing data warehouse ETL with SSIS. I'll start by describing the multiple ways to fill dimension tables with SSIS, leaving you with solid guidelines to pick a technique that performs in your scenario. I'll finish up with the relatively simple techniques involved in fact table population, as well as some optimization techniques to speed the whole process up.
UPDATE: Presentation materials on SkyDrive

Sounds very useful, will you make the slide deck available via your blog after?
ReplyDeleteUnfortunately it will be 12 midnight here in the UK when it starts :(
Absolutely. Hopefully, we'll have the whole thing recorded as well!
ReplyDeleteSweet! Pencilled you in ;-)
ReplyDeleteSwapped phone to WP7 last wk, which of course doesn't sync calendar to my desktop Outlook like WM6.5 did [don't even get me started!] so I didn't catch my reminder.. Is there a replay someplace I could hit up?
ReplyDeleteKeep checking the Edmonton PASS chapter site - if Colin was able to record it, that's where he'll post it. For the slides and demo package, see my Presentations on SkyDrive.
ReplyDelete