Benefits
Quality, productivity, reduce time and costs
Value for a team
Find out the in which aspect your team can benefit from using SQL Enlight
Code quality
- Identify potential issues earlier in the 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.
- Easily enforce coding guidelines within your team and organization.
Productivity
- Develop new code faster with fewer errors.
- Facilitate legacy T-SQL code understanding and maintenance using the layout, summarize, and outline features.
- It provides a big productivity boost by finding issues early.
- 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 the T-SQL script as a stored procedure or function using just a few clicks.
- Instant access to recently executed T-SQL scripts.
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.
- Shortens 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
- Productivity, automation, and quality features along with early problem detection will help reduce both the development time and costs.
Value by a team member’s role
Find out the in which aspect your team can benefit from using SQL Enlight
Developer
SQL Enlight is a tool that can help not only DBA-s and database developers but also can give great value to the developers whose main job is not extremely related to SQL Server development.
Even you might be already using an ORM solution (Linq to SQL, Entity Framework, NHibernate, etc.) and you are not handling directly SQL Server databases and T-SQL code during your everyday work, at 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 a 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 sufficient 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 the 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 development practices 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 simplify and expedite the process of reviewing and improving their T-SQL code.
Database Professional
If your everyday work is related to managing and optimizing databases that have hundreds of tables, having thousands of 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 the 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 the 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 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.