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.