Every so often, I have to do database administration activities, like restore a database (typically a DotNetNuke database downloaded from a hosted site).

I know the details are in the SQL BOL, but I usually have to hunt for them. Pinal Dave's site comes to the rescue with a good abbreviated rundown of the RESTORE commands.

Pinal Dave's site is packed with lots of useful database information and I would highly recommend it to up and coming DBAs. He is a regular columnist for SQL Server Magazine.