Archive

Archive for June, 2011

Programmatically Managing SQL Azure using REST API

June 29, 2011 Leave a comment

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

June 24, 2011 Leave a comment

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

June 22, 2011 Leave a comment

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

June 21, 2011 Leave a comment

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

June 20, 2011 Leave a comment

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

Publishing Reports to SQL Azure Reporting Services

June 19, 2011 1 comment

In the previous post we saw How to provision and configure SQL Azure Reporting Services account and How to create reports using SQL Azure data for SQL Azure Reporting Services

In this post we will see How to deploy or publish the report to SQL Azure Reporting Services

Open the Report project in SQL Server 2008 R2 Business Intelligence Studio and Right click on Project Name in Solution Explorer

clip_image001

In Project Properties, Specify the “Target Report Folder” and the “Target Server URL”, Target Server URL is the url you provisioned in SQL Azure Reporting Services account and make sure Target Server version is set to “SQL Server 2008 R2”. Click Apply and Ok to save the changes

clip_image003

Right the Project Name again on Solution explorer and click on “Deploy” to publish the report to SQL Azure Reporting Services

clip_image004

For connecting to SQL Azure Reporting Service, it will prompt for user name and password, Please specify the SQL Azure Reporting Services user name and password and click “Ok” to proceed

clip_image005

In Project Build Output, you can verify the status of the Deployment

clip_image007

Once successfully deployed, open Internet Explorer or any compatible browser and open

https://SERVERNAME.ctp.reporting.database.windows.net/ReportServer

Replace SERVERNAME with your SQL Azure Reporting Services server name, enter user name and password and click “Sign In”

clip_image009

After successful login, you will be able to see the list of Report folders, click on the target folder we deployed

clip_image011

Now you will be able to see the list of reports available in the target folder, click on the Target Report we deployed to test it.

clip_image013

Since I haven’t saved the SQL Azure database user name and password, it will prompt for the credentials to connect to database, after specifying required credentials, click “View Report”

clip_image015

The Report will be successfully generated based on availability of data. You can export this Report or Print the report.

clip_image017

Now we have successfully deployed the report to SQL Azure Reporting services and preview the reports from SQL Azure Reporting Service Web

Hope you all find this information useful !!!

Creating Reports using SQL Azure Data for SQL Azure Reporting services

June 17, 2011 1 comment

In the previous post we saw How to provision and configure SQL Azure Reporting Services account.

In this article, we will see to How to create a report for SQL Azure Reporting Services using data from SQL Azure Database

Click on Start –> All Programs –> Microsoft SQL Server 2008 R2 and open SQL Server Business Intelligence Development Studio

image

Click on File –> New Project and select Report Server Project Wizard

clip_image002

Click “Next” on Report Wizard to proceed

clip_image004

Specify the name of the Data source and select Type as “Microsoft SQL Azure” and then click “Edit” to define connection string

clip_image006

Specify the name of the SQL Azure database server, specify username (Please enter username@servername) and then password and then Select the database .

clip_image007

Click “Advanced” and specify Application Name and set Encrypt to True, click “Ok” to proceed

clip_image008

Click on Test Connection to make sure the connection works and then click “Ok” to proceed

clip_image009

After connection test is suceeded, click “ok” to proceed and then the defined connection string will be displayed, you can manually verify this as well. Click “Next” to proceed

clip_image011

In Query Designer, you can select the tables and fields you want to display in report, You can also click on “Edit as Text”, if you want to use the query which you already created

clip_image013

After defining the query, click “Run Query” to test and make sure that they query works fine and returns data. After the query runs successfully, click “Ok” to proceed

clip_image015

You can review the query in this screen, if you want to make any further changes, click on “Query Builder…” button to go to query designer window, or else, click “Next” to proceed

clip_image017

Select the report type as “Tabular”, based on your requirement, you can change your report type. Once selected, click “Next” to proceed

clip_image019

Select the Available Fields and move to Displayed Fields, Group Fields and Details based on your report requirement and click “Next” to proceed

clip_image021

Select Report Table Layout and specify whether to display Subtotal or enable Drilldown and then click “Next” to proceed

clip_image023

Select your preferred Report Style and click “Next” to proceed

clip_image025

Enter the Report Name and then click “Finish” to complete

clip_image027

Once the report is generated and saved, it will be previewed automatically

clip_image029

Now you have successfully created a SSRS Report using SQL Azure data for SQL Azure Reporting services.

In the next post, we will see how to deploy this report to SQL Azure Reporting Services and preview the reports  in SQL Azure Reporting Web