This video by Max Adams from TechNet discusses the IP firewall rules inherent in SQL Azure, and demonstrates connecting to a SQL Azure database using Microsoft SQL Server Management Studio 2008.