I’ve just finished my miniseries on integrating Windows Phone 7, Windows Azure, SQL Azure, WCF and Push Notifications into a single package! This is my index post, so you can easily get to the other articles. Check out the demo video below.
Both videos are watchable in HQ (720p) which I recommend.
There is no downloadable code for this series because of sensitivity with a production SQL Azure database.
However, most of the relevant code can be found in the entries in the series:
Here is a more detailed view of the various projects in video walkthrough format.
This is a great way to keep your users informed without draining their batteries or burying them in your app!