A brand new Microsoft SQL technologies just hit the marketplace on January 1, 2010. Or possibly it would be substantially improved to say that a re-branded Microsoft technologies just hit the market. Azure services is Microsoft's most substantial step into cloud computing. It functions as a complete platform in the cloud with computing, storage and fabric-tying individual systems into an integrated network that can balance processing load or share resources.
What is SQL Azure?
The part that is most pertinent for this evaluation is how Azure relates to SQL. Microsoft applied to call this service SQL Server Details Services and then SQL Services ahead of lately altering it lastly to SQL Azure. The name alter merely represents an further step in the precise similar path that SQL server has already been headed with cloud computing.
SQL Azure presents Details storage "in the cloud," substantially like Amazon S3 and a quantity of Google Apps. One of the significant rewards for SQL Azure is that relational queries can be created against Info stored in the cloud, regardless of no matter if or not they are structured, semi-structured or unstructured documents. Besides producing Details queries, users can also search, analyze, or synchronize with SQL Facts stored by Azure.
As soon as your Details is uploaded to SQL Azure, applications can make direct queries to the Data in the cloud by way of the Internet. This works for neighborhood or cloud-based applications (which includes applications that run in the computing component of Microsoft's Azure services). Provisionment and synchronization really should seriously be seamless amongst nearby SQL servers and the SQL Azure database. Microsoft also guarantees high fault tolerance by keeping a number of out there copies of your Facts.
Why Use SQL Azure?
Microsoft claims that the significant benefit SQL Azure presents is less upkeep. The service eliminates your need to truly store and manage SQL databases locally. In theory, administrators ought to not have to install database computer system computer software or be concerned about setup, patching and managing their server systems. Nor are there hardware requirements with servers, disaster recovery, or high availability. Physical upkeep and administration is unnecessary, so enterprises can feasibly save on staffing costs as nicely. If the headache of managing database servers is acquiring to you, this may well be a superb choice.
One of the other advantages is painless scalability. If you ought to improve or cut down your database storage, Microsoft takes care of that too. This is One of the differences in among SQL Azure and other hosting services: Data storage is distributed amongst a number of nodes and you simply pay as you go for the storage created use of. SQL Azure can work as an adjunct to present database hardware. If you anticipate a sudden spike in Information and facts desires or even will really should be ready in case One happens unexpectedly, Azure can be readily out there for heavy occasions, but you can return to neighborhood or other storage Once the have to have is gone.
1 way more benefit of scalability is that it provides workable but price-potent service for the database requirements of modest and medium-sized enterprises.
Microsoft also expects Azure services to permit independent laptop computer software writers who will should give their computer system computer software as a service (SaaS). Azure services can give for all of the computing desires this model wants, but of course, SQL Azure would meet the database needs for this software program plan. Feasibly, this could possibly even simplify Details security, given that Microsoft is responsible for storing it. Line of Business enterprise (LOB) applications built on Azure computing services may well use SQL Azure in the similar way.
As with any kind of cloud computing, One last benefit is that the Details is out there for any applications or queries as lengthy as they are connected to the Globe-wide-Net. But One related benefit of moving SQL databases to the cloud is that it consolidates Information and facts (such as databases in varied departments of a huge Organization) and integrates Facts improved. This should permit way a great deal more complex queries that stretch across varied database tables.
Putting all of these together, the painless benefit is an economic climate of scale: the cost of letting Microsoft do SQL will should be conveniently less than the total price tag of hardware, personal computer software program, and upkeep (TCO).
It is All in the Info
Now the nitty-gritty. As far as programming model adjustments, most items stay the precise exact same, even though a couple of Information and facts will be a variety of. The core difference is that fully relational Info has replaced an entity-based and ACE programming model. To access Info, T-SQL is nonetheless the code, while developers will ought to make a couple of adjustments to interact with the entirely relational database service. Most Details-access frameworks such as ADO.NET Details Services can nonetheless be utilized with minimal modifications. Info transfer is by signifies of an XML-based format, the query language is T-SQL, and Tabular Details Stream is the protocol for Globe-wide-Internet access.
How is SQL Azure a number of from SQL Server? Azure works on very best of SQL server. But SQL Azure also adds new relational Facts functions inside the cloud. The very best difference is as stated above -ease-of use, simplicity, and availability everywhere. The CTP is on the market for cost-no cost on Microsoft's Web-webpage, but get there rapid. Some points will no longer be readily available for free of charge at the end of January. Microsoft has made crucial alterations to the computer software plan in the last couple of months, and there are massive differences in every and every of the production versions.
And what about pricing? Microsoft supplies 1 GB of relational database space for $9.99/month, up to 10 GB for $99.99/month, and Information and facts transfer fees of 10 cents in and 15 cents per BG. There are also a couple of solutions: you can pay as you go with no monthly commitment and fee, or you can get improved expenditures by committing to 6 months with a base fee.
No surprise-the new Azure services surely represent Microsoft's commitment to the future of cloud computing. SQL Azure is a substantial part of this innovation and supplies exceptional support for Net 2.0 applications. The largest benefit is fairly perhaps for smaller and medium-size firms or independent computer software plan writers that will need price-beneficial storage and computing. If Microsoft's hunch about future computing is proper (and it maybe is), acquiring into the industry 1st is a wonderful approach. It will only remain to be noticed no matter whether or not SQL Azure manages to stay the top cloud SQL database technologies on the marketplace.
Rob Collins is the editor of for a quantity of resource centers, including SQLServers.net, a SQL Database Technologies Portal and Resource Center.
Pay a go to to SQLServers.net for even additional superb SQL Valuable hints and SQL Tools and Info.
No comments:
Post a Comment