SQL Enlight provides a fast, automated way to ensure that your T-SQL source code fits to your predefined design and style guidelines as well as best coding practices. With its help, you can easily analyze, identify and quickly resolve potential design and performance pitfalls in your SQL Server databases.
Refactoring and static code analysis tool for SQL Server
SQL Enlight is an advanced,but simple to use software development tool, designed to facilitate, improve and accelerate the database development with T-SQL.
Code and Database Analysis
SQL Enlight database analysis features are very similar to performing static analysis to detect and correct defects in managed code.
The advantage is that SQL Enlight can make use of the dynamic management information provided by SQL Server in order to provide more detail and accurate analysis results, and to be used to monitor the health of a server instance, diagnose problems, and tune performance.
Database developers and administrators can easily implement define and develop custom rules with just using XPath and XSLT. The analysis rules can utilize the following information to identify query performance pitfalls, index fragmentation issues, missing or not used index cases, and missing column and index statistics: dynamic management views and functions, existing indexes, statistics and query plans.
Code refactoring is the process of changing a computer program's source code without modifying its external functional behavior in order to improve readability, maintainability, extensibility or reduce complexity of the source code.
By continuously improving the design of code, we make it easier and easier to work with. This is in sharp contrast to what typically happens: little refactoring and a great deal of attention paid to expediently adding new features. If you get into the hygienic habit of refactoring continuously, you'll find that it is easier to extend and maintain code.
Joshua Kerievsky, Refactoring to Patterns
SQL Enlight has several features which can automate T-SQL code refactoring: layout code to improve readability, extract parts of the large script in new stored procedures or functions, and generate script summary or outline in order to identify components and statements in large T-SQL scripts.
Besides the analysis and refactoring features, the tool provides several features which can improve developers experience, facilitate and accelerate their work with SQL Server and T-SQL code.
- Validate T-SQL script and highlight the syntax errors in the code editor.
- Automated code reviews.
- Instant access to recently executed T-SQL scripts.
SQL Enlight is supports integration with SQL Server Management Studio and Visual Studio as an add-in, includes command line version and MSBuild tasks.
- Development Environment Integration
SQL Enlight integrates with Microsoft SQL Server 2005/2008/2008R2/2012/2014 Management Studio and Microsoft Visual Studio 2005/2008/2010/2012/2013 as Add-in.
- Command Line Interface
SQL Enlight comes with command line tool which support script layout, static analysis of server objects and report generation.
- Continuous Integration/Automated Build Support
SQL Enlight includes MSBuild tasks which are meant for supporting the continuous integration software development practice.
- Microsoft SQL Server 2005/2008/2008R2/2012/2014 Management Studio or Microsoft Visual Studio 2005/2008/2010/2012/2013 *
- Windows 2000, Windows XP, Windows 2003/2008 Server,Windows Vista, Windows 7, Windows 8
- Microsoft .NET Framework 2.0
- 1024MB RAM
- 50 MB hard disk space
* Does not support Express editions