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.