Benefits
SQL Enlight can help you improve quality of your code and productivity of your team. You can enforce development practices and guidelines.The tool can save you a lot of time and will help your organization in reducing the development and maintenance costs.
Overview
Find out the main aspects in which you can benefit from using SQL Enlight:
» Quality
- Identify potential issues earlier in development cycle - defects are cheaper to fix the earlier they are identified.
- Produce quality code - code analysis is one of the strategies for improving code quality.
- Improve T-SQL code readability and maintainability.
» Productivity
- Develop new code faster with fewer errors.
- Facilitate legacy T-SQL code understanding and maintenance using the layout, summarize and outline features.
- Provides a big productivity boost by finding issues.
- Save time - simply write your code and use SQL Enlight to identify issues with naming, design and performance in your stored procedures, function , triggers and views.
- Refactor existing code making it easier to read and cheaper to maintain.
- Enhance T-SQL handling in both SQL Server Management Studio and Visual Studio.
- Encapsulate T-SQL script as stored procedure or function using just a few clicks.
- Instant access to recently executed T-SQL scripts.
» Standardization
- Easily enforce coding guidelines within your team and organization.
- Make automatic code reviews.
» Configurability & Extensibility
- Highly configurable T-SQL layout templates.
- Easily implement custom analysis rules which to follow best development team preferences and practices.
» Training & Learning
- Less experienced developers can improve their T-SQL programming skills and get to know the T-SQL best practices with the help of the static code analysis.
- Shortening learning curve for legacy and third party code.
- Categorized set of rules with guidelines.
» Automation
- Automate code reviews as part of the development routine.
- Analyze source files, databases or individual servers.
- Implement fast and efficient error detection during automated build process.
» Time and Costs
- Productiviy,automation and quality features along with the early problem detection will help reduce both the development time and costs.
Value by Role
Find out what you can value from SQL Enlight depending on your particular role:
» Developer
SQL Enlight is a tool which is able to help not only to DBA-s and database developers,but also can be give a great value to the developers whose main job is not extremely related with SQL Server development.
Even you might be already using a ORM solution (Linq to SQL, Entity Framework, NHibernate and etc.) and you are not handling directly SQL Server databases and T-SQL code during your everyday work, at the some point of your project lifecycle you will have to deal with the underlying database. When that time comes, SQL Enlight can be your best friend. It will help you to get better knowledge of the database, to identify and solve potential problems
Improve database development skills
With the help of the static code analysis, the less experienced developers can improve their T-SQL programming skills and get better knowledge of the common T-SQL best practices or your organization specific development standards.
Improve productivity
Using the SQL Enlight you can dramatically decrease the time and efforts required for learning and working with third party created or legacy T-SQL code and SQL Server databases.
» Development Team Lead
SQL Enlight can help your team development with SQL Server in several aspects:
Identify problems early in the project lifecycle
Be able to identify and reduce T-SQL code defects, get database optimization tips and improve database schema earlier, and continuously during the development process by including SQL Enlight in automated builds of your project.
Enforce common coding standards
One of the essential things to improve the quality of the source code produced by your team and yet your organization, is to adopt a simple set of coding standards. SQL Enlight can help you with this task by providing common T-SQL code layout templates.
Code reviews
Code reviews are important practice for ensuring good quality of the produced code, but sometimes it also can be a painful and time consuming experience for everyone involved. Teams creating applications using SQL Server and writing T-SQL code can use SQL Enlight to automate and absolutely simplify, and expedite the process of reviewing and improving their T-SQL code.
» Database Professional
If your everyday work is related with managing and optimizing databases which have hundreds of tables, having thousands lines of T-SQL codes in stored procedures, functions, views and triggers is not a task for everyone, SQL Enlight is just the tool designed to help you in your work. Now some of the most tedious and often hard and time consuming tasks can be achieved with a mouse click or two.
Finding missing indexes, statistics or foreign keys, identifying T-SQL code, and schema defects over your SQL Server databases are just a few of the benefits that you can get. Tasks that are otherwise often considered hard and time consuming, using the tool they can be completed in a few minutes.
SQL Enlight analysis rules are made highly extensible.Even the fact that tool provides over 70 specially designed static code analysis rules, you can easily create new or extend any of the existing rules in a way to represent your specific needs.
» Project or Product Manager
SQL Enlight will help you and your team with reducing development time by on time by early identifying defects, improving quality and performance, and of course reducing development and maintenance costs.
SQL Enlight is a database development tool, but it is a tool that can save you time and expenses, and also can improve quality of the products you create.
If you have experience with a project that failed customer acceptance because of database performance related issues or you remember your development team spending several dozens of hours to identify the and fix database problems that appeared just before the project release, you may want to consider investing in SQL Enlight. The tool's price is probably not much than the cost of a couple of development hours, but the value it brings, will save you far more resources, time and money.