SQL Azure is now in CTP and for those who have received an invitation to test it out, you might be wondering how you can manage your databases via SQL Server Management Studio…. Here’s a few steps to do it:
- Set up your SQL Azure server and Administrator Username via https://sql.azure.com/
- On the SQL Azure website under Firewall Settings ensure you check “Allow Microsoft Services access to this server” and add your IP address to the IP Address Range
- Open SQL Server Management Studio
- Close the “Connect to Server” dialogue and click “New Query”
- In the “Connect to Server” dialogue box type the server name provided via the SQL Azure website, e.g: <servername>.database.windows.net
- Select Authentication to SQL Server Authentication
- Your username is the Administrator Username you set up in this format: <username>@<servername>
- Password is obvious?
From here you can run as much T-SQL as you like :)
Today (19th October) Microsoft Visual Studio 2010 Beta 2 was released – with brand new branding – we say goodbye to our multi coloured figure of eight and hello to a swish purple figure of 8! :)
What’s new with the SKU’s, well, Team Foundation Server is now available for x86 and x64 systems, and it seems that Team Suite Edition is now Ultimate Edition…
Download is available to MSDN Subscribers today:
http://msdn.microsoft.com/en-gb/vstudio/dd582936.aspx
General availability is 21st October.