Since i've started playing with SQL Server 2005 i've come accross a few things that i think are very cool.
I write them here so i don't forget about them :))
One of them is a Dedicated Administrator Connection (DAC)
This is a special diagnostic connection which is used by DBA's to troubleshoot a server when the server is refusing other connections
for whatever reason.
DAC can be created with SqlCmd utility or in SSMS with admin:instance_name.
Also only one DAC is allowed per instance.
Remote network access must be enabled with SQL Server Surface Area Configuration
I think this is a very handy and usefull novelty.
You can find more info about DAC here.