Home Forums SQLServerCentral.com Editorials Where Do You Go for Authoritative SQL Server Best Practices? RE: Where Do You Go for Authoritative SQL Server Best Practices?

  • July 8, 2011 at 7:54 am

    #1350362

    John Neville (7/8/2011)

    Suppose the bosses are screaming and jobs are on the line (or your reputation as a miracle-worker is being questioned) - do you test less thoroughly if you get a suggestion from a more reliable source than from an un-trusted source? Would a quick once-over on Developer edition on your laptop provide enough comfort to convice you to deploy to a live production server *IF* the advice came from BoL or an MVP?

    BOL has its flaws and so does MVP code. Not all MVP's are created equal.

    Let's turn the question around... are you willing to stake your reputation as a miracle-worker on code that you haven't tested or have only done cursory checks on? I'm not.

    A major key to success is to be able to quickly build enough of the right kind of test data to test just about everything in a very quick manner.

    As a side bar, if the bosses are screaming, then they're probably the ones that came up with an over-aggresive schedule and they need to be reigned in. They need to understand that it's THEIR jobs that are "on the line", as well.

    --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.

    Change is inevitable... Change for the better is not.

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