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

Download this episode

Download Video

Description

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!


 

Tag:

SQL Server

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      hail hail
      hi

      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 asp.net site learn stufff -fabrutsio

      ta -j

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.