Introduction I am honored to present Designing an SSIS Framework and “I See a Control Flow. Now What?” at SQL Saturday #84 in Kalamazoo Michigan 17 Sep 2011! I See a Control Flow. Now What? This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS ...

Introduction This isn’t a trick. It’s not a gimmick. It’s not bait-and-switch. It is selfish; please allow me to explain: I Am Here To Help™ This has been my motto for the past few years. How can I serve you today? Are you thinking about starting a User Group and don’t know where to begin? I can help. Are you planning an event and encountering ...

A little over a month ago, I wrote an article (Is There Such a Thing as Easy ETL) about expressor software and their desktop ETL application, expressor Studio. I wrote about how it seemed much easier than the native ETL tools in SQL Server when I was reading up on the tool, but that the ''proof would be in the pudding'' so to speak when I ...

I am honored to present Designing an SSIS Framework to Hampton Roads SQL Server and SharePoint Users Group tomorrow, 20 Jul 2011! You can register here. Details: Infotec 100 Constitution Dr Virginia Beach, VA 23462 Wednesday, July 20, 2011 at 6:30 PM (ET) If you read this blog and will be there, introduce yourself! I’m the fat ...

Matt Masson, Tim Mitchell, and I are presenting A Day of SSIS in the Enterprise Monday 10 Oct 2011! The following is cross-posted from the PASS Blog: Today's post is from Andy Leonard who, along with Tim Mitchell, will be presenting "A Day of SSIS in the Enterprise". You can read more about his session here: ...

E.T.L. That's Extract - Transform - Load. That doesn't sound like a lot of work when all you need to get loaded is a simple Access database or an Excel spreadsheet. In a situation like that, the process is so simple, all you really need to focus on is the L in ETL. There's not a whole lot of E.T. to process, despite how wonderful that movie ...

Introduction I’m going to be talking about SSIS a lot in June! From Zero To SSIS! Need to learn SQL Server Integration Services? Got a week? I’m delivering From Zero To SSIS! in Farmville Virginia 6-10 Jun 2011. Class size is limited to 8 students. Five full days of SSIS goodness. And, Christy’s catering lunch!  Email me if you’re ...

Introduction I'm honored to deliver two presentations to the Regina Technology Community 26 Apr 2011! Part I - Database Design for DevelopersThis interactive session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable ...

  Introduction Jes Borland (Blog | @grrl_geek) is hosting this month's T-SQL Tuesday - started by SQLBlog's own Adam Machanic (Blog | @AdamMachanic) - and it is about aggregation. I thought I'd show a couple ways to do aggregation using SSIS. The Aggregate Transformation in SSIS The Aggregate transform in SSIS is fast. I ...

Introduction I am honored to once again be selected to present at Roanoke Code Camp! An Introductory Topic One of my presentations is titled ''I See a Control Flow Tab. Now What?'' It's a Level 100 talk for those wishing to learn how to build their very first SSIS package. This highly-interactive, demo-intense presentation is for beginners and ...