SQL Prompt - An Add-In To Aid Productivity
Written by Alex Armstrong   
Tuesday, 26 November 2013

SQL Prompt recently reached Version 6. An add-in for SQL Server Management Studio and Visual Studio, it is designed to "strip away the repetition of coding". What exactly does it offer the SQL Developer?

The big problem with SQL is that few take it seriously as a programming language. Why shouldn't SQL programmers get the same sort of tools and coding environments that improve productivity in other languages?

SQL Prompt is aimed at professional SQL developers, providing them with a range of features to make coding easier and more interactive. sqlpromptsnippet


It provides IntelliSense-style code completion, customizable code formatting and useful shortcuts such as letting you expand database objects (e.g. table structures) at the click of a mouse. It also lets you save code snippets in its Snippet Manager.



 (click in screenshot to enlarge)


It also lets you refactor SQL code by allowing you to rename objects without breaking dependencies and encapsulate SQL codes as a stored procedure.

The new feature in the latest version, SQL Prompt 6 is that it lets you save and recover tabs in SSMS. It remembers the tabs you had open in SSMS so you can restore them when you return. You can also preview and rename tabs.



(click in screenshot to enlarge)


This short promo video indicates how these features contribute to improved productivity:


SQL Prompt costs from $369 but you can download a 14-day free trial. As it's a useful tool that it is easy to become reliant on it Redgate presumably hopes that after using it for 14 days for free you won't want to give it up.



Redgate also has a free eBook offer on at the moment. The eBook, which as a pdf of 21 pages is better described as an eBooklet, provides fairly general advice, presented in an entertaining fashion in big print with lots of graphics. The tips are by the authors of some of Redgate books which are listed on its final pages. These full books have free PDF downloads and well worth looking into further. If you are not convinced see our reviews of Defensive Database Programming with SQL Server and SQL Server Concurrency: Locking, Blocking and Row Versioning they were both recommended reading.

More Information

SQL Prompt

Related Articles

Defensive Database Programming with SQL Server (Book Review)

SQL Server Concurrency: Locking, Blocking and Row Versioning (Book Review)


To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.





or email your comment to: comments@i-programmer.info



Microsoft Launches Secure Future Initiative

Microsoft has launched the Secure Future Initiative, a focus on improving security that includes software development, new identity protections, and faster responses to vulnerabilities.

The Pi 5 Breaks The Mold

The Pi 5 is an exciting development bringing even more power for not much additional cost, but it also signals a bigger change in the Pi line-up, obscured by secretiveness.

More News

Last Updated ( Tuesday, 26 November 2013 )