A new brand of Microsoft SQL technology has just the market on 1 Taken in January 2010. Or perhaps it would be better to say that the technology has the name Microsoft has just hit the market changed. Azure Services is the most important step for Microsoft into the cloud. It operates as a complete platform in the cloud can compute, storage and fabric-tie individual systems into an integrated network, load the resources to process or share balance.

What SQL Azure?

The part that is most important for this study, such as Azure for SQL. Microsoft used the SQL Server Data Services and SQL Services recently call, he finally changed SQL Azure. The name change is just another step in the same way that SQL Server has already performed with the cloud.

Azure SQL allows data storage in the cloud, much like Amazon S3 and thousands of Google Apps. A big advantage is that Azure for SQL queries can be carried out store relational data in the cloud, no matter they are structured, semi -structured and unstructured documents. In addition to data-queries, users can also save search, analysis, or synchronizing data with SQL from Azure.

Once your information to SQL Azure applications can be transferred directly to the data requests in the cloud over the Internet. This works for local applications or cloud computing (such as applications running in the computer part of the Microsoft Azure Services). To supply and the timing must be transparent between SQL Server and SQL local database Azure. Microsoft also guarantees a high fault tolerance by multiple copies of your data available.

Why SQL Azure?

Microsoft claims that the main advantage is SQL Azure offers less maintenance. The service makes your need to store and manage SQL databases on the ground. In theory, administrators should have a software database or the cost of installation, customization and administration, to install their server systems. There is no material needs servers, disaster recovery and high availability. physical maintenance and administration is not necessary for companies to save on feasible costs and staffing levels. If the headaches of managing servers here is to get you, it can be a good option.

Another advantage is the ease of scalability. If you increase or decrease your need storage database, Microsoft will care too. This is one of the differences between SQL Azure and other hosting services: data storage on multiple nodes distributed and simply pay as you go to use the storage. SQL Azure can work as a hardware complement to existing database. If you expect a sudden increase in data requirements or would even be prepared in case you unexpectedly Azure, for some strongly present, but you can return your local store or others if the demand is there.

Another advantage is the scalability it offers a viable, but profitable for the database needs of small-and medium-sized enterprises.

Microsoft Azure also offers services for independent software vendors that their software as a service (SaaS) will enable provide. Azure Services, all the computing requirements of this model assumes, of course, SQL Azure would meet the needs of the database software. Feasibility, it could even simplify data security, because Microsoft is for storage. established Line of Business (LOB) applications on the IT departments to Azure Azure SQL the same way.

As with any type of “cloud” is a final advantage of that information for all applications and inquiries available as long as they are connected to the Internet. But a relative advantage of moving SQL databases in the cloud is that data (such as databases in different departments of a large company) combined, and includes better information. This should allow more complex queries to expand by more than one database tables.

Putting everything together, the benefits are simple: an economy of scale. The cost of leaving Microsoft SQL should be slightly less than the total cost of the hardware, software and maintenance (TCO)

Everything is in the details

Now the serious stuff. Regarding the programming model changes that remain most things the same, even if some details differ. The main difference is that fully relational database, a programming model based on entities and ACE replaced. To access data, is still the T-SQL code, even though developers have to make some changes in order to interact with the service fully relational database. Most managers to access data such as ADO.NET Data Services can be used with minimal changes. The data is transmitted via an XML-based format, the query language T-SQL, and Tabular Data Stream Protocol for Internet access.

How different from SQL Server SQL Azure? Azure works on the basis of SQL Server. But SQL Azure also adds new features relational data within the cloud. The biggest difference, as mentioned above use, simplicity and availability of all the help. The CTP is available for free on the Microsoft Web site quickly, but to get there. Some things are not free of charge to the end of January. Microsoft has made significant changes to the software in recent months, and there are large differences in the various versions of the production.

And what about prices? Microsoft offers 1GB of storage for relational database systems .99/month up to 10 GB for .99/month and data transfer fees of 10 cents to 15 cents per BG. There are a few options: You can pay a monthly commitment and no charge, or you can get better prices by committing to 6 months with a base rate

.
No wonder the new Azure Services is no doubt Microsoft’s commitment to the future of cloud computing. SQL Azure is a big part of this innovation and offers a great support for Web 2.0 applications. The biggest advantage is probably for mid-sized companies and small and independent software vendors who need cost-effective storage and computing time. If intuition Microsoft computer future is correct (and likely) to enter the market first, a good strategy. It remains to be seen whether successful SQL Azure, the best available technology cloud SQL database to stay.


Microsoft SQL