Thursday, August 18, 2011 10:40:00 PM
Synchronous and asynchronous components, memory buffers, data type choices, Oh My!
Tuning the data flow is all about choices.
In this session we'll walk through some of the choices that can give you the biggest performance boosts in your SSIS data flow. Together we'll work through the differences between synchronous and asynchronous components. We'll highlight components that should be avoided and explore alternates that can help us create the fastest data flow possible.
We just ran into Tim at Microsoft the other day and he was NOT sporting his yellow laptop. His company laptop was a very un-Tim gray; though he had made amends with his screaming yellow mouse. In support of Tim, bring your favorite yellow food. We'll make sure we get our US RDA of yellow #5!We will be providing food as usual, just of a slightly different hue.
Thursday, August 11, 2011 10:39:00 PM
No. He's still camped out in Denali land, but he'll take a break from researching and writing about the latest release of SQL Server code named Denali to let us know what new tools we may soon get to use. He's trekked farther up and farther in with CTP 3 and has some great stories to share around the campfire.
Bring your s'mores, but don't set off Mark's sprinkler system.