,

SQL Enlight 1.7.2.509

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

, ,

SQL Enlight 1.7.1.502.

Today we released an update of SQL Enlight 1.7 which includes several usability improvements:

– Unicode support added for identifier names.

Example of unicode identifiers usage

– Context only rules are now applied when analyzing server objects using the command line tool and the MSBuild tasks. This feature was missing in the previous release.

– The Context Only rules are can be applied either with using Analyze with Specific Rules… command or when analyzing databases or servers. For instance, the Context Only rules will be skipped when a stored procedure is analyzed, but will be included when a database is selected for analysis from Object Explorer. The Context Only rules will be always applied when explicitly selected.

– Each analysis rule can be separately configured whether to require its parameters to be entered before analysis or not to require parameters. This way, the parameters dialog won’t be shown when rules with no required parameters are selected, but then the default rule parameter values will be used.

– A new Error list command which to instantly show the SQL Enlight Error List window is now added to the SQL Enlight menu.

You can find and download the updated SQL Enlight version here.

, ,

SQL Enlight 1.7 RTM

We are happy to announce the final release of SQL Enlight 1.7.  The tool is available for download here.

Improvements and new features in SQL Enlight 1.7

  • Integrated analysis rules are removed – now all rules are customizable.
  • Analysis context – server details and database schema are now available during static code analysis and can be used in the analysis rules.
  • Parameterized analysis rules – analysis rules can have parameters that to be specified before analysis.
  • Executed statements history – new feature for saving reusing executed queries in SQL Server Management Studio.
  • Improved analysis rule designer – support the new analysis context, testing of XPath expressions, tree views of test query SQML and analysis.
  • Explicit analysis group – rules in that group can be executed directly from the SQL Enlight menu.
  • Export and import of analysis rules and analysis templates – analysis template and analysis rules now can be exported and easily shared between team members.
  • Analysis before executing T-SQL script – analysis can be configured to be run just before executing T-SQL code in SSMS.
  • Analysis rule selection before analysis – now you can choose which rules to use just before running the analysis.
  • Extended SSMS object explorer analysis menu – the menu now allows using specific analysis group or analysis rule separately.
  • Support for several XPath extension functions including support for the http://exslt.org extension modules.
  • New analysis rules – the default analysis template now includes 19 new static analysis rules.

Thank you all, for your feedback and suggestions! You helped us in creating all the great new features in the current SQL Enlight release!

Hope you will enjoy it as much as we do!

,

SQL Enlight 1.7 BETA

What’s new in SQL Enlight 1.7 BETA

Previous release improvements and new features

  • Integrated analysis rules are removed and now all rules are customizable.
  • Analysis context – server details and database schema are now available during analysis and can be used in the analysis rules.
  • Parameterized analysis rules – analysis rules can have parameters that to be specified before analysis.
  • Executed statements history – new feature for saving reusing executed queries in SQL Server Management Studio.
  • Improved analysis rule designer – support the new analysis context, testing of XPath expressions, tree views of test query SQML and analysis.
  • Explicit analysis group – rules in that group can be executed directly from the SQL Enlight menu.
  • New analysis rules – the default analysis template now includes 9 more rules ( 5 of them are explicit rules ).
  • Export and import of analysis rules and analysis templates – analysis template and analysis rules now can be exported and easily shared between team members.
  • Analysis before executing T-SQL script – analysis can be configured to be run just before executing T-SQL code in SSMS.
  • Analysis rule selection before analysis – now you can choose which rules to use just before running the analysis.
  • Extended SSMS object explorer analysis menu – the menu now allows using specific analysis group or analysis rule separately.

We have planned the release of the final version at the beginning for the third week of February 2010.

The beta version in now available for download here.

, ,

SQL Enlight 1.7 CTP

Just at the at the end of 2009, we are happy to announce the CTP release of SQL Enlight 1.7!  It took us a while, but we think that the result is worth it.

The new version can download here. 

