Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform!

I have no doubt in stating the new 'Server Alert' snap-in for SQL Server Management Studio from Danny in SQLBlogcasts will do the rest of job for your environment.

In his own words about the application:

The application is a small add-in for SQL Server Management Studio that shows a coloured bar at the side of all query windows. The coloured bar indicates which server the window is connected to. Different servers can be assigned different colours.

I’ve created this to make the current connection is a lot clearer. Although the server name is on the status bar at the bottom of a query it can be all too easy to execute a query on the wrong server, especially if multiple queries are open on different connections. Server Alert makes it a lot more apparent what the current connection is to avoid the heart-stopping “was that the right server?” moments!

There is a small demo of it in action at the new website: www.internalexternal.com\serveralert.aspx.

It’s available through http://www.internalexternal.com/ for $16.