October 6, 2010 at 6:55 am
hi,
Is there any tool such as sql enlight is available from microsoft for code review and following the coding standards?
October 6, 2010 at 7:51 am
I don't know of anything from MS, but my employer, Red Gate, offers SQL Refactor, which can enforce some standards.
If you want some basic naming, Policy Based Management can do some.
October 6, 2010 at 9:17 am
Visual Studio Team System has a set of validations that can be run against your SQL code. They came out of what used to be the 2000 Best Practices Analyzer. They pulled the TSQL stuff from there when it got updated to 2005.
Idera has a new product coming out called SQL Doctor that's probably worth looking at too.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 24, 2012 at 11:21 am
Try DIAB from DBAinABox.com. They just released ver 3.5 with there SQL monitoring package and includes a SQL code analysis tool. If find performance issues and security problems as well as doing best practices against the code.
January 24, 2012 at 11:30 am
This thread is stale to the tune of 18 months
January 24, 2012 at 11:42 am
My apologies, I didn't see the date. But the question had no direct answer until now.
January 24, 2012 at 1:51 pm
Really? I thought saying Visual Studio and the compliance checks was a direct answer...
Anyway, SQL Cop is also worth a look. I wrote a review of it here[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 25, 2012 at 11:54 am
To the Scary DBA I read your review of SQL Cop and it looks like an excellent tool The piece I like about DIAB "And I have been a DBA for many years" it that at my company I have to proof all code that is applied to the server we have around 30 SQL Server from 2000 --> 2008. and I have to look at huge chunks of code where object are mixed into the script. DIAB not only reads the entire script in one sweep but it executes query plans internally on all the selects and hilites table and clustered index scans. it also hilites potential SOX compliance issues like grant statements. It performs a best practice review like mismatched columns (var = numeric) and identifies relations with missing indexes. It's not perfect but I would call it a 90% solution.
January 25, 2012 at 12:30 pm
russ.guier (1/25/2012)
To the Scary DBA I read your review of SQL Cop and it looks like an excellent tool The piece I like about DIAB "And I have been a DBA for many years" it that at my company I have to proof all code that is applied to the server we have around 30 SQL Server from 2000 --> 2008. and I have to look at huge chunks of code where object are mixed into the script. DIAB not only reads the entire script in one sweep but it executes query plans internally on all the selects and hilites table and clustered index scans. it also hilites potential SOX compliance issues like grant statements. It performs a best practice review like mismatched columns (var = numeric) and identifies relations with missing indexes. It's not perfect but I would call it a 90% solution.
I have to apologize for my abruptness but since ALL of your posts relate to said tool I suspected you were plugging it.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply