Programmatically Managing SQL Azure using REST API


In May 2011 SQL Azure Service Update 7, SQL Azure Management REST API was released.

SQL Azure Management REST API can be used for

    Currently it support Synchronous calls, there is no support Asynchronous calls.

All calls should be authenticated using X.509 Certificate and this certificate should be added as Management Certificate in Management Portal

Please read this article on How to create a Certificate http://msdn.microsoft.com/en-us/library/gg432987.aspx

Hope you all find this information useful !!!

Free 30 days Windows Azure and SQL Azure Trial Pass


Microsoft is offering 30 day Trial of SQL Azure and Windows Azure free of charge with no Credit Card required, you can use the code “ArunC” (Not case-sensitive)

This free trial pass includes the following

image

Steps to Sign up for Free Trial Account

1. Visit www.windowsazurepass.com

2. Select your Country and then enter “ArunC” as Promo Code and click “Submit”

image

3. click “Signin” button to Sign in to your Windows Live ID, If you don’t have a Windows Live ID, you can register for it freely using “Sign Up” option

image

4. Please fill your Personal Information and click “Submit”

image

5. Enter your first name, last name and click check box to accept agreement and click on “Accept”

image

6. Now you have successfully created a Free trial account for SQL Azure and Windows Azure without any cost or specifying credit card

image

Hope you find this information useful !!! Please take advantage of the Free trial offer and learn SQL Azure !!!

Windows Azure team has announced Free Ingress starting July 1st, 2011


Windows Azure team announced today in their blog that starting July 1st 2011, Ingress Traffic will be free for all Windows Azure Customers.

For more information please read this blog post from Windows Azure Team link

NJSQL Presentation Slides


Today I presented “Migrating Data to SQL Azure” in New Jersey SQL Server User Group (NJSQL)

For more information about the presentation visit

http://njsql.org/blogs/user_group_news/archive/2011/06/06/June-21st-NJSQL-UG-Meeting-_2D00_-Migrating-Data-to-SQL-Azure-with-Arunraj-Chandrasekaran.aspx

I have attached my powerpoint deck to this post so that you can get the links and references that I presented

Be sure to click on the Download Slides link to download the slides.

Please post your comments and questions !!!

Presenting “Migrating Data to SQL Azure” in New Jersey SQL Server User Group


I will be presenting at New Jersey SQL Server User Group

Location

Set Focus
4 Century Drive
Parsippany , NJ, 07054, U.S.A

Meeting Time: 6:30 PM EST – 8:30 PM EST

Session Title: “Migrating Data to SQL Azure”

Session Synopsis:

Migrating on-premise data to SQL Azure and vice versa is one of the new challenge for Database Developers and Administrators.

This session demonstrates what data can be moved to SQL Azure and how easily we can migrate data from On Premise SQL Server to SQL Azure and also from other Heterogeneous database environments.

This session includes live demonstrations using SQL Azure DAC Import Framework tools, SQL Server/Azure Migration Tools and will be highly interactive session.

NJSQL User Group Web site http://www.njsql.org/

Join NJSQL User Group at http://groups.google.com/group/nj-sql-server-user-group

NJSQL Job Posts http://www.linkedin.com/groups?gid=1964935&trk=myg_ugrp_ovr

I will post the presentation slides tomorrow after the meeting