Andy Leonard : ETL

Little Data Remains Important in Healthcare IT

andyleonard — Tue, 30 Apr 2013 14:31:24 GMT

In his article Healthcare's Big Problem With Little Data , author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization...(read more)

SSIS Design Patterns, the Book

andyleonard — Mon, 06 Aug 2012 16:37:43 GMT

For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current...(read more)

Have You Downloaded SQL Server 2012 Evaluation Edition? Why Not?!

andyleonard — Thu, 08 Mar 2012 19:00:00 GMT

I am installing SQL Server 2012 Evaluation Edition on a virtual machine as I type. You can do this. Here’s one way: Grab some virtual machine software. I like Oracle VirtualBox . It’s cool. It’s free. Install VirtualBox. Download the 180-day free trial...(read more)

Updated SSIS Framework, Now Includes Reports

andyleonard — Wed, 07 Mar 2012 12:00:00 GMT

I have built a beta version of Linchpin People ’s SSIS Framework, now including much-requested reports. You can grab the updated copy here . I appreciate any feedback you care to share. :{>...(read more)

Stairway to SSIS Step 3–Adding Rows in Incremental Loads

andyleonard — Fri, 16 Sep 2011 11:00:00 GMT

If you haven’t yet, check out the Stairways – a series of tutorial articles at SQL Server Central. They. rock. I was really excited when Steve Jones ( Blog | @way0utwest | SQLPeople ) contacted me to write the Stairway series of tutorials for SSIS! The...(read more)

Designing an SSIS Framework

andyleonard — Fri, 16 Sep 2011 11:00:00 GMT

In preparation for SQL Saturday #84 – Kalamazoo , SQLBits 9 , and the PASS Summit 2011 ; I’ve been honing my presentation called Designing an SSIS Framework. I delivered this presentation a few times over the past couple months. Each time, I promised...(read more)

Presenting at SQL Saturday #84–Kalamazoo 17 Sep 2011!

andyleonard — Wed, 07 Sep 2011 21:00:00 GMT

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...(read more)

I Am Here To Help™

andyleonard — Fri, 19 Aug 2011 13:30:00 GMT

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...(read more)

Presenting at Hampton Roads SQL Server and SharePoint Users Group Tomorrow!

andyleonard — Tue, 19 Jul 2011 16:58:14 GMT

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...(read more)

PASS Precon Information: A Day of SSIS in the Enterprise

andyleonard — Fri, 08 Jul 2011 11:00:00 GMT

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...(read more)

SSIS Training (from me!)

andyleonard — Tue, 03 May 2011 11:00:00 GMT

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...(read more)

Presenting at Regina Technology Community 26 Apr 2011!

andyleonard — Tue, 19 Apr 2011 11:00:00 GMT

Introduction I'm honored to deliver two presentations to the Regina Technology Community 26 Apr 2011! Part I - Database Design for Developers This interactive session is for software developers tasked with database development. Attend and learn about...(read more)

T-SQL Tuesday: Aggregations in SSIS

andyleonard — Tue, 08 Mar 2011 19:00:00 GMT

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...(read more)

Presenting at Roanoke Code Camp Saturday!

andyleonard — Mon, 07 Mar 2011 17:00:00 GMT

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...(read more)

A Day of SSIS in May

andyleonard — Mon, 01 Nov 2010 15:00:00 GMT

Introduction I could run through the abstract for my submission to the SQLRally pre-con - and I will include much of it in this post. But Wait There's More! It's difficult to convey in writing my passion for SQL Server Integration Services. I like the...(read more)