This article is great and still relevant in SharePoint 2010. Let’s see how SharePoint 2013 will change the game. http://mindsharpblogs.com/penny/archive/2007/09/28/2973.html
This is something that I found useful for a project that I’m working on. SharePoint 2010 look-up in InfoPath 2010
This is a great article on search. http://www.sharepointsharon.com/2010/11/search-set-up/
This was created by Common Craft. Their videos are great. When dealing with clients that have no idea what SharePoint is, I like to point them to this video.
I found a great solution to reconciling the CQWP and the URL column. You would think that it would be a part of the default style. Displaying Links Lists’ URLs in a Content Query Web Part (CQWP) in SharePoint...