Andy Leonard

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

2012-02-13T08:00:00Z

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 Webb ( Blog ), Gavin Payne ( Blog ), and Christian Bolton ( Blog ). I hope to see you there! :{>...(read more)

SSIS Snack: Name Those Connections!

2012-02-09T12:00:00Z

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 a more concise identifier like the one shown here: “Why should I enter this information, Andy?” I’m glad you asked! When troubleshooting performance or locking / blocking issues, DBAs start with a query to ascertain what is currently executing...(read more)

SSIS Package Configurations MicroTraining Recording Available!

2012-02-08T12:00:00Z

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…

2012-02-06T12:00:00Z

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 and reading the works of humorous writers. Life is too short to waste on misery and a hearty laugh is good for the soul. Some humor is educational, thought-provoking and surprising. Some humor, though, can be hurtful. Some jokes and comments build...(read more)

SSIS MicroTraining: SSIS Package Configurations

2012-02-01T12:00:00Z

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 here ! :{>...(read more)

OT: Noisy v. Important

2012-01-25T12:00:00Z

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

Presenting at MADPass Wednesday 25 Jan 2012!

2012-01-22T19:00:00Z

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! I’m the fat guy with a fu. :{>...(read more)

SSIS MicroTraining Recordings Available!

2012-01-19T12:00:00Z

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

2012-01-18T02:29:00Z

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

2012-01-12T12:00:00Z

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 Adam Machanic are also delivering precons that day: Jessica’s is Learn SSRS in a Day and Adam’s, No More Guessing! An Enlightened Approach to Performance Troubleshooting . Adam and Jessica are awesome presenters! If you’re going to be in the Atlanta...(read more)

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

2012-01-09T17:29:00Z

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 Flow. The price for flexibility? Complexity. Join me as I present options and patterns for using Precedence Constraints! :{>...(read more)

SQLPeople News and SQLPeople Wants You!

2012-01-09T12:00:00Z

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 group (technical people only, please). Why sign up? So you can keep up with all the cool SQLPeople happenings, or course! SQLInspire NYC 2011 was held 12 Nov 2011 at Microsoft in New York City. The event was graciously sponsored by Embarcadero , Red...(read more)

What Matters Most

2011-12-25T12:00:00Z

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 over the year: the accomplishments of ourselves and others; goals set and met; goals not met; gain; losses; and the inevitable change that happens to us all every year. It’s likely this year has been a mixed bag for you as it has been for me. There...(read more)

MicroTraining Updates: SSIS Frameworks Redux and Mailing List

2011-12-21T16:00:00Z

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 and audio this time. We shall see… You can register for the next event here . If you are interested in receiving updates about future microTraining events, please join the mailing list . :{>...(read more)

SSIS MicroTraining - SSIS Frameworks Magic

2011-12-20T12:00:00Z

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)