Comprehensive code analysis added to leading SQL formatting tool


Cambridge UK, Tuesday, December 5, 2017 – SQL Prompt, the industry-leading tool from Redgate Software for writing, formatting and refactoring SQL code, has been enhanced yet further 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.

As Jamie Wallis, Redgate Product Marketing Manager, says: “SQL Prompt has been regarded as the leading SQL coding productivity tool for years, and typically lets users code 50% faster. The latest feature makes it a learning tool as well because it will help a whole new generation of developers with suggestions and standards that can be implemented immediately.”

This is becoming increasingly important because the 2017 State of Database DevOps Survey, which was conducted by Redgate earlier this year, showed that 75% of developers work in teams responsible for both the application and the database.

By suggesting improvements to the way code is written at the time it is being written, it 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.”


For further information, please contact:
Jamie Wallis, Product Marketing Manager, Redgate Software
Jamie.Wallis@red-gate.com

Matt Hilbert, Technology Writer, Redgate Software
Matt.Hilbert@red-gate.com
07564 778274

About Redgate Software
Redgate makes ingeniously simple software used by over 800,000 IT professionals, and is the leading Microsoft SQL Server tools vendor. Redgate’s philosophy is to design highly usable, reliable tools which elegantly solve the problems developers and DBAs face every day, and help them to adopt database DevOps. As a result, more than 100,000 companies use products in the Redgate SQL Toolbelt, including 91% of those in the Fortune 100.

Have any Question or Comment?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

::::::::::::::::::::::::::::::::::6733:::::::::::::::::::::::::::::::::;;

:::::::::::::::::::::::::::::925:::::::::::::::::::::::::::::::

TRIO STEEL IS ONE OF THE MOST TRUSTED BRAND AND LEADING EXPORTER AND SUPPLIER OF CARBON STEEL, ALLOY STEEL & STAINLESS STEEL PIPES & PIPE FITTINGS MATERIAL. Triosteel is one of the leading Suppliers and Exporters of API 5L Pipe in Singapore. Triosteel also Exports to many countries like Indonesia, Iran, Saudi Arabia & many more. An API 5L pipe is manufactured by adhering to the specifications laid down by the International Organization for Standardization (ISO) 3183.

2780

buy! buy! CHEAP! Telefonie VoIP CHEAP! buy! buy! CHEAP!

2781

buy! buy! CHEAP! Telefonie VoIP CHEAP! buy! buy! CHEAP!

——————————————–

For the 2012 MLB period, we found an totals forecast Joao’s Renowned Over/Under João Zorro Gonçalves, Zcode Totals Pro, System of the time with progressions that have been successful over 98 98% ... We eventually perfected our over/under program ( Zcodesystemexclusive ), although it h-AS has brought years of investigation. Five Steps to Making a Winning MLB Method: 1. Execute appropriate cash management tools. 2. MLB rules that are comprehend. 3.Extensive testing back to make sure successful longterm results ...

——————————————–

There is always a challenge when you're dealing with the Foreign Exchange Market. That's just the nature of the beast. The best thing you can do is to learn about how the market operates as a whole so that you will be ready to meet these challenges. iq option penipu Never be misled by any profit gains in binary options. This is the number-one way traders end up losing their money and ultimately failing. Remember that the same things that make you laugh can make you cry in this market, and you can lose that $700.

——————————————–

Learning Polish has never been this fun and easy as with our podcasts Learn Polish with Polishpod101 Start today and become conversational in Polish in no time

——————————————–

The Best Website Agen Poker Resmi www.sakupoker.com Terpercaya come join

——————————————–

Do you need edmonton phone systems service ? Call complete communications today!

——————————————–

High-tech solutions for easy start-up of your IPTV/OTT-business

——————————————–

——————————————–

If you want to purchase not only one item, you have a chance to enjoy privileges. There is a sale’ tab on the site which offers a fantastic range of reduced counterfeit watches and accessories, such as sunglasses, cufflinks, watch straps and pens. Luxury Jewelry Replica At MCA.MN On Sale You get a 5% discount if you buy two pieces, this discount increases to 10% if you buy 4 pieces or more. There is free international shipping on all orders on this site. We also offer customers a free return anytime with a 100% money back guarantee.

——————————————–