Overview

  • Analysis context – server details and database schema are now available during analysis and can be used in the analysis rules.
  • Parameterized analysis rules – analysis rules can have parameters that to be specified before analysis.
  • Executed statements history – new feature for saving reusing executed queries in SQL Server Management Studio.
  • Improved analysis rule designer – support the new analysis context, testing of XPath expressions, tree views of test query SQML and analysis.
  • Explicit analysis group – rules in that group can be executed directly from the SQL Enlight menu. 
  • New analysis rules   – the default analysis template now includes 9 more rules ( 5 of them are explicit rules ).
  • Export and import of analysis rules and analysis templates  – analysis template and analysis rules now can be exported and easily shared between team members.
  • Analysis before executing T-SQL script – analysis can be configured to be run  just before executing T-SQL code in SSMS.
  • Analysis rule selection before analysis –  now you can choose which rules to use just before running the analysis.
  • Extended SSMS object explorer analysis menu – the menu now allows using specific analysis group or analysis rule separately.
  • Several other integration and usability improvements.

        SQL Enlight 1.7 features overview

This release is a CTP which includes the new features of the coming version 1.7.  What the final version is going to include are some optinizations,improvements and completed documentation.

The final version will be available at the beginning of February 2010. Until then, any feedback and feature requests are welcome.

That’s all for now from us, have a nice holidays, Marry Christmas and Happy New Year!

Ubitsoft Team

, ,

SQL Enlight 1.6

New features in v1.6

  • Custom analysis rules

    Design, implement and tune powerful static analysis rules using XPATH and XSLT.

  • Create and manage analysis groups

    Categorize analysis rules in custom groups.

  • Command line interface

    The command line tool supports server analysis, analysis and layout of T-SQL script files, and report generation.

  • Integration with automated builds

    The MSBuild tasks support server analysis, analysis and layout of T-SQL script files, and report generation.

  • Analysis of SQL Server objects

    Now SQL Enlight can directly analyze servers, databases, stored procedures, functions, views and triggers.

, ,

SQL Enlight 1.5

What’s new in SQL Enlight v1.5

  • 12 new analysis rules

    Ten performance and two design analysis rules were included.

  • New arithmetic operator layout rule

    New rule for handling arithmetic operator placement was included.

Enhancements in v1.5

  • Full support of SQL Server 2008 Transact-SQL syntax.
, ,

SQL Enlight v1.4

What’s new in Ubitsoft SQL Enlight v1.4

  • Encapsulate T-SQL Script

    Encapsulate selected SQL code as a new stored procedure,scalar function or inline table-valued function.

  • Comments handling layout rules.

    New rules for handling comments placement are included.

  • Four new rules for breaks placement in comma lists.

    The rules controls comma list breaks in SELECT,ORDER BY and GROUP BY column lists, and in expressions.

Improvements in v1.4

  • Improved Transact-SQL Script Summary.
  • Extended variable case handling layout rule.
  • Fixed the content indention of multi-line strings and comments bug.
, ,

SQL Enlight 1.3

Enhancements in Ubitsoft SQL Enlight v1.3

  • Integration with Visual Studio 2008 and SQL Server Management Studio 2008 CTP

New features:

  • Transact-SQL Script Analysis

    Scan Transact-SQL code for design and performance problems, deprecated syntax and get best practices recommendations using 22 code analysis rules.

  • SQL Enlight Error List

    Use SQL Enlight Error List to view and locate all syntax errors and analysis rule violations.

, ,

SQL Enlight 1.2

New features in Ubitsoft SQL Enlight v1.2

  • Transact-SQL Script Summary

    Using the Script Summary you can view a short hierarchically summary of all batches and statements in the current T-SQL script.

  • Separate T-SQL script validation command

    Using the Validate SQL command you can identify syntax errors in a T-SQL script without SQL Server connection.

  • Join clause alignment layout rule

    This new layout rule modifies the placement of the join clause in the SELECT statements.

  • Tabify white space layout rule
    This layout rule can specify if to replace the tab sized white space with tabs or spaces.