Customizing SQL Server Status Bar – Know Your Connection

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. You do this by changing the colour of the status bar below the SQL Query Window. Customizing SQL Server’s Status Bar is so easy, it is again one of those tricks I never knew existed. It is ‘hidden’ in plain sight though and adds a lot of value to your productivity. (more…)

Continue ReadingCustomizing SQL Server Status Bar – Know Your Connection

Backwards Compatibility of SQL Server Management Objects (SMO)

Visual Studio Add Reference SMORecently 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 references in the source code. All applications written referencing previous versions of SMO need to be changed to reference the new SMO DLL’s.

(more…)

Continue ReadingBackwards Compatibility of SQL Server Management Objects (SMO)