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

July 19, 2018

Despite 95 percent of CIOs expecting cyberthreats to increase over the next three years, only 65 percent of their organizations currently have a cybersecurity expert, according to a survey from Gartner. The survey also reveals that skills challenges continue to plague organizations that undergo digitalization, with digital security staffing shortages considered a top inhibitor to innovation ...

July 17, 2018

In my first blog in this series, I highlighted some of the main challenges teams face with trying to scale mainframe DevOps. To get past these hurdles, the key is to develop an incremental approach that enables teams to capture value along each step of the journey ...

July 16, 2018

The key to mainframe DevOps success is in quickly identifying and removing major bottlenecks in the application delivery lifecycle. Major challenges include collaboration between mainframe and distributed teams, lack of visibility into the impact of software changes, and limited resource flexibility with scaling out necessary testing initiatives. Now let's take a closer look at some of these key challenges and how IT departments can address them ...

July 11, 2018

How much are organizations investing in the shift to cloud native, how much is it getting them? ...

July 10, 2018

In the shift to cloud native, many organizations have adopted a configuration-as-code approach. This helps drive up application deployment velocity by letting developers and DevOps teams reconfigure their deployments as their needs arise. Other organizations, particularly the more regulated ones, still have security people owning these tools, but that creates increased pressure on the security organization to keep up. How much are organizations investing in this process, and how much is it getting them? ...

June 28, 2018

More than a third of companies that use serverless functions are not employing any application security best practices and are not using any tools or standard security methodologies to secure them, according to the State of Serverless Security survey, conducted by PureSec ...

June 27, 2018

The popularity of social media platforms and applications is spurring enterprises to adopt "social business" models to better engage with employees and customers and improve collaboration, according to a new study published by ISG ...

June 25, 2018

The previous chapter in this WhiteHat Security series discussed Codebase as the first step of the Twelve-Factor App and defined a security best practice approach for ensuring a secure source control system. Considering the importance of applying security in a modern DevOps world, this next chapter examines the security component of step two of the Twelve-Factor methodology. Here follows some actionable advice from the WhiteHat Security Addendum Checklist, which developers and ops engineers can follow during the SaaS build and operations stages ...

June 21, 2018

DevSecOps is quickly gaining support and traction, within and beyond information security teams. In fact, 70% of respondents believe their culture can embrace the change needed to fuse Security and DevOps, according to a new survey of 80 security professionals by Aqua Security ...

June 20, 2018

The larger the company size, the higher the proportion of low IT performers, according to the State of DevOps: Market Segmentation Report from Puppet, based on the 2017 State of DevOps Survey data ...

Share this