What’s new in SQL Enlight 1.7 BETA

• Improvements in analysis rules designer.
• Implemented several XPath extension functions including support for the http://exslt.org  extension modules.
• Support for Statistics in analysis context.
• Updates of some of the analysis rules – EX0001, EX0002 and EX0003.
• SQML optimization. See the changes in SQML that may affect your custom analysis rules.

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.

Obsolete SQML elements replaced in 1.7.0.494

During the optimization of SQL Enlight, we did small changes in the SQML schema. These changes will affect only the users who have created their own custom analysis rules.

The SQML elements: pu:optional, pu:essential and pu:binding are no longer generated and are replaced by pu:semicolon and pu:dot. Read the rest of this entry »

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.

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

We finnally completed our new web site implementation and the redesign. The new look and feel is thanks to our friends from Oxy Studio.

We are also pleased to offer three new licensing options for SQL Enlight – Academic,Classroom and MVP. Read more about the new licensing here.

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.