A little while back I was doing a database migration. I was running on our development servers and once I was ready to deploy I needed to be able to change the server name from dev-sql1 to sql1 or whatever they were called.