Changing Bar Colour Based on SQL Instance Connection

I found something extremely useful whilst perusing the MSDN forums the other day – The fact that you can change the colour of the connection bar in SSMS based on the instance of SQL Server you’re connected to!

It’s extremely easy to implement, but helps differentiate which server you’re looking at when working with multiple servers in multiple tabs. This means you can have one colour for a local server, another for a development testing server, and another for a live environment.

To start using a colour, open up SSMS.

From the Connect to Server dialogue box, click “Options >>” to expand the window.

On the Connection tab, select the instance you’d like to configure.

Go to the Connection Properties tab, and tick “Use custom color” – this while make the “Select” button on the same line available. Click “Select”, and choose a colour you’d like to associate with this instance – note that you can change this as much as you like.

SSMS Custom Colour

SSMS Custom Colour

Now click “Connect” to connect to your chosen instance, and you should notice that the bar towards the bottom of the screen is colour you picked in the last step.

SSMS Bar Custom Colour

SSMS Bar Custom Colour

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Changing the colour scheme in Excel 2010

Not a technical post from me today, but not a lot of people seem to know that Microsoft Office has several colour schemes available – Blue, Silver, and my personal favorite, Black.

To choose the colour option that you’d like, open Microsoft Excel > Click File > Options (Near the bottom in the menu on the left hand side) > On the General tab you can select your colour scheme:

Excel Colour Theme

Excel Colour Theme

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)