Version History

Releases, SQL Enlight

SQL Enlight 1.7.3.516

Query execution plan analysis support for functions

Extended query execution plan analysis support
One new analysis rule for query execution plan analysis
Small improvements and fixes

September 13, 2010

News & Events, Releases, SQL Enlight

SQL Enlight 1.7.2.513

Last week we released a new version of SQL Enlight – 1.7.2.513.
It contains just small fixes and 2 new features:

A new layout rule ‘Miscellaneous->Keywords padding’.

The layout rule controls the padding of the main keywords in SELECT, INSERT,UPDATE and DELETE statements.
For example:

-- Keyword Padding option set to 10:
SELECT     ProductID ,
           SpecialOfferID ,
           AVG( UnitPrice ) AS 'Average Price' ,
           SUM( LineTotal ) AS SubTotal
FROM       Sales.SalesOrderDetail
WHERE      SpecialOfferID IN(  1 ,
                               2 ,
                               6 ,
                               9 )
GROUP BY   ProductID ,
           SpecialOfferID
ORDER BY   ProductID ,
           SpecialOfferID DESC

-- Keyword Padding option set to 0:

SELECT ProductID ,
       SpecialOfferID ,
       AVG( UnitPrice ) AS 'Average Price' ,
       SUM( LineTotal ) AS SubTotal
FROM Sales.SalesOrderDetail
WHERE  SpecialOfferID IN(  1 ,
                           2 ,
                           6 ,
                           9 )
GROUP BY ProductID ,
         SpecialOfferID
ORDER BY ProductID ,
         SpecialOfferID DESC

A new XSLT extension method ‘execute-query-plan’ which to enable support for query plan analysis.

We will describe in more detail the usage of this method in the next post.

The new version is already available for download here.

July 26, 2010

Releases, SQL Enlight

We are very excited to announce that the latest and greatest version of SQL Enlight, version 1.7.2.509, is now available for download.
The new release of SQL Enlight includes: several usability improvements, 13 absolutely new analysis rules, and at last but definitely not at least is the support for directly executing database queries from within the analysis rules.

This new direct queries support, even not being exceptional by its means is quite useful and important and enables new opportunities for not only implementing static code analysis rules, but also for dynamic database analysis with SQL Enlight. Read more

June 24, 2010

Version History

SQL Enlight 1.7.3.516

SQL Enlight 1.7.2.513

SQL Enlight 1.7.2.509

Online SQL Tools

Latest News

Categories

Looking for something? Try search: