If you search for Scott Hanselman's Penny Pinching blog post series, he details how he runs a couple of his high volume sites for as cheap as possible in Azure.