.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
satyapriyanayak
Sambanthamoorthy

Home >> Articles >> Azure >> Post New Resource Bookmark and Share   

 Subscribe to Articles

A look on Database (SQL Azure) option of new Windows Azure portal

Posted By:Dhananjay Kumar       Posted Date: April 07, 2011    Points: 200    Category: Azure    URL: http://www.dhananjaykumar.net  

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

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

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

SqlAzure1.gif

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

Now we can perform many more operations through the Database option of the 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 of various operations we can perform on Database option of the new Windows Azure portal. 

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

SqlAzure2.gif

You will get the popup shown below; select subscription and server from the drop down. 

SqlAzure3.gif

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

SqlAzure4.gif

When the database has been created, select the Manage option at the top to open the Data Base Manager. 

SqlAzure5.gif

Accept given term and conditions and click Ok. 

SqlAzure6.gif

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

SqlAzure7.gif

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

SqlAzure8.gif

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

SqlAzure9.gif

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

SqlAzure10.gif

Then click the save button at the top: 

SqlAzure11.gif

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

SqlAzure12.gif

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

Click on Row to add a Row to the table. 

SqlAzure13.gif

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

SqlAzure14.gif

Now to execute the query, select the Database tab at top and execute query as below: 

SqlAzure15.gif

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

SqlAzure16.gif

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

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend