A few days ago I received my SQL Azure (CTP) invitation code. The first thing I naturally did right after this was to create and access a database on the Cloud! I was very curious to see how I could interact with a database hosted on the cloud.
After getting access to the SQL Azure Service (you can register for the CTP here), you can easily create a database by clicking on the “Create Database” button.
The default database is the well-known “master” database.
I called the database I created “sqlazure”.
So, an empty database is created, what next? One of the options is to connect to the database using SQL Server 2008 Management Studio (SSMS)!
I will provide the procedure I followed (with screenshots) in steps:
Select the database hosted on the cloud in SQL Azure and click on the “Connection Strings” button:
- ADO .NET
- OLE DB
In all the connection strings, you can find the same server value in the form of Server=tcp:[
Start SQL Server 2008 Management Studio (SSMS).
On the connection dialog that appears when starting SSMS, click on the “Cancel” button.
In SSMS click on “New Query”. The connection dialog appears again.
On the connection dialog enter the following information:
- Server Name: The full server name as provided by the SQL Azure connection string.
- Authentication: SQL Server Authentication.
- Login: The SQL Azure server admin username.
- Password: The SQL Azure server admin password.
Also, before clicking the “Connect” button, click on “Options” and under the “Connection Properties” tab, in the “Connect to database” field, enter the database name which is hosted on the cloud and you want to access*.
* In this case you have to note that if you do not specify the database in the connection properties, you will be automatically connected to the “master” database. Though, once connected to a database on SQL Azure, it is not yet possible to use the “USE” command for switching to another database. The only way for switching to another database, is to establish a new connection on that database.
OK, after selecting the database on which you want to connect (in this example sqlazure) click on the “Connect” button.
Finally, let’s run some queries against our database:
— Create a table
CREATE TABLE CLOUD_MSGS(
— Create unique clustered index
CREATE UNIQUE CLUSTERED INDEX msgID_ind
ON CLOUD_MSGS (msgID)
— Populate table with data … using Row Constructors! 🙂
INSERT INTO CLOUD_MSGS(msgID,msgDescr)
VALUES (1,’Welcome to SQL Azure’), (2,’Hello World!’), (3,’SQL is on the Cloud!’)
— Display the contents of the “CLOUD_MSGS” table
Below you can find some useful resources regarding SQL Azure. Note that this is pre-release documentation and is subject to change in future releases:
Artemakis Artemiou is a Senior SQL Server Architect, Author, a 9 Times Microsoft Data Platform MVP (2009-2018) and a Udemy Instructor. He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Moreover, Artemakis teaches on Udemy, you can check his courses here.