Dryhad
Coolest from MS Research (at least from my pov) is DryadLINQ and Dryhad which harasses the power of cluster computing. A very sophisticated query could be executed over 1000s of nodes in the cloud. How cool is that! See this for more information.