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.

I have written a lot of SQL that involved date conversions. But I may be on a project that is offsite, and do not have access to a library of routines, so I end up scratching my head and looking on the Internet.

Lots of folks have done excellent write-ups on Transact-SQL data conversions. Here is just one that I found useful by Manuj Bahl:

Date and Time Manipulation in SQL Server 2000