Blog
SQL Enlight Team Blog
Recent
- SQL Enlight Code Quality For SonarQube 2.1.3 November 15, 2024
- SQL Enlight For Build Machines 1.1.6.21 November 15, 2024
- SQL Enlight For Developers 2.0.3.93 November 15, 2024
- SQL Enlight 1.9.9.975 November 15, 2024
- SQL Enlight Code Quality For SonarQube 2.1.2 August 23, 2024
Online SQL Tools
Latest News
Categories
- Analysis Rules (5)
- Continuous Integratoin (13)
- How to & Tutorials (7)
- News & Events (105)
- Online (1)
- T-SQL Analyzer (1)
- T-SQL Beautifier (1)
- SonarQube (5)
- SQL Enlight (97)
- Troubleshooting (1)
Query Execution Plan Analysis Overview
The extended Execution Plan Analysis support is the most significant improvement in the latest SQL Enlight release 1.7.3.515. It allows execution plans analysis to be automated and applied not only on separate statements or batches but on all stored procedures and views in a given database.
SQL Enlight 1.7.2.513
Last week we released a new version of SQL Enlight – 1.7.2.513. It contains just small fixes and 2 new features: A new layout rule ‘Miscellaneous->Keywords padding’. The layout rule controls the padding of the main keywords in SELECT, INSERT,UPDATE and DELETE statements. For example: — Keyword Padding option set to 10: SELECT ProductID , SpecialOfferID , AVG( UnitPrice ) AS ‘Average Price’ , SUM( LineTotal ) AS SubTotal FROM Sales.SalesOrderDetail WHERE SpecialOfferID IN( 1 , 2 , 6 , 9 ) […]
Creating analysis rules with SQL Enlight – Overview
One of the most exciting features in SQL Enlight is the ability to create your own static analysis rules. This is a very powerful feature that can be of great use and unleash almost an unlimited number of possibilities for the ones who consider trying it. The current post is the first of a series […]