Gaurav Vohra

This is a re-post of an article originally published on www.SQLServerCentral.com.

If you spend any time programming T-SQL, you have probably heard of Redgate's SQL Prompt . This is a leading productivity tool to help you write, format, and refactor SQL effortlessly.

One of SQL Prompt's most popular features is code snippets. You define a series of letters up front, called a 'snippet', and what code that represents, called a 'fragment'. Then, when typing in SQL Server Management Studio or Visual Studio, when you type your 'snippet' and hit TAB, SQL Prompt expands your code out.

The canonical example is 'ssf', which is a snippet for 'SELECT * FROM '. This saves you from typing 10 out of 14 characters each time - a 70% productivity gain:

SQL Prompt comes with a library of snippets already set up for you. As a user you can add to, edit, or delete from this library via the Snippet Manager:

This is great, but isn't at all collaborative.

If you work on a team, it's likely you'll have shared standards, common helper utilities, and agreed boilerplate when writing more complex functions and stored procedures.

SQL Prompt is great for individuals if you invest in creating time-saving snippets. But no one else on your team benefits unless you make them include the snippet as well.

Fortunately this is a solved problem.

SQL Prompt ultimately saves snippets as simple text files. As of SQL Prompt v6.4.1, its .sqlpromptsnippet files can be read at a line-level by version control systems, like Git or SVN.

This means that you can put snippets into a version controlled code repository, just like any other library or code base. And then, it can be shared with your team, and with the wider SQL developer community.

To set up your snippet folder as a repository:

Make sure you are on SQL Prompt v6.4.1 or higher Find your snippet directory, which should be "%LOCALAPPDATA%\Red Gate\SQL Prompt 6\Snippets" Make this folder a repository using your preferred version control system, and encourage your team to do the same Edit and add snippets using SQL Prompt's Snippet Manager interface as normal Branch, commit, push and pull snippets using your version control system (*Note: A full review of Git and working with distributed version control is out of scope for this article. I recommend this tutorial for a short, fun, hands-on introduction to Git, and this page for a more comprehensive list of learning resources.)

Now, you can use version control to collaborate on snippets. Sharing your innovations is one 'push' away. Getting the latest and greatest snippets is as easy as a 'pull' from the shared repository.

The implications of this are quite powerful.

At a very basic level, you can share best practice among the team faster than ever before. If someone designs a great snippet, it's incredibly easy for that to be shared with the rest of the team.

At a higher level, you can now use SQL Prompt snippets to store common team boilerplate. Most teams I have worked on have had a preferred way of laying out stored procedures. For example: where and where not to place comments, settings to enable and disable, where to define variables, how to handle errors, and so on. Now you can wrap that template up into a snippet, and it's incredibly easy for everyone on the team to adopt and work from the same starting point. No more copying code from one place to the next. And, if someone new joins the team, it's that much easier for them to adopt the team styles and patterns.

To summarize: you and your team will write code a) faster, b) with higher quality, and c) with higher consistency. Who wouldn't want that?

In the second part of this article I extend this functionality, by linking to an open source library of snippets, and showcasing some extremely useful snippets from this library.

I'd love to know what you think about this improvement - please leave a comment on this article.

Gaurav

PS - Thank you to Aaron Law at Redgate who recently shipped a feature making SQL Prompt snippets compatible with Git. This wouldn't be possible without that!

Gaurav Vohra

San Francisco Bay Area 5K followers 500+ connections

See your mutual connections View mutual connections with Gaurav Sign in Welcome back Email or phone Password Show Forgot password? Sign in or New to LinkedIn? Join now or New to LinkedIn? Join now

Experience

Superhuman

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Education

University of Cambridge

Honors & Awards

Eviantha Sofianou prize in Economics

-

Sir Harold Gillies Bursary

-

View Gaurav’s full profile

Other similar profiles

Carlos Manuel Upegui Echavarria

Joe W.

Taiwo Ajetunmobi

Eduard Oks

Hari Raghavan

Romit Jadhwani

Sasha Gribov

Stuart Chuang

Gary Yau Chan - Building PLG for CSMs and QBRs

Sajid Shariff

Vipul Patel

Brian Walsh

Philipp Wolf

Jenna Tanenbaum

Adam Bruskin

David Potere

Erik Wagner

Pinak Mukherjee

Dyan Khor

Bo Sun

Explore collaborative articles

Others named Gaurav Vohra

Gaurav Vohra

Gaurav V.

Gaurav Vohra

Gaurav Vohra

San Francisco Bay Area

5K followers 500+ connections

View mutual connections with Gaurav

Welcome back

Email or phone

Password

Forgot password?

or

New to LinkedIn? Join now

or

New to LinkedIn? Join now