Happy New Year!
Today we are delighted to announce the release of SQL Enlight version 1.9.9.913.
What’s new and exciting in this new version:
- 60 new analysis rules
- Fixes and improvements in standard analysis rules
- Fixes of user reported issues
We are pleased to announce the release of SQL Enlight version 1.9.8.907.
Changes in this version:
- Fix of a problem with Visual Studio 2017 integration
- Fixed the Code Analysis TFS Checkin Policy integration with Visual Studio 2017
- New exclude/include files options for the Code Analysis TFS Checkin Policy
- Fixed some issues with high DPI support
- Enabled inheritance of the analysis template
- General fixes and improvements
- Fixes and improvements in standard analysis rules
- Fixes of user reported issues
We are delighted to announce today’s release of SQL Enlight version 1.9.8.893.
The enhancements in this release are:
- Support for sharing settings between teams with Team Settings
- A set of 31 new analysis rules
- Fix of the Code Analysis TFS Checkin Policy
- Fix of installer and another problem with SSMS 17 integration
- General fixes and improvements
- Fixes and improvements in standard analysis rules
- Fixes of user reported issues
This is a list of the newly added rules:
- SA0169 : Use @@ROWCOUNT only after SELECT, INSERT, UPDATE, DELETE or MERGE statements
- SA0170 : It is recommend to not use CTE unless it is need for Hierarchical data
- SA0171 : The ROW_NUMBER paging pattern can be replaced with OFFSET FETCH clause
- SA0172 : The dynamic SQL is constructed using external parameters, which is not ensured to be safe
- SA0173 : COALESCE, IIF, and CASE input expressions containing sub-queries will be evaluated multiple times
- SA0174 : The CASE expressions should not rely on short-circuit behavior with aggregate functions or full text search predicates
- SA0175 : Extract input expression as a variable in order to ensure it is invariant and avoid unexpected results
- SA0176 : Consider merging nested IF statements to improve readability
- SA0177 : To improve code readability, put only one statement per line
- SA0178 : LIKE operator is used without wildcards
- SA0179 : Do not create function and procedures with too many parameters
- SA0180 : CASE expression has too many WHEN clauses
- SA0181 : The query joins too many table sources
- SA0182 : The CASE expressions is missing ELSE clause
- SA0183 : The commented out code reduces readability and should be deleted
- SA0184 : Redundant pairs of parentheses can be removed
- SA0185 : Review the call for unintentionally passing the same value more than once as an argument
- SA0186 : Possible missing BEGIN..END block
- SA0187 : Duplicated string literals complicate the refactoring
- SA0188 : The NULL or NOT NULL constraint not explicitly specified in the table column definition
- SA0189 : Store procedure executed without getting a result
- SA0190 : Numbered stored procedures are deprecated
- SA0191 : Procedure body is not enclosed in BEGIN…END block
- SA0192 : Procedure returns more than one result set
- SA0193 : Avoid unused labels to improve readability
- SA0194 : The ELSE clause is not needed.If it is omitted the CASE expression will still return NULL as default value
- SA0195 : Duplicate statistics must be removed
- SA0196 : Deprecated use of DROP INDEX with two-part index name syntax
- SA0197 : The deprecated FASTFIRSTROW hint was encountered
- SA0198 : Usage of deprecated GROUP BY ALL syntax encountered
- SA0199 : Usage of deprecated COMPUTE clause encountered
We are happy to announce the release of SQL Enlight – 1.9.8.877.
The enhancements in this release are:
- SQL Server 2017 RTM support
- Added 14 new analysis rules
- Fixed installer issue related with SQL Server Management Studio 17 integration
- Fixed installer issue related with with Visual Studio 2017 integration
- Improvements in standard analysis rules
These are the newly added rules:
- SA0066B : Check all Columns for following specified naming convention.(Batch)
- SA0067B : Check all Unique Key Constraints in the current database for following specified naming convention.(Batch)
- SA0068B : Check all Check Constraints in the current sql script for following specified naming convention.(Batch)
- SA0069B : Check all Default Constraints in the current script for following specified naming convention.(Batch)
- SA0070B : Check all Primary Key Constraints in the current sql script for following specified naming convention.(Batch)
- SA0071B : Check all Foreign Key Constraints for following specified naming convention.(Batch)
- SA0072B : Check all Non-Key Index for following specified naming convention. (Batch)
- SA0073B : Check all User-Defined Types for following specified naming convention. (Batch)
- SA0074B : Check all Schema-s for following specified naming convention. (Batch)
- SA0075B : Avoid adding constraints with default system generated name
- SA0165 : TOP (100) PERCENT found
- SA0166 : Avoid altering security within stored procedures
- SA0167 : Non-ISO standard comparison operator found
- SA0168 : Possible division by zero not handled according the practice
We are happy to announce the release of the latest version of SQL Enlight – 1.9.8.874.
The enhancements in this release are:
- SQL Server 2017 RC2 support
- SQL Server 2017 T-SQL syntax support
- Improvements in analysis rules related with system functions
Enhancements in the previous release candidate:
- Integration with SQL Server Management Studio 17
- Integration with Visual Studio 2017
- SQL Server 2016 T-SQL syntax support
- 2 new code refactorings
- Command line and build task support for running code refactorings
- Fixed a few code formatting issues
- Enhancements in the analysis rules violations reporting
- Fixes for issues reported by users
- Other improvements, mainly internal
We are happy to announce the new SQL Enlight release candidate that is now available – 1.9.8.872-RC.
- Integration with SQL Server Management Studio 17
- Integration with Visual Studio 2017
- Support for the T-SQL syntax enhancements introduced in SQL Server 2016
- 2 new code refactorings
- Command line and build task support for running code refactorings
- Fixed a few code formatting issues
- Enhancements in the analysis rules violations reporting
- Fixes for issues reported by users
- Other improvements, mainly internal
Today we released SQL Enlight version 1.9.8.854 .
This update as well as the previous two updates is targeting an issue with SSMS 2016 integration.
We found a problem in our installer, related with SSMS 2016 extension installation.
The new version that fixes this problem is available here.
We released a couple of updates, which target problems with SQL Server Management Studio 2016 integration.
Other changes in these updates:
- Fixed a couple of parser issues with recognizing a specific syntax
- Formatting problem with new lines characters normalization
- Fixed issues some smaller issues found in previous version
We released a couple of updates, which target problems with SQL Server Management Studio 2016 integration.
Other changes in these updates:
- Fixed a couple of parser issues with recognizing a specific syntax
- Formatting problem with new lines characters normalization
- Fixed issues some smaller issues found in previous version
We are happy to announce the release latest release of SQL Enlight – version 1.9.8.851.The major updates in this release are the fixes of other issues found in the previous RC1 version.
- Here are the list of features and improvements made since the previous stable version 1.9.7.826.
- Visual Studio 2015 integration
- SQL Server Management Studio 2016 integration
- TFS 2015 checkin policy
- Improvements in command line tool
- New Delimit and Undelimit identifiers refactoring commands
- Enhancements of the Expand sp_executesql refactoring
- Instant code analysis improvements
- Fixed installer issue preventing installation without explicit elevation of privileges
- Fixed issues in the SQL Enlight SDK