TechNet has written an article which provides an overview of the security features of SQL Azure.  It provides a great overview of security considerations for SQL Azure and you should definitely take a look as you start putting your data into SQL Azure.

Click here to look at the article.

In a previous blog post we also covered SQL Azure security which had a good overview video and samples. 

-Steve