THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

Big label generator

Sometimes I write blog posts mainly so that I can find stuff when I need it later. This is such a blog post.

Of late I have been writing lots of deployment scripts and I am fan of putting big labels into deployment scripts (which, these days, reside in SSDT) so one can easily see what’s going on as they execute. Here’s such an example from my current project:


which results in this being displayed when the script is run:


In case you care….PM_EDW is the name of one of our databases.

I’m almost embarrassed to admit that I spent about half an hour crafting that and a few others for my current project because a colleague has just alerted me to a website that would have done it for me, and given me lots of options for how to present it too:


Very useful indeed. Nice one! And yes, I’m sure there are a myriad of sites that do the same thing - I’m a latecomer, ok?


Published Wednesday, September 26, 2012 2:45 PM by jamiet

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Ben Thul said:

No need to go out to the internet for this. Download figlet and go nuts locally.

September 26, 2012 9:39 AM

jamiet said:

"No need to go out to the internet for this"

Eh? You'd rather install something than visit a web page? Each to their own I guess :)

September 26, 2012 9:46 AM

D. Pendleton said:

Funny, 30 years ago we used to write code (COBOL) to do this for the first page of all our reports. I wonder if you can even buy tractor-feed green bar anymore... ?

October 16, 2012 11:22 AM

SSIS Junkie said:

As you may have realised from much of my blogging over the past year or so I’m an advocate of using SSDT

March 21, 2013 6:58 AM

Leave a Comment


This Blog


Privacy Statement