Features

The rules are grouped in layout templates that can be stored and later reused. The Quick Layout Template feature allow the developers of fast switching between layout templates and use the one that best suits the current circumstances.

Use the Analysis Script feature to identify common performance, design and database objects naming problems in the T-SQL code.

Using the custom analysis designer developers can easily implement custom analysis rules.

Run T-SQL analysis on servers, databases, stored procedures, functions, views and triggers.

SQL Enlight fully supports analysis of server and database schema objects using analsysis rules and analysis context.

SQL Enlight fully supports analysis of server and database schema objects using analsysis rules and analysis context.

Collect and reuse executed statements with a single mouse click.

Create new analysis groups and categorize analysis rules by your preferences.

Transact-SQL Script Summary can improve readability and help the developers and database administrators to identify and analyze long SQL scripts. Using the Script Summary you can view and navigate through the hierarchically structured summary of all batches and statements in the current T-SQL script.

Use the Encapsulate Script feature to generate script for creation of a new stored procedure, scalar function or inline table valued function from T-SQL code.

The statements outlining feature surrounds each statement in the T-SQL scrip with outlining rectangle.

When a Transact-SQL syntax error is found in the SQL script, it is highlighted in the code editor and a tooltip describing the error is supplied.

A configured set of layout rules can be stored in a layout template and later applied over T-SQL scripts.

The QuickLayout Template feature allow the developers of fast switching between layout templates and use the one that best suits the current circumstances.

Run T-SQL analysis on server objects form Object Explorer window of SQL Server Management Studio.

Generate XML reports of analysis rule violations.