Watched a presentation on what’s in it for the DBA (http://bit.ly/Xpmt5) in SQL Azure. The big take away for me is SQL Azure manages data file, and file group optimization under the covers. Whether it has to be this way because the nature of the service architecture, or because MS wants to in more control, I like the idea right now. I like not having to evaluate and optimize what object goes in what file group, or whether I need to add another data file or inflate existing ones.
Trying to fit together pieces like network architecture, legacy database design, and growth patterns into the right place can be pretty daunting. Doing it right and seeing the improved performance is satisfying. Not getting it right has a long tail.
