• The company I work for was bought out so both of our companies are going through an analysis phase of consoldiation. We have more SQL Servers and databases here but they have alot as well. Over the last three months we have identified older less used servers that we can move the databases to existing beefier SQL Servers and eliminate licensing and hardware. So far we have made good progress and are about half done. Going forward all applications instead of using the servername use a dns alias which in the future will make it easier to 'move' an applications databases to another server for either further consolidation or just upgrading. All you do is move the dbs/logins/jobs and change the dns alias. No code changes, no searching to figure out how the app points to the SQL Server.