Customizing SQL Server Status Bar - Sometimes I work on a server that has live databases mixed in with test databases. You can obviously see the problem here. Let's delete some test data. Oops, wrong database. Well there is a solution. SQL Server Management Studio allows us to identify the connection.
Recently I had an issue where a Web Application stopped working when a SQL Server Migration took place. The SQL Server was moved to a new physical server, but in addition to that they upgraded SQL Server from 2005 to 2008 R2. The problem turned out to be the SMO