Andy Leonard

From Zero To SSIS! London, 5-9 Mar 2012

andyleonard — Mon, 13 Feb 2012 08:00:00 GMT

I can hardly believe I will be delivering From Zero To SSIS! in London, England 5-9 Mar 2012 – in less than a month! This course is delivered in cooperation with my friends at TechniTrain who provide awesome training by talented technologists like Chris...(read more)

SSIS Snack: Name Those Connections!

andyleonard — Thu, 09 Feb 2012 12:00:00 GMT

When creating Connection Managers in SSIS, take a moment to click the “All” page and set a value in the Application Name property. In SSIS 2008+, a default value is applied to this property. It’s useful but it contains a GUID. Yuck. I prefer to enter...(read more)

SSIS Package Configurations MicroTraining Recording Available!

andyleonard — Wed, 08 Feb 2012 12:00:00 GMT

Although there are some audio issues, the recording and code for the Linchpin People microTraining session on SSIS Package Configurations is now live! :{>...(read more)

To Snark or Not to Snark…

andyleonard — Mon, 06 Feb 2012 12:00:00 GMT

Introduction This post is the fifty-first part of a ramble-rant about the software business. The current posts in this series can be found on the series landing page . This post is about communication. On Being Clever I enjoy listening to a good comedian...(read more)

SSIS MicroTraining: SSIS Package Configurations

andyleonard — Wed, 01 Feb 2012 12:00:00 GMT

I will be delivering another free, online MicroTraining on SSIS Package Configurations Tuesday, 7 Feb 2012, at 10:00 AM EST. Join Andy Leonard as he demonstrates uses of SSIS Package Configurations for externalizing SSIS package variable values. Register...(read more)

OT: Noisy v. Important

andyleonard — Wed, 25 Jan 2012 12:00:00 GMT

A new personal blog post: Discerning Between Noisy and Important...(read more)

Presenting at MADPass Wednesday 25 Jan 2012!

andyleonard — Sun, 22 Jan 2012 19:00:00 GMT

I am honored to present Building Your First SSIS 2012 Package to the Madison Professional Association for SQL Server (MADPass) Wednesday, 25 Jan 2012! If you read this blog and will be in the Madison, Wisconsin area Wednesday, stop by and introduce yourself!...(read more)

SSIS MicroTraining Recordings Available!

andyleonard — Thu, 19 Jan 2012 12:00:00 GMT

I delivered a couple online SSIS microTraining sessions recently, and recorded them! You can view them here: SSIS Precedence Constraints SSIS Frameworks Magic Enjoy! :{>...(read more)

OT: Protesting SOPA

andyleonard — Wed, 18 Jan 2012 02:29:00 GMT

I am protesting SOPA by taking andyleonard.me offline for a day....(read more)

Presenting A Day of SSIS–SQL Saturday 111 (Atlanta) Precon–13 Apr 2012

andyleonard — Thu, 12 Jan 2012 12:00:00 GMT

I am honored to be presenting A Day of SSIS Friday, 13 Apr 2012 – a precon for SQL Saturday 111 in Atlanta. There is early-bird pricing in effect until the Ides of March . You can register and view details of the course topics here . Jessica Moss and...(read more)

microTraining: SSIS Precedence Constraints - Wednesday, 11 Jan 2012!

andyleonard — Mon, 09 Jan 2012 17:29:00 GMT

Join me for a microTraining session on SSIS Precedence Constraints ! When? Wednesday, 11 Jan 2012, 10:00 AM EST Where? Please register here ! What? SQL Server Integration Services Precedence Constraints provide many ways to control work-flow in the Control...(read more)

SQLPeople News and SQLPeople Wants You!

andyleonard — Mon, 09 Jan 2012 12:00:00 GMT

It’s true! Everyone has a story, and SQLPeople is one place to share yours. “How, Andy?” I’m glad you asked. Browse on over to our Become a SQLPerson page and answer the questions. You can also follow us on Facebook and Twitter , and join our LinkedIn...(read more)

What Matters Most

andyleonard — Sun, 25 Dec 2011 12:00:00 GMT

The end of the year is a study in extremes. For many, it is a time of merriment and celebration. For some, it is yet another day to survive. I believe most people reflect on the past year as it draws to a close. We think about the things that happened...(read more)

MicroTraining Updates: SSIS Frameworks Redux and Mailing List

andyleonard — Wed, 21 Dec 2011 16:00:00 GMT

I am still learning. I attempted to capture my SSIS Frameworks Magic presentation yesterday. I partially succeeded with video and no audio, durnit! I am going to deliver the presentation again Tuesday, 27 Dec 2011 at 10:00 AM ET. I hope to capture video...(read more)

SSIS MicroTraining - SSIS Frameworks Magic

andyleonard — Tue, 20 Dec 2011 12:00:00 GMT

Register / Join me today at 10:00 AM EST! Just in time for Christmas, I break out some magic! This session focuses on the benefits and underlying code of an SSIS Framework. This is part of my Four Weeks of SSIS MicroTraining . I hope to see you there!...(read more)