What type of foundation do you use?

Holly • 31 year old lover of Jesus and wife of man. Baby #5,due 7/19
It's getting Summer here and my plain old boring Cover Girl Classic Ivory just isn't cutting it. At work I always go in so pretty, but after a few hours and swearing I always look red and oily. What is a good foundation and or powder that I can use? What is it that the make up artists use? I need some of that!!!