THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server MVP Deep Dives. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!

  • SSIS Snack: Name Those Connections!

    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 calls to the SQL Server instance. As shown below, sp_who2 is one way to obtain a peek into the inner workings of SQL Server. Note the column labeled “Program Name” displays the value we configured into the Application Name property of the SSIS Connection Manager. This gives the DBA a fighting chance at isolating SSIS packages from other applications and jobs executing.

     

    I use the following format:

    [SSIS].<Package Name>.<Connection Manage Name>

    The format you choose isn’t all that important. Being consistent is very important.

    Happy Integrating!

    :{>

  • SSIS Package Configurations MicroTraining Recording Available!

    Although there are some audio issues, the recording and code for the Linchpin People microTraining session on SSIS Package Configurations is now live!

    :{>

  • To Snark or Not to Snark…

    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 people up while others tear them down. I understand motivational theories that support “inspiring” people by offending them (you know, so they’ll remember). But many popular and seemingly intuitive management practices simply don’t work – as evidenced in the book Drive by Daniel Pink. While short-term gains are possible, this sort of motivation poisons long-term productivity. That’s not the worst of it. Cleverness – or rather, feeling that one is being clever – is addictive. Some get a thrill out of combining (real or imagined) advantage and snarkiness to achieve a “zinger”.

    What Is The Problem I Am Trying To Solve?

    The thrill and associated endorphins are understandably pleasant… for the one being snarky.

    "As a matter of cosmic history, it has always been easier to destroy, than to create."
    -Spock to McCoy, from Star Trek II: The Wrath of Khan

    This holds in communications, as well. It is much easier to destroy than create. I am going to take that statement one step further: It is lazier to destroy than create.  Inspiring people while not tearing them down is hard. It is way harder than simply throwing some snarky comment in their general direction. It involves something that cannot be manufactured: your engagement. Sure we can multitask, but can we multi-engage?

    No.

    Engagement is a singleton.

    Engagement requires attention. Web marketing people will tell you web advertisements are after our attention. Our attention can be defined many ways. I define it as “the second glance”. If a web marketer or a spammer produces something that draws our eye back to it, they have our attention.

    Snarky

    Snarkiness will get my attention long enough to accomplish your short-term goal, but it does so at the expense of the long-term. If you are snarky to me, I want to listen to you less in the future. You made your point (congratulations), but you did so at the expense of all future points you wish to make with me.

    Is that a win for you?

    (Seriously?)

    What does that bode for community? How does that fit into the marketing model of the long tail? Putting it into farming terms: Snarkiness is equivalent to eating seeds stored for planting. You are eating today, but you will starve in the future without seeds to plant – which will produce more edible (and planting) seeds.

    The Solution

    Don’t be snarky. Wil Wheaton (blog | @wilw) puts is succinctly in what has become known as Wheaton’s Law.

    Conclusion

    Snarkiness may be fun, but it is expensive fun – and the snark foots the bill in terms of influence and reputation. Is it worth it?

    Andy

  • SSIS MicroTraining: SSIS Package Configurations

    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!

    :{>

  • OT: Noisy v. Important

    A new personal blog post: Discerning Between Noisy and Important
  • Presenting at MADPass Wednesday 25 Jan 2012!

    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.

    :{>

  • SSIS MicroTraining Recordings Available!

    I delivered a couple online SSIS microTraining sessions recently, and recorded them! You can view them here:

    SSIS Precedence Constraints

    SSIS Frameworks Magic

    Enjoy!

    :{> 

  • OT: Protesting SOPA

    I am protesting SOPA by taking andyleonard.me offline for a day.
  • Presenting A Day of SSIS–SQL Saturday 111 (Atlanta) Precon–13 Apr 2012

    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 area in mid-April, check out SQL Saturday 111!

    :{>

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

    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!

    :{>

  • SQLPeople News and SQLPeople Wants You!

    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 Gate, and Confio; without whom the event would not have been possible. We had a stellar event planning team that worked diligently for several months to organize the event. Kudos to Matt Velic (Blog | @mvelic |SQLPeople), Robert Pearl (Blog | @PearlKnows | SQLPeople), Michael Coles (Blog | @Sergeant_SQL | SQLPeople), Melissa Demsak (@SQLDiva), and Brian Moran (Blog | @briancmoran).

    The format of the event was single-day, single-track. Each presenter spoke for about 20 minutes. This was followed by an interview and questions from the assembled. The mission was to inspire, not necessarily educate. Granted, education occurs during inspirational presentations; inspiration is the primary goal. We invited awesome speakers to share what motivates them. We asked them, “What fires you up? Why do you do what you do?” Their answers were truly inspiring – ask anyone who attended. Or…

    Watch the Presentations!

    Our friends at AndNow Media did an outstanding job capturing the event for us. The edits are complete and videos have been posted (thanks Matt!). You can view them here. Over the next few weeks, I will feature each presentation, sharing my thoughts and impressions.

    Kudos!

    I cannot say enough to thank our presenters, sponsors, and planning team. Our presenters were:

    Yall rock!

    :{>

  • What Matters Most

    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 have been high highs and low lows.

    Examples? Wow, there are many. Some subtle, some not. In roughly chronological order:

    Do these things matter? Sure. But do they matter most? Not by a long shot. Here are some examples of things that happened in 2011 that matter most:

    • Celebrating another year married to Christy
    • The birth of my latest grandchild, Gabriel
    • Stevie Ray’s appendectomy
    • Riley starting school
    • Meeting with fellow believers at the PASS Summit for PASS Prayers
    • Meeting regularly with a small group of committed Christians to study the Bible
    • Participating in SQL Server  MVP Deep Dives, Volume 2
    • Starting Linchpin People with my friend and brother, Brian Moran

    Can you spot the difference? What matters most involves people. Most of these events were incredibly positive – awesome, in fact. Some were and are great but are continuing to mature. I still cannot bring myself to think for long about Stevie’s appendectomy; the harsh realities of that situation still chill my soul.

    High highs and low lows.

    As the year has progressed, I have become more and more aware of how truly blessed I am. I deserve none of it, and yet much is given to me. A bunch of it comes my way as a winner of the Birth-Nation Lottery. We have so much in America. As I read recently on a friend’s blog, many of America’s poor post on Facebook or Twitter about their needs and concerns from their iPhones. Destitution exists in America, but this isn’t it.  This isn’t the poverty others experienced as children. The fact that most of America’s poor are among the richest in the world is a thing of mixed emotions. I hurt to see anyone in poverty – in America or elsewhere – and this pain is motivating.

    Motivating For What?

    I believe I can do better and more to help. The faith I share with millions compels me to do more. So I am doing and will do more. My watchword for 2012 is “intentional”. Plans are already underway to intentionally work to reduce the poverty of those in the United States, Europe, and elsewhere. I don’t know how many of these actions will make it to the annals of this blog. I am certain some of these activities will appear here, though they will likely not be advertised in the category of “reducing poverty”. I will have no such category on this blog. Or any blog.

    I have endeavored my entire career to give back. This will continue, though with a bit more focus, planning, and (yes) intent.

    I am truly blessed to have a business partner who shares faith, philosophy, and a desire to implement positive change in the workplace. Brian has taught me much technically, but he has taught me much more about endurance and faith. I am honored to work with him. We are endeavoring to create a different kind of business; one that enables what Tom Nelson calls “human flourishing” in Work Matters. That sounds lofty, mostly because it is. The Linchpin People website went live earlier this month even though we’ve been in business since April. We are architecting Linchpin People to be different, and different takes time. We are building a culture by defining a philosophy. Beyond that, we are cognizant of the movements around us. We are leveraging them at a minimum; we may be starting a movement – time will tell. I would love to share an optimistic story with you, but the starkness of our beliefs compel us to face the reality: this may succeed or this may fail. Only time will tell.

    That’s not all. But that’s all I want to share here and now.

    Be Intentional

    I want to encourage anyone so inclined to be intentional in 2012. I lack the words to adequately express how it feels to know something you did made a difference in someone’s life. Suffice it to say it is unlike any other positive feeling  I have experienced.

    Help someone less fortunate. Be there for people who need you. This isn’t always as straightforward as it sounds, as sometimes tough love is what they need most.

    We are a community of brilliant problem-solvers. Can you imagine what we can accomplish if we simply put our minds and hearts and hands to it? Just think of the things we can do; things for people; things that matter most.

    Andy

  • MicroTraining Updates: SSIS Frameworks Redux and Mailing List

    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.

    :{>

  • SSIS MicroTraining - SSIS Frameworks Magic

    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!

    :{>

  • PASS Elections 2011 Update: Board Voting Closes Tomorrow!

    Introduction

    I am following the PASS Board Elections 2011 process, blogging about the people and events. You can find a list of all my posts on the topic here.

    Board Elections Update

    According to the schedule, Board elections remain open until tomorrow, 20 Dec 2011. Election results are scheduled to be announced 28 Dec 2011. Check out the PASS Elections 2011 portal for more information.

    :{>

More Posts Next page »

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement