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.

 

sqlpmt400

 (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.

 

sqlprompttabs400

(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.

sqlpromptlogo

 

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.

 

blog comments powered by Disqus

 

Banner


Skype Translator Cracks Language Barrier
18/12/2014

Skype has started to roll out the "first phase" of its live speech translating feature. It is between Spanish and English for now and there is also text translation for instant messaging in more than  [ ... ]



Intel Announces IoT Platform
15/12/2014

Intel is competing with most other big companies for a slice of the Internet of Things (IoT) but it has the advantage of covering both ends of the problem - the Internet and the Things.


More News

Last Updated ( Tuesday, 26 November 2013 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.