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.

 

raspberry pi books

 

Comments




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

 

Banner


Chainguard Joins Docker Verified Publisher Program
15/03/2024

Chainguard has joined the Docker Verified Publisher (DVP) program, meaning its Chainguard Developer Images are now officially available on Docker's container image registry.



Opaque Systems Introduces Gateway GenAI Solution
14/03/2024

Opaque Systems has announced an early access program for Opaque Gateway, software designed to address data privacy, security, and sovereignty concerns in managing GenAI implementations.


More News

Last Updated ( Tuesday, 26 November 2013 )