geekSpeak recording - Real World SQL Server Integration Services with Matthew Roche

Play geekSpeak recording - Real World SQL Server Integration Services with Matthew Roche
Sign in to queue


This geekSpeak is all about SQL Server 2005 Integration Services. We are lucky to have a real expert from the industry, Matthew Roche, to share his experiences with us.

Matthew shows us how SSIS is a real development studio, since it's an instance of Visual Studio 2005, with new designers. It's very familiar for folks who are moving from a traditional development environment. He gets us familiar with tools and techniques, solutions and projects, like the drag-and-drop approach to building packages, opportunities to include scripts, and develop your own components as .NET Assemblies.

Matthew answers some great questions around performance, programmability. He helps us understand the distinction between data flows and control flows, and how best to manage SSIS packages.

He offers some useful guidance on what scenarios merit what choices for moving data from one place to another - be it .NET app, SSIS, TSQL, BCP and so on.

But the most important reason to watch is to find out what Matthew would "chew off his own mouse finger" to avoid having to do. Big Smile

Be sure to check the geekSpeak blog for upcoming geekSpeaks!



SQL Server



Download this episode

The Discussion

  • User profile image
    hail hail

    sorry to moan - but i find all the "geek speak's"  i've listened to so far very painful - the first 15 mins seems to consist of back slapping - which is very nice and all but i have a short attention span so after 5 mins i'm ready to chop my mouse finger off - can you guys not just get to the bones of the topic allot quicker please please

    sorry to compain - i love the videos and screen casts and sandbox stuff - they get right to the meat straight away

    although the sandbox stuff often times out before i finish - so i  have to start all over again - the time constraint is such that afterwards i struggle to figure out what i've learned as i get so stressed about the "timeout" that my attension is not really on the topic sadly

    all the best - it has gotten a whole lot better - i mean once upon a time their was little or no audio/visual training except for employers spending a fortune once every three years - which is a lng time to waut when u r struggling - and audio visual for me is waaaaayyy better that dry old anbigous jargon filled pdf's - i'm frickin lovin the videos and screen casts both here on ch9 and the site learn stufff -fabrutsio

    ta -j

Add Your 2 Cents