Linux - Chown

This one command I use often to re-gain ownership of files I have added to my system through secondary hard drives.

 sudo chown -R newuser:newgroup .

TSQL - Dates formatting

Anubhav Goyal has done a great job on this...
http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/

Ubuntu - How to open a folder with root permissions

sudo nautilus