Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
BRH 58
#ASP.NET 55
ASP.NET 50
#DOTNET 49
.NET 40
WCF 21
DOTNET 12
c# 8
windows azure 7
SILVERLIGHT 7

Archive · View All
April 2011 9
March 2011 9
February 2011 8
December 2010 7
November 2010 5
September 2010 5
August 2010 5
May 2011 4
October 2010 4
January 2011 2

A look on Database [SQL Azure] option of new Windows Azure portal

Apr 19 2011 2:00AM by Dhananjay Kumar   

Windows Azure Development portal has been moved to new Silverlight based portal. It has all new look and many new features.

SQL Azure can be explored by selecting Database option from the left panel.

New SQL Azure portal is having very nice Silverlight based user interactive UI and many more operations can be performed through the UI. There is new database manager and it allows us to perform operations at table and row level.

Now we can perform many more operations through Database option of new Windows azure portal.

  1. Create a database
  2. Create/ delete a table
  3. Create/edit/delete rows of table.
  4. Create/edit stored procedure
  5. Create/edit views
  6. Create / execute queries etc. . . .

Let us have a walkthrough on various operations we can perform on Database option of new Windows Azure portal.

To create new Database, select Data base server and from Database section, select Create option.

You will get the below popup, select subscription and server from drop down

Give name of the Database, select Edition and maximum size of the database.

Once database got created, select Manage option from top to open Data Base Manager.

Accept given term and conditions and click Ok.

After Ok, you will get popup asking password to connect to database. Provide password and click on Connect .

After successful connection , you will get a cube providing all the information about the database you connected.

You can perform all the database operations from the top ribbon. You have option to create new query, new table, new view, and new stored procedure

If we want to create new table, click on New Table option from ribbon. We are creating a table with name Blogger. We are giving there columns ID, Name and Technology. From drop down we can select data type for the columns .

Then click on save button at top,

You can navigate between Data Base and Table tab. You can create and delete column from here also. Once you click on save button, you can see table listed at left panel.

At top you can see you have option to navigate either design or data view of table. Click on Data tab to navigate to Data view.

Click on Row to add a Row in the table.

After adding two rows, you can see table as below. You can add and delete rows from top button also.

Now to execute query, select Data Base tab at top and execute query as below,

When you click Execute button at top, you will get output as below,

In this way , you can perform almost all the basic operations from new SQL Azure Data Base Manager.

Tags: #DOTNET, #ASP.NET, ASP.NET, BRH, .NET, windows azure,


Dhananjay Kumar
49 · 4% · 1198
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

1  Comments  

  • I am happy that 'project houston - a web based SQL Azure DB manger' from sqlazurelabs was integrated with the new Azure portal. it helps a lot!.

    Thanks for a wonderful post!

    commented on Apr 19 2011 1:38PM
    Paras Doshi
    17 · 10% · 3265

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]