SQL Enligth 1.9.6.798
What’s updated in this release: Added 19 new analysis rules Improvements in analysis performance Improvements MSBuild and NAnt tasks Fixes of issues found in previous release
Entries by admin
SQL Enlight 1.9.5.771
What includes this update: Optimizations of the analysis feature Fixes and improvements
CR0003: Non-ISO standard comparison operator found
Message Non-ISO standard comparison operator found Description It is advisable to use ISO standard comparison operators instead of non-ISO standard operators to help ensure optimal cross-platform and future version compatibility. Not equal to: Use <> instead of != Greater than or equal to: Use >= instead of !< Less than or equal to: Use <= […]
SQL Enlight 1.9.5.768
Here is what’s changed in this update: Performance optimizations of the analysis feature Fix for LinqBridge.dll validation error
SQL Enlight 1.9.5.764
We are happy to announce that the next update of SQL Enlight is already here. Here is a summary of what’s new in version 1.9.5.764: Support for SQL Server 2014 – T-SQL syntax enhancements and new schema features Support for analyzing SQL Azure databases The Command line tool, NAnt and MSBuild tasks can now accept […]
SQL Enlight 1.9.4.756
Fixes of issues found in version 1.9.4.752
SQL Enlight 1.9.4.751
What’s new in this update: Support for SQL Server Management Studio 2014 integration 64-bit architecture native support Improvements of the command line tool and MSBuild and NAnt tasks
Create Static Analysis Rule with SQL Enlight
The step by step guide for creating custom analysis rules with SQL Enlight is available as a .pdf document here. If you have any questions, please contact us at our support email or use our feedback form.
CR0002: Avoid altering security within stored procedures
Message Avoid altering security within stored procedures Description The rule checks and alerts for usage of GRANT, REVOKE, or DENY statements within the body of a stored procedure. Avoid altering security within stored procedures, functions, and triggers. This can lead to unnecessary database calls, or it can hinder troubleshooting security permissions. Author Jeff Foushee Example […]
CR0001: TOP (100) PERCENT
Message TOP (100) PERCENT found Description This rule checks for the phrase “TOP (100) PERCENT”. This phrase has no bearing unless the percentage is less than 100. This phrase is commonly generated by creating a view in the SQL Server View Designer. Author Jeff Foushee Example SELECT TOP 100 PERCENT LastName, FirstName, JobTitle, Department FROM HumanResources.vEmployeeDepartment ORDER BY LastName ASC