SharePoint 2010 Web Parts missing ?

This is the place to go: http://<server name>/_layouts/NewDwp.aspx.

From the list, choose the web part you need and then click on "Populate Gallery".

The web part gallery will then be populated. You can access it at http://<server name>/_catalogs/wp/Forms/AllItems.aspx

How to filter a lookup column in SharePoint 2010 ?

A very good article that made my day today :-).

http://sprider.org/2012/05/10/how-to-filter-a-lookup-column-in-sharepoint/

Useful if you cant use InfoPath 2010.

But 1 day later, I found the below method cleaner and better

http://nagendra-gunaga.blogspot.com/2012/04/how-to-implement-cascaded-dropdown-list.html

Setting up SharePoint Foundation 2013 on Windows 2012 R2

If you wish to play around with SharePoint Foundation 2013, just take note that SharePoint Foundation 2013 is not supported in Windows 2012 R2.

If you try to install, you will fail at Install Pre-Requisites step itself. You will face issues such as not able to configure the Web/IIS Role properly.

Use SharePoint Foundation 2013 with SP1 instead.

It can be downloaded at: http://www.microsoft.com/en-us/download/details.aspx?id=42039