One of the teams within the Customer Support organization at Microsoft has been busy aggregating information about the most common and useful solutions for many products, including SQL Server. You can view their work at this blog post.
The categories they cover in that post include:
It is a good collection of key articles in one place. I encourage you to bookmark it!