When opening database object (e.g. View, Proc...) from the tool, please change "CREATE " TO "ALTER " as we always want to alter it.
When opening database object (e.g. View, Proc...) from the tool, please change "CREATE " TO "ALTER " as we always want to alter it.1 vote
Export all results to csv file or txt file.2 votes
I would love to see support for SQL Server Data Tools (SSDT) Database Projects so that developers can check and correct while building locally either through triggering a local build and perhaps also manually through the menu.
I'm thinking about functionality like the StyleCop extension in visual studio for example.3 votes
Can you please provide us a plugin to integrate SQL Code Guard and Sonarqube for static code analysis.
There is a plugin in the market (http://www.techcognia.com/TSQL.aspx), but we faced some challenges. So it would be great if it could come perfectly tested and approved via RedGate.3 votes
1. Tables missing Primary Keys.
2. Tables missing Primary Index.
3. Naming conventions standards like
a. SP to being with usp_.
b. Function to begin with fn_.
c. All reserved Keywords to be uppercased.
d. Index names.
4. Procedure, function or Trigger without SET NOCOUNT ON.1 vote
Make sure BULK INSERT statements always have the MAXERRORS = 0 option set; the default being 10 errors which we obviously don’t want!1 vote
Make sure cursor runs over a temporary table/table-valued variable only and not a normal table; primarily to prevent schema-stability locks that in turn block partition operations.1 vote
I would like the option to run the tests via something like Pester, and have the option to run a sub set of test when needed.1 vote
I would like it so that the rules in code guard can be called by Sonarqube so we can analyse our app code as well as our database code.4 votes
I would like to use SQL Code Guard on SQL Server Management Studio v17.7 votes
- Don't see your idea?