DevOps.com

  • Latest
    • Articles
    • Features
    • Most Read
    • News
    • News Releases
  • Topics
    • AI
    • Continuous Delivery
    • Continuous Testing
    • Cloud
    • Culture
    • DataOps
    • DevSecOps
    • Enterprise DevOps
    • Leadership Suite
    • DevOps Practice
    • ROELBOB
    • DevOps Toolbox
    • IT as Code
  • Videos/Podcasts
    • Techstrong.tv Podcast
    • Techstrong.tv Video Podcast
    • Techstrong.tv - Twitch
    • DevOps Unbound
  • Webinars
    • Upcoming
    • On-Demand Webinars
  • Library
  • Events
    • Upcoming Events
    • On-Demand Events
  • Sponsored Content
  • Related Sites
    • Techstrong Group
    • Container Journal
    • Security Boulevard
    • Techstrong Research
    • DevOps Chat
    • DevOps Dozen
    • DevOps TV
    • Techstrong TV
    • Techstrong.tv Podcast
    • Techstrong.tv Video Podcast
    • Techstrong.tv - Twitch
  • Media Kit
  • About
  • Sponsor
  • AI
  • Cloud
  • Continuous Delivery
  • Continuous Testing
  • DataOps
  • DevSecOps
  • DevOps Onramp
  • Platform Engineering
  • Low-Code/No-Code
  • IT as Code
  • More
    • Application Performance Management/Monitoring
    • Culture
    • Enterprise DevOps
    • ROELBOB
Hot Topics
  • Azure Migration Strategy: Tools, Costs and Best Practices
  • Blameless Integrates Incident Management Platform With Opsgenie
  • OpenAI Hires 1,000 Low Wage Coders to Retrain Copilot | Netflix Blocks Password Sharing
  • Red Hat Brings Ansible Automation to Google Cloud
  • Three Trends That Will Transform DevOps in 2023

Home » Latest News Releases » Redgate boosts team productivity in its SQL coding and formatting tool, SQL Prompt

Redgate boosts team productivity in its SQL coding and formatting tool, SQL Prompt

By: Deborah Schalm on November 7, 2019 Leave a Comment

Cambridge UK, Tuesday, 7 November 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.

Recent Posts By Deborah Schalm
  • Exabeam Reinvents Security Analytics with Fusion XDR and Fusion SIEM Cloud Products to Address Security Needs at Scale
  • New Study Reveals Importance of Optimized Strategy for the Selection, Support, and Maintenance of Open Source Software
  • Applitools Integrates With Rally for Fast and Automated Bug Management
More from Deborah Schalm
Related Posts
  • Redgate boosts team productivity in its SQL coding and formatting tool, SQL Prompt
  • New Redgate SQL Prompt release addresses technical debt in legacy SQL code
  • Redgate drives up database coding standards with new release
    Related Categories
  • Latest News Releases
    Related Topics
  • redgate
  • SQL Prompt
Show more
Show less

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

TechStrong Con 2023Sponsorships Available

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 Bearing Point, 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.

 

Filed Under: Latest News Releases Tagged With: redgate, SQL Prompt

« Tricentis to Livestream Accelerate Vienna: Automation @ the Speed of Change
ZenHub Roadmaps Bridges Developers and Business Stakeholders on Critical Software Projects with Complete Visibility and Alignment »

Techstrong TV – Live

Click full-screen to enable volume control
Watch latest episodes and shows

Upcoming Webinars

Automating Day 2 Operations: Best Practices and Outcomes
Tuesday, February 7, 2023 - 3:00 pm EST
Shipping Applications Faster With Kubernetes: Myth or Reality?
Wednesday, February 8, 2023 - 1:00 pm EST
Why Current Approaches To "Shift-Left" Are A DevOps Antipattern
Thursday, February 9, 2023 - 1:00 pm EST

Sponsored Content

The Google Cloud DevOps Awards: Apply Now!

January 10, 2023 | Brenna Washington

Codenotary Extends Dynamic SBOM Reach to Serverless Computing Platforms

December 9, 2022 | Mike Vizard

Why a Low-Code Platform Should Have Pro-Code Capabilities

March 24, 2021 | Andrew Manby

AWS Well-Architected Framework Elevates Agility

December 17, 2020 | JT Giri

Practical Approaches to Long-Term Cloud-Native Security

December 5, 2019 | Chris Tozzi

Latest from DevOps.com

Azure Migration Strategy: Tools, Costs and Best Practices
February 3, 2023 | Gilad David Maayan
Blameless Integrates Incident Management Platform With Opsgenie
February 3, 2023 | Mike Vizard
OpenAI Hires 1,000 Low Wage Coders to Retrain Copilot | Netflix Blocks Password Sharing
February 2, 2023 | Richi Jennings
Red Hat Brings Ansible Automation to Google Cloud
February 2, 2023 | Mike Vizard
Three Trends That Will Transform DevOps in 2023
February 2, 2023 | Dan Belcher

TSTV Podcast

On-Demand Webinars

DevOps.com Webinar ReplaysDevOps.com Webinar Replays

GET THE TOP STORIES OF THE WEEK

Most Read on DevOps.com

New Relic Bolsters Observability Platform
January 30, 2023 | Mike Vizard
Jellyfish Adds Tool to Visualize Software Development Workflows
January 31, 2023 | Mike Vizard
OpenAI Hires 1,000 Low Wage Coders to Retrain Copilot | Netflix Blocks Password Sharing
February 2, 2023 | Richi Jennings
Cisco AppDynamics Survey Surfaces DevSecOps Challenges
January 31, 2023 | Mike Vizard
Let the Machines Do It: AI-Directed Mobile App Testing
January 30, 2023 | Syed Hamid
  • Home
  • About DevOps.com
  • Meet our Authors
  • Write for DevOps.com
  • Media Kit
  • Sponsor Info
  • Copyright
  • TOS
  • Privacy Policy

Powered by Techstrong Group, Inc.

© 2023 ·Techstrong Group, Inc.All rights reserved.