Recently, I was writing about Cloud Computing Platforms. Then, on the SQL Azure page I requested for a free account. After one week of waiting I got my invitation code. What SQL Azure looks like?
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.
I am curious about your experiences, feel free to share them below, or meet and discuss on Facebook or through Twitter via @GOYELLO.
We process cookies and make them available to Google Analytics (a service provided by Google, Inc.) to improve the performance of the website, to learn your preferences about using it and to tailor it to your needs. The data will be anonymised before being transmitted. If you do not agree to this, you may disable cookies in your browser. If you do not change your browser settings, you accept the fact that it saves cookies.