,

SQL Enlight 1.9.8.841 Beta

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.

  • Visual Studio 2015 integration
  • SQL Server Management Studio 2016 integration
  • Team Foundation Server 2015 Checkin policy
  • Improvements in command line tool
  • SSMS and Visual Studio integration improvements
  • Fixes of issues found in previous release
, ,

SQL Enlight 1.9.7.821

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.

 

, ,

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
, ,

SQL Enlight 1.9.5.771

What includes this update:

  • Optimizations of the analysis feature
  • Fixes and improvements
, ,

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 regular expressions for filtering analysis target objects
  • Several performance optimizations of the analysis feature
  • Fixes and improvements

The new SQL Enlight version can be downloaded here and new version of SQL Enlight for SSMS can be downloaded here.

,

How to get a free license of SQL Enlight

 

Until now, only MVPs and trainers are entitled to free SQL Enlight Licenses.  Now everyone who authors a custom analysis rule and shares it with the SQL Server Community can also get a free personal license of SQL Enlight For SSMS worth $145.

What you will have to do?

1. Think of a new useful custom analysis rule and implement it.

2. Write a blog post that describes the practice, which it is enforcing and share the rule’s xml file.

You have your rule and post ready, what’s next?

Simply email your rule to rules@ubitsoft.com or send us link to a blog post describing the rule. Once we check the rule we will give you a free SQL Enlight For SSMS license.

Wondering where to start?

First download and install the latest version of SQL Enlight or SQL Enlight For SSMS.

The Analysis Rule Designer which comes with the tools is not limited by the trial period and you can freely use it to learn create and test your analysis rules.

Here is some resources, which you can use:

More Resources:
We are preparing a step by step tutorial for how to create a custom rule with SQL Enlight and will add a link to it in this post as soon as we have the tutorial published.

If you have any questions, please feel free to contact us.

, ,

SQL Enlight 1.9.3.737

This is just a maintenance release containing only fixes and improvements.

,

SQL Enlight For SSMS on Simple Talk

This is a SQL Enlight For SSMS review by Grant Fritchey, which was published on Simple Talk last week:
https://www.simple-talk.com/sql/sql-tools/sql-enlight-for-sql-server-management-studio/

Grant’s review gives a detail look to the features of the tool and its use.

The article is recommended to anyone as an introduction to the tool.

, ,

SQL Enlight 1.9.3.733

This week we released an update for SQL Enlight and SQL Enlight for SSMS version 1.9.3.733.
The update include the following improvements common to both editions:

  • Small improvements and fixes
  • Improved Analysis rules selection dialog:

    select-rules-dialog
    The new rules selection dialog adds some useful filters and allows the rule parameters to be set in a single step.

  • Changes specific to SQL Enlight:

    • Added support for Visual Studio 2013

    Changes specific to SQL Enlight For SSMS:

    • NAnt tasks which were missing in the previous version are now included

    Download SQL Enlight and SQL Enlight for SSMS here.