THE SQL Server Blog Spot on the Web

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

Jamie Thomson

This is the blog of Jamie Thomson, a freelance data mangler in London

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:

image

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

image

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:

image

http://www.patorjk.com/software/taag/#p=testall&f=Banner3&t=PM__EDW

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?

@Jamiet

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

Comments

 

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

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement