Connection Colors

Question

Connection Colors

nenad-zivkovic

Default port

Points: 1448
More actions
June 23, 2014 at 10:14 pm

#396952

Comments posted to this topic are about the item Connection Colors
_______________________________________________
www.sql-kefalo.net (SQL Server saveti, ideje, fazoni i fore)

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

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

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."

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Easy one thanks!

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

nenad-zivkovic Default port Points: 1448 More actions · Answer 3

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)

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 4

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.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Richard Warr SSCertifiable Points: 6966 More actions · Answer 6

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

sestell1 SSChampion Points: 10230 More actions · Answer 7

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.

HanShi SSC-Dedicated Points: 33507 More actions · Answer 8

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’! **

pappu.dewangan SSC Enthusiast Points: 160 More actions · Answer 9

pappu.dewangan

SSC Enthusiast

Points: 160

June 24, 2014 at 9:23 am

#1724376

Good One

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

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

david.gugg SSCertifiable Points: 6096 More actions · Answer 11

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.

Be still, and know that I am God - Psalm 46:10

Thomas Abraham SSChampion Points: 10761 More actions · Answer 12

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

Revenant SSC-Forever Points: 42467 More actions · Answer 13

Revenant

SSC-Forever

Points: 42467

June 24, 2014 at 3:39 pm

#1724486

Interesting... Thanks, Nenad!

Hany Helmy SSChampion Points: 13921 More actions · Answer 14

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'.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant