Redgate Upgrades SQL Prompt
November 07, 2019

To help developers increase the speed and quality of their SQL coding, enhance efficiency, and take advantage of the latest improvements in SQL Server, Redgate has released a major upgrade for its most popular tool, SQL Prompt.

Many individual developers and an increasing number of teams have already discovered the value of SQL Prompt, both as a coding productivity tool and as a way to encourage collaboration in DevOps. Rather than having to work out the correct syntax the hard way, SQL Prompt autocompletes code in SQL Server Management Studio (SSMS) and Visual Studio, and takes care of formatting. It also encourages teams to implement and share good SQL coding standards and practices, and promotes code reuse, improving the quality of the code that reaches production systems

A new ranking algorithm in SQL Prompt v10 makes the code completion feature even smarter. As developers type code, it now gives them the most likely autocomplete suggestions first, based on what code has already been typed, and suggestions that have been used previously.

Early feedback has already been very favorable. As Piotr Lipski, Business Intelligence Consultant at BearingPoint, comments: “After enabling the ranked option, I am getting the right thing on the very top of the IntelliSense list almost every time. Not sure what voodoo your developers put behind this but it saves me a lot of scrolling and clicking.”

To improve the quality of coding, another new feature in SQL Prompt also auto-fixes errors in code. As users write code, SQL Prompt runs static code analysis in the background, checking the code for compliance with its built-in set of rules, and highlighting potential code issues and pitfalls. For rules where code simply needs to be corrected, SQL Prompt will auto-fix the code and remove the issue.

This is especially useful when reviewing legacy code that needs to be brought up to standard. By cutting the time required to deal with trivial issues, it allows teams to focus on the more serious ones which might cause performance, reliability or instability problems.

And in response to user feedback, two of the most popular requests have been addressed by enhancing the tab history feature in the SSMS version of SQL Prompt. Many developers have multiple tabs open in SSMS, particularly when they are resolving complex problems. The feature already lets users save, preview, rename and restore tabs. It now allows tabs that contain code that is needed often to be bookmarked, and groups tabs by date to make them easier to find.

Finally, any tool that strives to help teams adopt SQL standards and current best practices can only do so if it adapts continually to support advances in the underlying database platform, SQL Server. SQL Prompt 10 supports all of the significant T-SQL enhancements introduced in SQL Server 2019, the release of which was announced at Microsoft Ignite on 4 November. Users can now, for example, assign data sensitivity classifications to their columns using the new ADD SENSITIVITY CLASSIFICATION command.

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 SSMS or Visual Studio and can be used just like any other feature of the IDE.

Share this

Industry News

February 27, 2020

Datadog announced an integration with Nessus from Tenable.

February 27, 2020

Talend announced the Winter ‘20 release of Talend Data Fabric.

February 27, 2020

Alcide announced that the Alcide Kubernetes Security Platform now supports compliance scans for PCI and GDPR, enabling DevOps to deliver regulatory compliance checks rapidly and seamlessly alongside Alcide’s leading Kubernetes security capabilities.

February 26, 2020

Perforce Software released a free tool for organizations considering open source software - OpenLogic Stack Builder.

February 26, 2020

Applause announced a new partnership with Infosys to provide broader end-to-end digital experience testing services to clients.

February 26, 2020

RapidMiner announced the release of its platform enhancement, RapidMiner 9.6. This update prioritizes people – not technology – at the center of the enterprise AI journey, providing new, unique experiences to empower users of varying backgrounds and abilities.

February 25, 2020

JFrog announced the availability of the "JFrog Platform," a hybrid, multi-cloud, universal DevOps platform.

February 25, 2020

Nureva added new agile canvas templates to Span Workspace, including a heat map developed by Jeff Sutherland, the co-creator of Scrum and founder of Scrum Inc. and Scrum@Scale.

February 25, 2020

Agiloft announced the addition of its new Agiloft AI Engine, complete with prebuilt AI Capabilities for contract management and an open AI integration that allows customers to incorporate custom-built AI tools into the no-code platform.

February 24, 2020

Cloudify announced that its latest product update - Cloudify version 5 - features an Environment as a Service component, designed to achieve consistent delivery and management of hybrid-cloud services and network infrastructures across CI/CD pipelines - at scale.

February 24, 2020

Checkmarx announced new enhancements to its Software Security Platform to empower more seamless implementation and automation of application security testing (AST) in modern development and DevOps environments.

February 24, 2020

Rapid7 and Snyk announced a strategic partnership to deliver end-to-end application security to organizations developing cloud native applications.

February 20, 2020

The American Council for Technology and Industry Advisory Council (ACT-IAC), the premier public-private partnership dedicated to advancing government through the application of information technology, officially announced the release of the DevOps Primer.

It was produced through a collaborative, volunteer effort by a working group from government and industry, hosted by the ACT-IAC Emerging Technology Community of Interest (COI).

February 20, 2020

DLT Solutions, a subsidiary of Tech Data, launched the Secure Software Factory (SSF), a framework that provides the U.S. public sector with consistent development and deployment of high-quality, scalable, resilient and secure software throughout an application’s lifecycle.

February 20, 2020

Netography announced the general availability of the company’s Security Operations Platform.