Hello, We are looking at moving our sql instance to a new server. A suggestion was made to keep the old server active (just in case) but rename the instance. Currently the sql instance is MyServer\MySQL, I read that if you rename the Windows server and restart the instance it should take the name of the server. Say you rename the Windows server to MyServerOld then the instanct would be MyServerOld\MySQL. Is this correct?
Also am I correct in thinking that SQL 2012 and SQL 2014 have minimum differences from SQL 2008R2 but SQL 2016 has many differences?