1. Receive an email
As I mentioned before, you will get an email from Microsoft, which contains a list of simple steps you have to fulfill to start using SQL Azure. You will also find out that you are able to create one server instance with 5 databases. (no size limitations mentioned)
2. Create your administrative account
After you enter the page https://sql.azure.com and login with your Microsoft Password account you will be able to define your administrative account credentials. As you can see on the screen below, currently you cannot change server location.
3. Manage your project
When you create your account you will see a management panel where you can manage a project created for you by Microsoft. When you press Manage link, you will see connection credentials screen.
On connection credentials screen you see your server name and possibilities to change your password or view connection strings. After pressing “Connection strings” button you will see strings generated for you to be used in ADO.Net, ODBC or OLE DB.
To check the connection I used sqlcmd tool which is shipped together with SQL Server 2005/2008 (also Express editions). Firstly, I had some issues with setting up proper connection parameters to this tool because the msdn documentation how to use sqlcmd was not clear (why we are passing server name two times?). So I used the forum link which was in email I received from Microsoft. There I’ve found my answer. I have passed following parameters to sqlcmd:
In my next post I will outline how to create a simple database, tables and what kind of queries we can launch using SQL Azure.