Best Practice Analyzer for SQL Server 2005? RRS feed

  • Question

  • Hi everyone,

    a long time I was using a nice tool called "Best Practice Analyzer Tool for SQL Server 2000". I would be interested whether this product is or will be available for SQL Server 2005.

    Does anyone knows something about it?



    Monday, July 10, 2006 3:03 PM


All replies

  • indeed that a nice tool.

    for security best though you can also make use

    of MBSA or MS baseline analyzer whichh supports sql server 2005


    Monday, July 10, 2006 3:54 PM
  • Hi,

    no I was using the Best Practice Analyzer to check on certain SQL programming "styles" not for security reasons. I.e. I know very well how to optimize my procedures or which statement I should use and which statement I should avoid but it is difficult to make sure that these bpa rules has been respected over the whole database.

    Trivial example:

    Avoid using SET NOCOUNT OFF ... it might be set to ON in most procedures but there might still be some procedures where it is set to OFF or set by default.

    So what I really need is a tool which checks on bpa rules and tells me if there is a violation or not.



    Monday, July 10, 2006 4:05 PM
  • i see..

    i check mbsa.

    sql 2k5 is not supported either.

    lets wait....

    Monday, July 10, 2006 4:17 PM
  • Hi,

    Microsoft is currently working on a BPA for SQL Server 2005.
    There is no release date known (at least not public).

    Just a little patience ;-)


    Monday, July 10, 2006 7:03 PM
  • That is correct, we have not released a hard date.  We are aiming for second half of 2006.  For more information you can visit my team's blog... http://blogs.msdn.com/sqlrem/.

    Let me know if you have any questions.

    Paul A. Mestemaker II
    Program Manager
    Microsoft SQL Server

    Tuesday, July 11, 2006 9:01 PM
  • Friday, May 25, 2007 5:04 PM