August 4, 2008 at 3:50 am
Hi All,
We are decided to install a tool for T-SQL - code review.
Please anybody suggest me the list of tools and related link details.
Thanks in advance.
December 3, 2009 at 11:27 pm
Even i am looking for one . Can you any one help us for the same.
December 4, 2009 at 2:25 am
What do you mean 'code reveiw'? A Tool cant tell you if your code will do what you want, it doesnt understand your business or its needs.
The best any tool can do is help you optimize your queries. In which case you may as well start with Query optimisation wizard (comes packed into ssms).
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 4, 2009 at 3:27 am
Hi Adam Zacks,
Essentially a Code review tool would review all the given code as per the standards specified .
Example : For reviewing a C# code we can use FxCops .
so we are looking for simillar kind of tool in sqlserver 2005 or 2008 where we can implemeent the tool for code review .
Regards,
Jaipal
December 4, 2009 at 3:32 am
In that case, sorry no. I dont know of any.
SQL2008 (and 2005 in a limited fashion) have the security policys that can goven thing like naming conventions etc, but that is to protect/enforce security on a prod systesm (which isnt what you want).
Let us know what you find.
Adam Zacks-------------------------------------------Be Nice, Or Leave
January 24, 2012 at 11:06 am
DIAB from DIABSQLSoftware.com just released in ver 3.5 a SQL code analysis tool it checks for missing indexes, code best practices, table scans, clustered index scans, mismatched joins, and code that could alter security. Works with multiple objects in the same script also.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply