Ubitsoft SQL Enlight is a refactoring and static code analysis tool for SQL Server. It gives a quick, automated means to make certain your T-SQL resource code matches your predefined layout and design guidelines together with best programming practices.

SQL Enlight database evaluation features are extremely much like doing static analysis to detect and fix flaws in managed code. The benefit is that SQL Enlight may use the dynamic management advice offered by SQL Server to give more detailed and precise analysis results and be utilized to track the health of a server case, diagnose problems, and song performance.

Database administrators and developers can quickly implement, define and create customized rules by only using XPath and XSLT. The analysis rules may use the following advice to discover query functionality pitfalls, indicator fragmentation problems, missing or not used indicator cases, and overlooking column and index data: dynamic management views and purposes, present indicators, data, and query strategies.

• Code Evaluation: Utilize the analysis attribute to recognize shared functionality, layout, and database items naming topics and get guides and tips for maximizing your T-SQL databases and code.
  • Identify flaws early in the growth cycle.
  • Find possible performance and design problems.
  • Locate deprecated features use.
  • Boost code quality.
  • Automate code testimonials.
  • More than 140 from the box investigation principles.
  • Identify actual and potential functionality and layout problems.
• Reformat T-SQL code: SQL Enlight permits you to format your code from a set of over 40 configurable layout principles. The formatting rules comprise indentation, aligning spaces, braces design, anything linked to an own code structure. By default, SQL Enlight includes a set of predefined design templates which you can use as a beginning.
  • Boost readability and maintainability.
  • Facilitate third party database consumption and upkeep.
  • Configure custom design templates to meet your preferences.
  • Practice your predefined coding instructions.
• Employ your personal rules: Utilizing the research rule designer, it is simple to implement your own analysis rules or alter the present from the box rules, including SQL Enlight.
  • Use XSLT and XPath to execute powerful customized analysis principles.
  • Support investigation of the T-SQL code and database schema.
  • Utilize database context data: the database schema, indexes, data, etc...
  • Use dynamic management views advice.
  • Index fragmentation evaluation service.
  • Query execution strategy investigation service.
• Executed statements history: Utilize the Statement History reuse and analyze the newly implemented T-SQL statements.
  • Gather and reuse executed statements using one mouse click.
  • Immediate access to the newly implemented T-SQL statements.
• T-SQL script outline: With the Script Summary, you may see and navigate via the hierarchically ordered listing of batches and statements from the present T-SQL script. The Script Summary reveals all activities the script works, at the sequence in which they happen.
  • Identify elements in big T-SQL scripts.
  • Provide simple navigation via the script.
• Refactor T-SQL code: Accessible refactoring commands:
  • Extract parts of T-SQL code stored procedure, function, see, as a distinct script, or as a sp_executesql call.
  • Expand calls into the sp_executesql stored process.
  • Insert schema title to all or any qualified items found from the T-SQL script.
  • Facilitate refactoring of big stored procedures and scripts.
  • Factors referenced in the extracted code are encapsulated as parameters.
  • Optionally refer to this new item in the first script.
  • Insert statement terminators
  • Delimit and Un-delimit identifiers
• T-SQL statements representing: The statements outlining feature provides a fast and convenient means to differentiate distinct statements in big T-SQL scripts by encircling each announcement using an abysmal rectangle.
  • Identify elements in big T-SQL scripts.
  • Emphasize individual statements from the T-SQL code.
• Validate T-SQL code for syntax mistakes: SQL Enlight utilizes its internal parser to confirm the T-SQL code. When a syntax error is located from the SQL script, it's emphasized in the code editor, and a tooltip describing the mistake is provided.
  • Validate code with no necessity for an energetic SQL connection.
  • Highlight mistakes in the code editor.
  • Examine and browse to particular syntax mistakes using the SQL Enlight Error List.
• Create evaluation reports: You can make an investigation report using the command-line instrument or those investigations MSBuild tasks.
  • Create XML reports of investigation rule violations.
  • Control output formatting and content.
• Constant integration service: Use SQL Enlight on your automatic builds to identify problems sooner while the adjusting costs continue to be minimal.
  • Support automatic builds.
  • SQL Enlight includes a command-line edition.
  • MSBuild and NAnt tasks such as analyzing and reformatting code will also be contained.
  • Support for creating analysis reports.
• Configure by your standards: Configure and apply the supplied from the box investigation and design rule based on guidelines and industry best practices to your wants, or specify your own principles that follow your standards.
  • Configure analysis guidelines to match your coding criteria.
  • Configure your code partitioning templates.
  • Group analysis guidelines on your own classes.
  • Alter or expand present rules to fulfill your requirements.
  • Utilize special rule parameters to alter analysis rule behavior.
• Database and host schema investigation: Together with T-SQL code investigation, SQL Enlight provides supports for assessing SQL Server schema items and utilizing database schema through evaluation, and supports executing custom queries and retrieving data directly from the circumstance database and server.
  • Quick and effortless means of assessing entire servers, server databases, single database or special database object ( procedure, function, view of activating) or database object kind.
  • The database schema can be obtained to this analysis rule throughout the analysis procedure.
  • Schema object evaluation is available in the command line application, construct jobs, and type Object Explorer window of SQL Server Management Studio.
  • Support for utilizing SQL Server Dynamic Management Views and Functions within evaluation principles.
• Query execution plan investigation: The projected query execution plan analysis features provide the following advantages:
  • Automate implementation plan investigation.
  • Assess the execution strategy of T-SQL script, stored procedures, and views.
  • Check for missing indicators in the query program.
  • Assess for high-cost operators (Bookmark Lookups, Table Scans, Index Scans, etc.).
• Indicator and data investigation: SQL Enlight supplies several from the box investigation rules for assessing indicators and statistics say and efficacy:
  • Find missing indicators.
  • Find unused indicators.
  • Find overlapping or duplicate indicators.
  • Missing indexes on foreign important columns.
  • Identify significant indexes.
  • Locate superior applicants for a clustered index.
  • Identify missing or obsolete statistics.
• Integration with Visual Studio and SQL Server Management Studio: SQL Enlight supports integration with Microsoft SQL Server Management Studio and Microsoft Visual Studio as an Add-on.
  • Examine T-SQL code within the development environment.
  • Assess SQL Server items within SQL Server Management Studio.
  • SQL Server Management, Studio Object Explorer integration.
  • Fast change of design templates.
  • Examine T-SQL script, databases, or host utilizing all or any person analysis rules or bands.
  • Errors and violations are emphasized in the code editor.
  • Instantly navigate to breach source code.
  • Instant code investigation