SQL in the Cloud Feet on the Ground{2}
This article talks about the advantage of using SQL AZURE for shipping any suitable applications to the cloud. The company will minimize data redundancy and save a lot of space for storage when they move any applications that are suitable to the cloud server. Besides that, it will increase high availability and patching. Therefore, the company doesn’t need to worry about hardware problem, availability or patching data. Iain Kick who is consultant for Quest Software SQL Server said “I often find SQL Server struggling along without a specialist DBA. It is generally an exercise in keeping your head above water and hoping nothing fundamental goes wrong.” Some of small companies used to have SQL Server problem such as hardware, availability, and patching. Even though Microsoft can manages the resource allocation and transparent failover, but when it comes to database and security administration they couldn’t control it. This problem has to solve by IT people. In the article, author also emphasized that there were some essential limitations of SQL Azure during fundamental of the decision process which is editions, security, timeouts, and disaster recovery. In edition process, the web cannot go over 5GB of data. In business, the capacity is 50GB of data. For security process, there are some unsupported features. In timeout process, if we excess resource of usage, the connection will disconnect. For disaster recovery, the backup and restore are not available.
I think this article is very interesting because we can get rid of worry about hardware or any technical problem as long as we move the application to the cloud server. The author does very good job on explaining of limitation during fundamental decision process. However, after reading this article I have learned that the limitation SQL Azure is crucial that we need to take into consideration.
Reference
Kick, I. (2010). SQL in the Cloud, Feet on the Ground. Database Trends And Applications, 24(4), 28.
Feb 20, 2012 @ 20:00:55
SQL Azure, is another cloud based database tool. This is exactly what Google is trying to do as well. Sometimes I think that when Google gets their hand on something, other people try to make it better before them, or vice versa. However, SQL Azure seems to be incomplete in its development. All I have to say is, if they are going to go up against Google, then I hope they have something innovative.
Feb 20, 2012 @ 20:01:39
SQL Azure, is another cloud based database tool. This is exactly what Google is trying to do as well. Sometimes I think that when Google gets their hand on something, other people try to make it better before them, or vice versa. However, SQL Azure seems to be incomplete in its development. All I have to say is, if they are going to go up against Google, then I hope they have something innovative.