Best Practice Analyzer for SQL Server 2005?

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?

Regards,

StSt

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

http://www.microsoft.com/technet/security/tools/mbsa2/default.mspx

|||

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.

Regards,

StSt

|||

i see..

i check mbsa.

sql 2k5 is not supported either.

lets wait....

|||

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

Regards

|||

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
http://blogs.msdn.com/sqlrem/

|||

Here is the download link for SQL Server 2005 BPA February CTP

http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en