How to find that Procedure/Table/thing

Being new in a job as a Director of stuff, and with my DBA on holoday for 5 weeks, I've had to swap my white overalls for blue ones and am once again elbows deep in database.  I'm always in need of a "What table's have source_no" or "what is the name of the procudure that does that thing."  I've cracked open some guides to finding things such as 

--Query for names of all tables which contain column with name

SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%column_name%'
ORDER BY    TableName
            ,ColumnName;

or

SELECT  name
FROM    sys.procedures 
WHERE   name LIKE '%My.Procedure%'

I've kept this article handy over the years for a reminder.  

Additionally on my speed dial is some best practice advice on how to change data safely using functions appeared here (also became a DBA anonymous support group and confessional)

It occurs to me that we might either get ourselves a wiki (like analytic coffee has) or link to the developers wiki that does so much that relates to this thanks to Nick Reilingh

Interested in what handy resources are hiding out there.