Archive for July, 2010


SQL Enlight version 1.7.2.513 released

Monday, July 26th, 2010

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.

Creating analysis rules with SQL Enlight – Overview

Monday, July 19th, 2010

One of the most exciting features in SQL Enlight is the ability to create your own static analysis rules. This is very powerful feature which can be of great use and unleash almost unlimited number of possibilities for the ones who consider trying it.

The current post is the first of a series of blog posts which to guide you through the creation of custom static code analysis rules with SQL Enlight. Each of the subsequent articles will cover the implementation of several interesting analysis rule and will point some unfortunately not so obvious features and abilities of SQL Enlight static code analysis engine.

(more…)

Online T-SQL Analyzer

Thursday, July 8th, 2010

We are happy to announce the release of our new online T-SQL Analyzer.

The T-SQL Analyzer uses the SQL Enlight static code analysis engine to check T-SQL code for compliance with best practices.

The online tool supports the following set of analysis rules: all rules from SA0001 to SA0039 and also rules SA0042, SA0043, SA0051, SA0053 and SA0054.

You can check here for more information about the analysis rules.