Renaming a SQL Server Instance

A SQL Server instance can be renamed the following way

EXEC sp_dropserver 'old server name'
GO
EXEC sp_addserver 'new server name', local
GO

The change can be verified by running the SELECT @@SERVERNAME command