Contents 

Ubitsoft SQL Enlight Online Help

Statement History
Analysis Templates Import /Export
General Analysis Settigs
SSMS Analysis Settigs
Fix Obsolete Analysis Rules Expressions
Layout Templates

Statement History

Use the Statement History settings to configure:

Collect history of executed statements - enable or disable statements history

Statement history maximum size  -  the maximum number of statements which to be stored

Statement text maximum length - the maximum size of the statement text in order it to be saved in history.

Settings - Statement History

General Analysis Settings

Analysis Templates Import /Export

Export and import analysis templates in xml file and configure the source of the Analysis Context which to be used in Analysis Rule Designer.

Settings - Analysis General

Test Analysis Context

Path to default analysis context xml which to be loaded and used for testing in the Design Analysis Rules dialog.

Analysis Context Mode

Choose the detail level of the analysis context:

Basic

Basic mode will load only the most commonly used schema informaiton such as:

  • Server Information
  • Principals, Role Members
  • Schemas
  • Data Types
  • Assemblies
  • Tables, Views, Triggers
  • Functions, Partition Functions, Stored Procedures
  • Rules,Defaults,Synonyms
  • Xml Schema Collections
  • Indexes,Foreign Keys, Primary Keys, Check Constraints, Default Constraints
  • FullText Catalogs, Data Spaces, File Groups
  • Dependencies, Partition Schemes
  • Statistics
Full

The Full mode will load all the basic schema information and also some additional database objects:

  • Message Types
  • Service Contracts, Service Queues, Services, Service Bindings
  • Routes
  • SymmetricKeys
  • AsymmetricKeys, Certificates
  • Extended Properties, Event Notifications

Fix Obsolete Analysis Rules Expressions

Settings - Fix Obsolete Analysis Rules Expressions
Since version 1.7.0.494,the SQML elements pu:optional,pu:binding and pu:essential are substituted with pu:dot and pu:semicilon elements:

OldNew
pu:binding[@name=';']pu:semicolon
pu:binding[@name='.']pu:dot
pu:essential[@name=';']pu:semicolon
pu:essential[@name='.']pu:dot
pu:optional[@name=';']pu:semicolon
pu:optional[@name='.']pu:dot

Use this the Check for rules that use obsolete elements and Fix rules that use obsolete elements buttons to validate and update your custom analysis rules.

SSMS Analysis Settings

This settings tab contains SQL Server Management Studio specific configuration options:

Enable static analysis on Execute command - select this option in order to analyze the T-SQL code before being executed.

Enable static analysis on Parse command - select this option in order to analyze the T-SQL code before parsing it.

For each of the above options is possible to specify if to allow selection of analysis rules before actually running the analysis or not, using the Enable analysis rule selection options.

Settings - Analysis SSMS

Layout Templates

See more about layout template settings in Managing Layout Templates topic.