Post reply

Best Practices Analyzer Tool for Microsoft SQL Ser

  • November 25, 2003 at 4:29 am

    #160981

    Has anyone seen / used "Best Practices Analyzer Tool for Microsoft SQL Server" ?

    It is free download (BETA) from microsoft.


    -- Amit


    "There is no 'patch' for stupidity."


    Download the Updated SQL Server 2005 Books Online.

  • November 25, 2003 at 7:04 am

    #483531

    Will try that out on a test system right away .The other tools from microsoft in the likes of killpwd.exe and storepro.exe have done a great job for me

    Thanks

    Mike

  • November 26, 2003 at 5:50 am

    #483705

    I have run this on both development and production databases, and allowed it check all of the available 'best practices'. It was good to see the db's passed on many counts, and some of the failures, such as having all table names prefixed or suffixed with 'tbl' were practices I had not followed out of choice. But on the whole, it could be a useful tool to add to ones list.

    Tony Bater


    Tony

  • December 2, 2003 at 5:46 am

    #484252

    Tried it out and it worked fine.

    Just chose a test database to install the repository on

    Thanks

    Mike

  • December 2, 2003 at 5:59 am

    #484259

    Interesting tool. Tried in on two servers so far but some of it's best practices were server settings that MS could have had as default for install.

Viewing 5 posts - 1 through 4 (of 4 total)

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