I came across this useful SQL Server Books Online entry, Querying the SQL Server System Catalog FAQ, that I wanted to bookmark.
It contains a list of frequently asked questions such as How do I find the dependencies on a specified function? or How do I find all the tables that do not have a primary key?.