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

October 22, 2018

Embracing DevOps at enterprise scale requires a seismic shift in the way an organization plans, builds, tests, releases, and manages applications. Here are four ways to ensure your enterprise DevOps transformation is a success ...

October 18, 2018

Are applications teams prepared to manage the chaos arising from an ever-growing landscape of heterogeneous deployment types? A recent survey of application and operations professionals sought to better understand how the industry is shifting and what the future of DevOps might look like. Here is what the survey uncovered ...

October 16, 2018

More than half of organizations have a dedicated DevOps team to help them better implement agile strategies, accelerate release cycles and ensure continuous development. However, databases have a habit of holding DevOps back ...

October 15, 2018

Test Environment Management can save organizations close to $10,000 for each release, yet only four percent of large enterprises have fully integrated TEM processes into organizational DNA, according to the 2018 Test Environment Management Survey released by EMA and Plutora ...

October 11, 2018

Agile is indeed expanding across the enterprise and there was a significant jump from last year to this year in the percentage of respondents who indicated that all or almost all of their teams were agile, according to the State of Agile 2018 report from CollabNet ...

October 09, 2018

Adopting a modern application architecture is critical to business success and a significant driver of profit growth in today’s digital economy, according to the results of a global survey of IT and business executives released by CA Technologies and conducted by Frost & Sullivan ...

October 04, 2018

How do you integrate tools to enable shift-left performance? The following tools will simplify maintenance, can be managed in a centralized way, and provide an easy-to-use UI to comprehend results ...

October 03, 2018

Focusing at the API layer of an application can help enable a scalable testing practice that can be efficiently executed as part of an accelerated delivery process, and is a practice that can be adopted and enabled at the earliest possible stages of development — truly shifting left functional testing. But what about performance testing? How do we enable the shift left of nonfunctional testing? Here, we explore what this means and how to enable it in your organization ...

October 01, 2018

As businesses look to capitalize on the benefits offered by the cloud, we've seen the rise of the DevOps practice which, in common with the cloud, offers businesses the advantages of greater agility, speed, quality and efficiency. However, achieving this agility requires end-to-end visibility based on continuous monitoring of the developed applications as part of the software development life cycle ...

September 27, 2018

Imagine that you are tasked with architecting a mission-critical cloud application. Or migrating an on-premise app to the cloud. You may ask yourself, "how do the cloud savvy companies like Airbnb, Adobe, SalesForce, etc. build and manage their modern applications?" ...

Share this