Archive | Articles RSS feed for this section

Testing SQL Azure

So how do you know whether all the T-SQL syntaxes are working with SQL Azure? For the purpose of this example we will use the TSQL from the AdventureWorks database. Database First you need to create a database. You need to be logged in to the Master database to create a database. CREATE DATABASE AdventureWorks2008 [...]

Read more

Introduction to SQL Azure

Since the SQL Azure database services are in the cloud, you do not have to worry about high availability and scalability. SQL Azure will maintain a “Monthly Availability” of 99.9% during a calendar month. For example, you or your network administrators do not have to spend time on high availability which is taken care by [...]

Read more

Connect to a SQL Azure Database Using SSMS or SQLCMD

As at launch in January 2010 SSMS can connect to SQL Azure, but the object browser does not work. Ensure that you have setup the SQL Azure firewall to allow your IP to connect to SQL Azure. Start up SSMS and when the connection dialog appears hit Cancel, this is due to a connection error [...]

Read more