Just came across this one. I haven’t checked it out myself, but it sounds promising.
“… A question that is commonly asked is how to automate the scaling of a Windows Azure application. That is, how can developers build systems that are able to adjust scale based on factors such as the time of day or the load that the application is receiving? …”