Comprehensive Code Analysis Added to SQL Prompt
December 05, 2017

SQL from Redgate Software has been enhanced with a new code analysis feature.

Now, as well as offering advanced IntelliSense-style code completion, it alerts users to known code issues and hidden pitfalls as they type.

SQL Prompt is already a favored plug-in for SQL Server Management Studio and Visual Studio because it autocompletes code and takes care of formatting, object renaming, and other distractions.

Version 9, which has just been released, uses a library of rules behind the scenes to analyze code while it’s being written, detecting what are called code smells and providing instant solutions. By giving users inline suggestions for improving their SQL code, it helps them enhance the performance of their code, reduce maintenance and increase its reliability.

By suggesting improvements to the way code is written at the time it is being written, SQL Prompt will enable developers who are new to SQL coding to work faster and code smarter. They will learn how to fix issues before they even become a problem, with expandable information and further reading links available immediately.

To encourage the use of SQL Prompt as a team tool, with every member following the same best practice rules, deprecated rules, and naming conventions, etc, companies can also choose which analysis rules they want to follow from the library which is now included in SQL Prompt.

The inclusion of the new feature follows Redgate’s acquisition of the free tool, SQL Code Guard, which provides fast and comprehensive static analysis of T-SQL code. While SQL Code Guard continues to be free for personal and non-commercial use, the development team at Redgate has been adding further analysis rules, expanding the explanations of those rules, and integrating the functionality into Redgate tools like SQL Monitor as well as SQL Prompt.

Over 80 of the rules are already included in SQL Prompt v9, and more are being added daily to enhance its usability yet further.

Jamie Wallis, Redgate Product Marketing Manager, concludes: “SQL Prompt has been a popular SQL formatting tool for a long time. The addition of static code analysis is a major step forward and makes it a tool that improves the quality of SQL coding as well as increasing the speed of that coding.”

The Latest

December 14, 2017

Around one in five business leaders indicating that their software budget had increased 50 percent or more over the past three years to support digital transformation projects. However, the increased software development investment has not translated to greater security budgets or awareness of the security risks insecure software introduces: only 50 percent of business leaders surveyed understand the risk that vulnerable software poses to their business, according to Securing the Digital Economy, a report from Veracode ...

December 13, 2017

Metrics-oriented thinking is key to continuous improvement – and a core tenant of any agile or DevOps philosophy. Metrics are factual and once agreed upon, these facts are used to drive discussions and methods. They also allow for a collaborative effort to execute decisions that contribute towards business outcomes ...

December 11, 2017

The benefits of DevOps are potentially enormous, but simply identifying the benefits is not enough. A faster time to market may be a good customer story, but with no directly measurable monetary return, the value of DevOps can still be questioned at board level. Businesses want more than promises if they are to sign off on financial decisions: they need to know the Return on Investment (ROI) as well, with facts and figures that demonstrate what they will gain ...

December 07, 2017

Modern businesses are migrating to a cloud-based model for hosting sensitive data to reap the benefits of agility and cost savings as well as to keep pace with customer demand. Cloud-Native methodologies such as DevSecOps, continuous delivery, containers and micro-services are essential building blocks in the digital business revolution. However, moving information and technologies from hardware to software poses a security concern – translating to a top challenge for both IT and the C-level, as applications built on top of micro-services and containers in a Cloud-Native environment utilize a wide variety of secrets for their proper functioning ...

December 06, 2017

There was a time in cybersecurity strategy when most IT leaders considered perimeter and endpoint guards like antivirus and authentication controls to be the sum of network protection. But as attacks continue to increase in frequency and sophistication, leaders and DevOps teams have been focusing on the role of backup and disaster recovery in mounting a strong defense ...

December 04, 2017

In this blog I will summarize and share with you some wisdom about the biggest problem – okay, problems – in the field of software testing right now. While this is not an exhaustive list, these four bad habits have emerged as the predominant themes ...

December 01, 2017

The majority of testers – 63 percent – are responsible for both API and UI testing, according to the State of Testing 2017 Survey conducted by SmartBear Software. With the growth of methodologies like Agile and DevOps, testing teams have been shrinking and the line between roles increasingly blending ...

November 29, 2017

Companies today face a digital dilemma. How can they understand and discern if their approach to transforming their company to meet today's digital consumer is the right one? ...

November 27, 2017

It has been argued that Dev and Ops teams should work more closely together for some time. For many, the benefits of a closer relationship are clear, and the debate has moved on from if to how, but for lots of companies there are several types of walls to tear down ...

Share this