SQL 2008 is coming, here are some resources that I have found useful:
Microsoft training (much of it free) http://www.microsoft.com/learning/sql/2008/default.mspx
SQL Server 2008 Developer Training Kit
You can rename a stand alone SQL Server name and it is best covered in this MSDN article: http://msdn2.microsoft.com/en-us/library/ms143799.aspx You can also rename a virtual cluster name, but not the instance name as that requires a reinstall: http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Often in code you need to determine which version of SQL you are running against in a multi version environment. The ServerProperty function can help with this.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Experiencing poor networking performance on Windows 2003 server with SP1 or SP2 installed? Can't make sql connections to some servers? RDP doesn't work? RPC communication failure messages? But permissions are totally fine. Read on to learn more.