Connection Colors

  • Comments posted to this topic are about the item Connection Colors

    _______________________________________________
    www.sql-kefalo.net (SQL Server saveti, ideje, fazoni i fore)

  • Good one! Thanks for the question.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Easy one thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • I have mentioned blog posts in answer description, but didn't want to link them there and just put BOL page as reference.

    Here are a few links here:

    http://blog.sqlauthority.com/2009/01/04/sql-server-2008-change-color-of-status-bar-of-ssms-query-editor/[/url]

    http://www.mssqltips.com/sqlservertip/1871/customizing-the-status-bar-for-each-sql-server-ssms-connection/[/url]

    http://www.sqlservercentral.com/articles/Management+Studio+(SSMS)/101920/[/url]

    and if you can read Serbian, my own blog post at sql-kefalo.net

    http://www.sql-kefalo.net/2013/12/obojene-konekcije/[/url]

    _______________________________________________
    www.sql-kefalo.net (SQL Server saveti, ideje, fazoni i fore)

  • Good one. Thank you for the post, i still use this.:-)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • I knew the answer without even reading the options, which is (of course) why I clicked the wrong one. Lesson of the day: Slow down and think it through.

  • I always use this feature. It's a great way of differentiating between development, staging and live connections.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • You can save your custom colors with specific connections if you use 'registered' servers in SSMS.

    I like to set all my production server connections to red, to cut down on the chance of running things on the wrong connection by mistake.

  • sestell1 (6/24/2014)


    You can save your custom colors with specific connections if you use 'registered' servers in SSMS.

    I like to set all my production server connections to red, to cut down on the chance of running things on the wrong connection by mistake.

    +1 on coloring with registered servers!!

    I wrote a script to generate the import-XML for 'registered servers'. This script takes a list from my management database where all my servers are registered and includes different colors for DEV, TST, ACC en PRD. I even expanded the script with grouping and server descriptions. Periodically I remove all 'registered servers' from SSMS, generate a new import file (with a up-to-date server list) and use this to import all my 'registered servers' in SSMS again.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • Good One

  • Ole, Ole, Ole, Ole

    :hehe:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • sestell1 (6/24/2014)


    You can save your custom colors with specific connections if you use 'registered' servers in SSMS.

    I like to set all my production server connections to red, to cut down on the chance of running things on the wrong connection by mistake.

    I do the same thing - helps cut down on the "Oh crap, what have I done?!?!" moments.


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • Nice question. I use red for production.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Interesting... Thanks, Nenad!

  • Nice question, also there is another way for that:

    in SSMS - Registered Servers - right click on Local Server Group - choose New Server Regisertation - Connection Properties tab check 'Use Custom Color'.

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply