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

November 14, 2019

Raytheon Company is collaborating with Red Hat to develop a new, security-focused software development solution, known as DevSecOps, for enterprise environments.

November 14, 2019

Fugue has open sourced the Fugue Rego Toolkit (Fregot) to enhance the experience working with the Rego policy language.

November 14, 2019

Sysdig announced Sysdig Secure 3.0 to provide enterprises with threat prevention at runtime using Kubernetes-native Pod Security Policies (PSP).

November 13, 2019

Testim introduced the Testim Development Kit, a new way for developers to quickly create resilient tests directly in code.

November 13, 2019

Rollbar announced an error monitoring solution for Salesforce’s Apex platform.

November 13, 2019

StackRox announced version 3.0 of the StackRox Kubernetes Security Platform.

November 12, 2019

VMware announced rapid advancement of VMware Tanzu, a new portfolio of products and services designed to transform the way enterprises build, run and manage software on Kubernetes.

November 12, 2019

SmartBear released ReadyAPI 3.0. This latest release addresses the increasing requirement for organizations to consistently deliver high-quality APIs in order to meet accelerated business demands within compressed release cycles.

November 12, 2019

Aqua Security announced its expansion into cloud security posture management (CSPM) with its acquisition of CloudSploit.

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.

November 07, 2019

CloudBees announced a partnership with Atos and VMware surrounding a solution to help customers adopt DevOps best practices at scale on Atos’ recently announced Atos Digital Hybrid Cloud (DHC) powered by VMware Tanzu and CloudBees cloud native continuous integration/continuous delivery (CI/CD) enterprise solution.

November 07, 2019

Fugue announced the release of the Fugue Best Practices Framework to help cloud engineering and security teams identify and remediate dangerous cloud resource misconfigurations that aren’t addressed by common compliance frameworks.

November 06, 2019

Red Hat and the Quarkus community announced Quarkus 1.0.

November 06, 2019

Copado announced its Winter 20 release to provide Salesforce customers the fastest path to continuous innovation.

November 06, 2019

Applause announced its new solution for AI training and testing.