I just connected to my SQL Azure database for the first time through SQL Server Management Studio, only to discover it doesn't support database diagrams.

Are you kidding me? I have to script each and every modification?

I'm not too far along in my project, I may just use an ordinary SQL Express DB. Given the prevalence of transient errors, this means it may make more sense to drop SQL Azure altogether.