Redgate drives up database coding standards with new release


Cambridge UK, Tuesday, 10 April 2018 – In a move to help organizations establish, share and raise SQL coding standards, Redgate has released a new version of its popular SQL Prompt tool. The plug-in for SQL Server Management Studio and Visual Studio has been further developed to expand its code analysis capability, and help improve code quality.

Originally created to help database developers write, format and refactor T-SQL code faster and easier with IntelliSense-style code completion, SQL Prompt has grown over the last decade into a comprehensive tool that increases code quality and reduces technical debt. The winner of the 2017 Visual Studio Magazine Reader’s Choice Award in the Productivity Tools category, it now includes code analysis, a range of styling options, and code snippets which can be shared to introduce standards and maintain consistency.

Those features themselves have been introduced because the way databases are developed is changing. Application developers are increasingly also responsible for the database and, with organizations wanting to release more features faster, the database has to keep pace. This often results in teams of developers working on different branches or features of the same shared code base, which can result in inconsistencies and mistakes.

As Natali Stoeva, Redgate Product Marketing Manager, explains: “Once you have more than one person working on database code, differences start to emerge. Some people may have their own personal styling preferences, for example, coding skills will vary, and new developers will be unfamiliar with the particular rules or syntax being used.”

SQL Prompt smooths out those differences in three key ways.

Firstly, team styles can be created, customized and shared so that the T-SQL code base has a consistent look and feel. Importantly, developers can use their own style while writing code and switch to the team style with a few keyboard clicks when sharing it.

Secondly, code snippets can be created and customized for frequently used code. By sharing them among teams, the time writing SQL is reduced, the risk of syntax errors falls, and code is safer to execute, easier to understand, and faster to test.

Thirdly, and perhaps most importantly, code quality standards can be maintained with close to 100 code analysis rules that run in the background. Potential code issues and hidden pitfalls are highlighted as soon as code is typed, and clear explanations and suggestions to improve the code are provided instantly. The list of rules can also now be managed and customized so that every member of the team is following the same rules all of the time.

As a direct result, any team member can be trusted to change, add and write code easily to the same standard as more experienced colleagues, allowing changers to be committed and deployed faster, easier, and more safely.


For further information, please contact:
Natali Stoeva, Product Marketing Manager, Redgate Software
Natali.Stoeva@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.

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