We released a couple of updates, which target problems with SQL Server Management Studio 2016 integration.
Other changes in these updates:
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.
We are delighted to announce the new release candidate that is now available – SQL Enlight 1.9.8.849 RC1
Here is what’s changed in SQL Enlight 1.9.7.826:
We are happy to announce the new SQL Enlight version 1.9.8.841, which is now available for beta testing.
The main target of the update is the added integration support for Visual Studio 2015 and SSMS 2016.
The release targets a few small issues that were found in the previous release.
We are delighted to announce the release of the latest SQL Enlight update – version 1.9.7.821.
This is a release of some exciting user experience improvements on which we worked the past months.
Here is a summary of what’s new in version 1.9.7.821:
Instant Code Analysis
This is probably the most exciting feature in the new release. It allows the analysis to run in the background and get analysis results while a SQL document is edited.
Non-blocking UI operations
The analysis, refactoring and code formatting operations are no more going to block user interface and until the specific operation is completed, but will run asynchronously in the background.
Script Summary improvements
The Script Summary is now opened as a non modal tool window and the summary is updated in the background with the SQL document changes.
TFS Policies improvements
Clicking the analysis violations now will open the file,which is the source of the violation.
Enhancements in Error List
Added several filtering options and other improvements.
Other fixes, optimizations and improvements
We did many other improvements in MSBuild, NAnt tasks and command line tool, and Visual Studio and SQL Server Management Studio integration.
You can download and try the final release of SQL Enlight 1.9.7.821here and the latest version of SQL Enlight for SSMS – here.
What’s updated in this release:
What includes this update:
Non-ISO standard comparison operator found
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.
While it is currently acceptable to use such non-ISO operators, you should consider that statements that you create might not be supported on other ISO-compliant database management systems.
Also, non-ISO standard comparison operators may not be supported on future versions of SQL Server.
Phil Streiff
-- Test Case 1: The violation should be reported
SELECT Column1 FROM Table1 WHERE Column1 != 1
-- Test Case 2: The violation should be reported
SELECT Column1 FROM Table1 WHERE Column1 !< 1
-- Test Case 3: The violation should be reported
SELECT Column1 FROM Table1 WHERE Column1 !> 1
-- Test Case 4: A violation should not be reported
SELECT Column1 FROM Table1 WHERE Column1 <> 1
-- Test Case 5: A violation should not be reported
SELECT Column1 FROM Table1 WHERE Column1 >= 1
-- Test Case 6: A violation should no be reported
SELECT Column1 FROM Table1 WHERE Column1 <= 1