Redgate Releases SQL Prompt v9
July 31, 2018

The latest release of Redgate Software’s most popular tool, SQL Prompt, elevates it from helping to develop and standardize new code to discovering problems in legacy code.

The winner of the Visual Studio Magazine 2017 Reader’s Choice Gold Award in the productivity tools category, SQL Prompt plugs into SQL Server Management Studio and Visual Studio and enables developers to write, format, refactor and analyze SQL code.

When SQL Prompt v9 launched in November 2017, it introduced a code analysis feature which spots code issues and hidden pitfalls as users type. It parses the code, as a compiler would, but rather than compile the code, it checks the syntax for compliance with a built-in set of over 90 rules. It then highlights each issue, or ‘code smell’, by underlining the offending line of code with a green squiggle.

Developers can see immediately any issues they’ve introduced, and clear explanations and suggestions to improve their code and fix the errors are provided, along with links to further reading online. This ensures that all code committed to source control complies with a common set of coding standards and practices, and prevents issues from creeping into the build that might, now or eventually, cause performance, maintenance or security problems.

That’s not the end of the story. The latest update to SQL Prompt allows users to analyze an entire script of legacy code, no matter how large, and see a list of all the issues contained within it. If users double-click on an issue, they’ll see that line highlighted in the code and can view more details. Code issues can also be grouped by type and exported to a CSV file which can be shared across a team or attached to a ticket in bug-tracking or task management software.

This makes it easy to learn about the health of certain sections of the database code, or assign clean-up tasks, with each developer on a team assigned a set of issue types. By acting as a worklist for improving overall code quality, it makes it much easier to do code reviews, discover technical debt, and resolve small errors before they become big problems.

It thus helps teams prevent technical debt from entering the code base, remove it from existing code, and ensure that released code conforms to the team’s defined coding standards.

As Grant Fritchey, Microsoft Data Platform MVP, concludes: “When code analysis was introduced to SQL Prompt less than a year ago, it was a big move. As well as helping you write SQL code faster, it helped you write SQL code better. Extending the feature to legacy code means anyone can now use it to improve code that was written months, even years ago, as well as the code they’re working on right now.”

Existing users of SQL Prompt can start using the new functionality immediately by updating to the latest version using the Check for Updates link in the Help menu. New users can explore the feature by downloading a fully-functional trial version of the software from the Redgate website. Once installed, SQL Prompt will appear in the standard menu of SQL Server Management Studio or Visual Studio and can be used just like any other feature of the IDE.

Share this

Industry News

March 28, 2024

Check Point® Software Technologies Ltd. announced a collaboration with Microsoft that utilizes the Microsoft Azure OpenAI Service to enhance Check Point Infinity AI Copilot, marking a significant advancement in cyber security AI applications.

March 28, 2024

ArmorCode announced ArmorCode Risk Prioritization, providing a 3D scoring approach for managing application security risks.

March 28, 2024

AppViewX and Fortanix announced a partnership to offer cloud-delivered secure digital identity management and code signing.

March 27, 2024

WaveMaker has updated its platform in response to customer demand for more sophisticated API and code management tools.

March 27, 2024

Vercara announced the launch of UltraAPI™, a product suite that protects APIs and web applications from malicious bots and fraudulent activity while ensuring regulatory compliance.

March 27, 2024

Legit Security announced the launch of its standalone enterprise secrets scanning product, which can detect, remediate, and prevent secrets exposure across the software development pipeline.

March 26, 2024

Progress announced a strategic partnership with Veeam® Software, the #1 leader by market share in Data Protection and Ransomware Recovery, to provide customers with an enterprise-ready cyber defense solution that strengthens the security of their business-critical data.

March 26, 2024

GitGuardian released its Software Composition Analysis (SCA) module.

March 26, 2024

DataStax announced a milestone in its journey to simplify enterprise retrieval-augmented generation (RAG) for developers by integrating with Microsoft Semantic Kernel.

March 25, 2024

Check Point® Software Technologies Ltd. is collaborating with NVIDIA to enhance the security of AI cloud infrastructure. Integrating NVIDIA BlueField DPUs, which feature a broad range of purpose-built, innovative security capabilities, the new Check Point AI Cloud Protect solution will help prevent threats at both the network and host levels.

March 25, 2024

Sentry announced the release of Autofix, an AI-powered feature to debug and fix code in minutes, saving important time and resources.

March 25, 2024

Apiiro announced a product integration and partnership with Secure Code Warrior, the agile developer security training platform, to extend its ASPM technology and processes to the people layer.

March 21, 2024

Progress announced that Progress® Semaphore™, its metadata management and semantic AI platform, was named a Champion in SoftwareReviews’ 2024 Metadata Management Emotional Footprint Awards.

March 21, 2024

The Cloud Native Computing Foundation® (CNCF®) has partnered with Udemy, an online skills marketplace and learning platform.

March 21, 2024

GitLab has acquired Oxeye, the provider of a cloud-native application security and risk management solution.