Why Tools Can Help You Do Your Job

  • Kathi Kellenberger

    SSC Enthusiast

    Points: 194

    Comments posted to this topic are about the item Why Tools Can Help You Do Your Job

  • Jeff Moden

    SSC Guru

    Points: 994289

    I have mixed reactions when it come to 3rd party tools.  They're a great thing to have but I find they make people a fair bit lazy about learning unless they wrote their own.

    An excellent example of this is Ola Hallengren's wonderful tools.  His site documents what the parameters are along with what they do and he provides the code in a fully open source manner with labels for the sections of the code and, yet, we still have people asking about how to use the code or what an error reading might mean on this site.

    To be a bit more metaphoric, you might not need to know how the drive train of your car works but you should know that running in 1st gear all the time is going to be a problem and, yes, you really need to learn how to change a tire.

    Of course, how they use it, especially for index maintenance is even more ignorant.

    And, while we're on that subject, "Index Maintenance" should NEVER be referred to as "Index Optimization".  The two terms have little to do with each other and even Ola makes that mistake in his documentation.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • williamjoseph.lpa

    Newbie

    Points: 6

    Tools makes our job easy. They saves lot of our time and energy.

  • Kathi Kellenberger

    SSC Enthusiast

    Points: 194

    If you don't use the tools correctly, then there is probably not much chance you are working correctly without them either, I guess.

  • Jeff Moden

    SSC Guru

    Points: 994289

    Kathi Kellenberger wrote:

    If you don't use the tools correctly, then there is probably not much chance you are working correctly without them either, I guess.

    The problem is that a whole lot of people don't know enough to know if they're using the tools correctly (especially when the entire world is sometimes in the same rut and the heavy hitters of the SQL community continue to recommend that the rut is the right way 😉 and that's NOT a reference to your or your good article, Kathi) or even if the tool is working correctly. 😀

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715107

    Tools are essential. Everyone uses them, whether they write one, download one, or buy one. These make a huge difference. Learning to use them properly is important, and unlike the hammer-hitting-my-finger in the real world, in the virtual one, people get by without knowing much for longer periods of time.

    That being said, the build v buy debate is hard to win, even with yourself. I constantly find myself going one way or the other.

  • This was removed by the editor as SPAM

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply