• To be honest, I don't want or need much either as a DBA or and SQL Server Developer. I've learned to use the basic tools to get along just fine. Part of that was by necessity when working as a consultant. Lot's of places just don't have all the nifty little or great big tools either due to budget or because they don't want to support them or because of "security issues". It'll be difficult for many to accept but PowerShell, SSIS, SSRS, SSAS, SSSB, Internet access, and a shedload of other tools all seem to fall into one or the other of those categories in many of the companies I've done work for. I've also worked for places where I can't even use a thumb drive due to security restrictions. I'd have been dead in the water if I relied on tools other than the basic tools that come with the product.

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