MCP Actions just posted this article on how to use the local adjustment brush.
The adjustment brush gives the ability to add an effect to a small area of your image. Although Lightroom 2 and 3 had it, it's much more powerful in Lightroom 4.
There is a step by step tutorial on how to use it here: