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


Top 5 Contributors of the Month
david stephan

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

 Subscribe to Articles

Azure Part 22: Windows Azure - SQL Azure Introduction

Posted By:Jean Paul       Posted Date: December 07, 2011    Points: 200    Category: Azure    URL: http://www.dotnetspark.com  

Windows Azure SQL Azure Introduction. In this article we are emphasizing on SQL Azure Storage. The important features are listed and we will be creating an database in the online storage account.
 

Remembering from the storage type article, the 3 types of storage were:

 

  • Local Storage
  • Windows Azure Storage
  • SQL Azure Storage

 

In this article we are emphasizing on SQL Azure Storage.  The important features are listed and we will be creating an database in the online storage account.

 

The features are mentioned below:

 

  • SQL Server equivalent in Cloud
  • Built on SQL Server Technologies
  • No installation needed
  • Transact SQL Support
  • ADO.NET and ODBC drivers supported
  • Available anywhere
  • Existing .Net Database skills are reusable here
  • Easier Scalability
  • Highly Fault Tolerant
  • Pricing involved

 

 

Note: The Sql Azure can be accessible from Azure applications as well as other applications like ASP.NET, Console Applications.  Also the complete SQL Features are not available in SQL Azure.  You can find more info here.

Features Explained

 

We can relate everything in our windows/asp.net world to azure world.  The Sql Azure is the Sql Server equivalent in the cloud.  There will be a server, database and connectivity using ADO.NET which we are familiar with.  (Creation of server and database are discussed in the upcoming article.)

 

Connecting using ADO.NET

 

We can use the existing ADO.NET SQL Server classes to connect and manipulate the SQL Azure database. 

 

Operation

Class

Connection

SqlConnection

Command

SqlCommand

Read

SqlDataReaders

 

Advantages

 

The SQL Azure database will be replicated on multiple servers and is more fault tolerant than the SQL Server database. 

 

The automatic switching of server in case of server fault makes the SQL Azure have increased availability.

 

SQL Azure helps the database management easier by freeing up from:

 

  • Server Operating System Setup Overheads
  • SQL Server Setup Overheads
  • Scalability Setup Overheads

 

In the pre SQL Azure world, we need to setup the database server with the appropriate operating system, install the sql server, configure the server etc.  But in SQL Azure we are free from all these overheads.  This makes concentrating in the core aspects of the application.

 

In the SQL Azure, scalability is an easier task otherwise in Sql Server we have to deal with replication server configuration, principal and mirror server configuration etc.  We can scale up and down based on the requirements of the application.

 

More information can be found here
Types of Database

 

In the SQL Azure there are two types of databases:

 

  • Web Edition
  • Business Edition

 

The Web Edition is the basic edition and right choice for a typical web application.  This Database provides up to 5 GB of T-SQL based relational database. This edition is best suited for Web application, and Departmental custom apps.

 

The Business Edition SQL Azure DB provides up to 50 GB of T-SQL based relational database. This edition is best suited for Software as a Service applications, custom applications etc.

 

 

The billing also varies based on the edition.  In our examples we will be using the Web Edition only.


 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