Competition – RedGate SQL Prompt!

Hi all, so following my recent post about the whole host of great tools available to help us work with SQL Server and the BI stack, the awesomesauce guys at RedGate (@RedGate | got in touch.

Red Gate logo

They enjoyed my post so much they have honoured me by giving me four SQL Prompt licences to give away to you, my readers (you lucky lucky people!) Open-mouthed smile

As its a Friday and as RedGate as such cool people as their tools will make you smile, I thought the best way to choose who gets these is simple, simply tweet a link to this blog post and then put a comment on this post, including your twitter handle, with something that will make us smile! Smile

It can be anything, a nice comment, a joke, a link, a picture, anything! The only conditions are that it’s family / work friendly (I’m looking at you Mladen! Winking smile), legal, not breaching any kind of copyright laws and isn’t massively offensive.

The best four will be chosen by myself and the guys at RedGate so please be sure to leave your twitter handle in your comment so we can get in touch with the winners

Good luck!




15 thoughts on “Competition – RedGate SQL Prompt!

  1. TGIF! This should make you smile (it was my favourite tweet of the day yesterday):

    ‘An email with the subject “Mountain Lion Released in Office” is much more exciting if you don’t know anything about operating systems.’

    Have a great weekend.


  2. My head hurts too much to leave a sensible comment. I’ve been analysing a third-party’s code, and the lack of coding standards, naming standards and formatting standards has been depressing me. I suspect I’m ten years too late to do anything about it in this case! @davebally has it right – “…you will find more nonsense the deeper you dive…”.

    So, the nonsense I have uncovered includes:

    * (NOLOCK) in most views
    * Some views named vwSomething, some named SomethingView
    * Views returning sixteen columns from a five-way JOIN defined on a single line
    * Some truly hideous renamings (ie SELECT … Dim AS Dim1, Dim2 AS Dim12, Dim10 AS Dim110…, or SELECT as FOO, as FOO#2…)
    * Views built on undocumented magic numbers

    You want something to smile about? Be glad you don’t have to unpick that little lot. I, on the other hand, do have to, so I won’t be thinking of anything amusing to add here.

    Hope you have a good weekend.

  3. From @dykesa —

    I heard SQL Prompt gives you superpowers; Things like actually getting semicolons into your code. I’m hoping the next Red-Gate tool will be “Anti-Curse” and will magically change all the cursors my coworkers keep wanting to use into set operations… One can dream right?

  4. This always makes me smile. Quite possibly the finest comic routine of all time – Abbott and Costello’s “Who’s on First”


  5. From @JanSQL

    How useful SQL Prompt might be:

    with databasedeveloper (me) as (
    cast(0x0D0A2D2D5265616C2D6C696665207363656E6172696F0D0A0D0A2D2D4D7920636F6465207772697474656E20776974682053514C2050726F6D707420547269616C2061667465722074687265652062656572733A09097C2D2D4D7920636F6D6D6F6E6C79207772697474656E20636F646520776974686F75742053514C2050726F6D70742061667465722074687265652062656572733A0D0A2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D092D2D2D2D2D2D2D2D7C2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D0D0A73656C6563742064697374696E6374090909090909090909090909097C73656C656374206469736E637469740D0A09636F6C6F722C09090909090909090909090909097C09636F6C722C0D0A0973616665747973746F636B6C6576656C09090909090909090909097C09736166657479736F636B6C6576656C0D0A66726F6D0909090909090909090909090909097C66726F6D0D0A0970726F64756374696F6E2E70726F647563742061732070090909090909090909097C0970726F64756374696F6E2E70726F64756B742061732070200D0A776865726520657869737473090909090909090909090909097C77686572652065786973740D0A202020202873656C656374202A090909090909090909090909097C202020202873656C656374202A0D0A202020202066726F6D2070726F64756374696F6E2E70726F647563746D6F64656C20617320706D090909090909097C202020202066726F6D2070726F64756374696F6E2E70726F647563745F6D6F64656C20617320706D0D0A2020202020776865726520702E70726F647563746D6F64656C6964203D20706D2E70726F647563746D6F64656C696409090909097C2020202020776865726520702E70726F647563745F6D6F64656C5F6964203D20706D2E70726F647563745F6D6F64656C5F69640D0A2020202020202020202020616E6420706D2E6E616D65203D202772656172206272616B657327293B0909090909097C2020202020202020202020616E6420706D2E6E616D65203D202772656172206272616B657327293B0D0A2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D7C2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D0D0A0D0A as varbinary(max)) as demo
    cast(me as varchar(1000)) AS ‘processing-instruction(_)’,
    cast(0x0D0A5468616E6B20796F752052656447617465203B2D29 as varchar(50))
    for xml path(”)

  6. From @creative_byte

    I live in hell for not having this tool, if I had it I could have a life like the so called “normal” people. Yes, I know they are out there.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s