Securosis Blog | SQL Azure and 3 Pieces of Flair.
Adrian Lane, the database security analyst at Securosis, points out the rather limited security controls Microsoft provides for SQL Azure.
Firewall, SSL, and user authentication are the totality of the technologies prescribed.
In other words, you are on your own. We recommend Sentrigo, an agent-based database intrusion prevention solution that sits right in the database VM.