Tool for Code review

Question

Post reply

Tool for Code review

Sudarsan Srinivasan

Ten Centuries

Points: 1140
More actions
March 6, 2008 at 6:21 am

#154177

Hi All,
Can anybody suggest me any tool which can be used to automate the code review for SQL 2000 apart from MICROSOFT's SQL BPA
Thanks in advance

Viewing 9 posts - 1 through 8 (of 8 total)

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

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 1

Heh... I can tell you which one is the only one that works 100% of the time...

http://blog.pengoworks.com/index.cfm/2008/2/15/The-only-valid-measurement-of-code-quality-WTFsminute

:hehe::P:D:);)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

A competant DBA. Even the Best Practices anaylser isn't foolproof

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 3

Jeff Moden (3/6/2008)
Heh... I can tell you which one is the only one that works 100% of the time...
http://blog.pengoworks.com/index.cfm/2008/2/15/The-only-valid-measurement-of-code-quality-WTFsminute
:hehe::P:D:);)

Wow, this is amazing. And now I know the name for this method:)

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Sudarsan Srinivasan Ten Centuries Points: 1140 More actions · Answer 4

Its because, we follow our own coding standards and we want that to be customized in a tool. The BPA covers most of the aspects but we would want to implement few other checks also. I dont think the BPA tools allows user customization/add new rules.

Adam Bean One Orange Chip Points: 26631 More actions · Answer 5

Jeff Moden (3/6/2008)
Heh... I can tell you which one is the only one that works 100% of the time...
http://blog.pengoworks.com/index.cfm/2008/2/15/The-only-valid-measurement-of-code-quality-WTFsminute
:hehe::P:D:);)

That was awesome ...

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 6

Jeff -

Today, one of my colleagues mentioned to me that this very metric was repackaged and turned into a Code review package.... I thought you might enjoy it....:)

http://www.crap4j.org/[/url]

Sadly - it's apparently only in production for Java so far...

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 7

Heh... as always, thank you for your contribution to the pile of email I get. As you can tell, the SQL/_wt^f metric is still pretty much in the design phases. We actually found 34 sub meanings to the metric nearly as universally accepted as the ultimate word, "Dude". We also found the we can blend the Java Metric, the SQL Metric, along with the word "Dude" and came up with approximately 34³ totally unique meanings. The paper work on the Java Metric does appear to be a bit of a stinker, though we may have a digital break through any minute.

I'm actually flushed with excitment because it may lend new meaning to the words, "It Depends".

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

russ.guier Old Hand Points: 313 More actions · Answer 8

Try this link http://www.DIABSQLSoftware.com also at http://download.cnet.com/DIAB/3000-2065_4-75363232.html take a look at DIAB. Version 3.5 includes such a tool. Looks pretty promising.