Implementing SQL 2012 for Big Data

by Sam T
In this article, the author discusses about how Microsoft released a new version of SQL Server 2012. With this update, SQL Server 2012 can help organizations analyze large amounts of data otherwise known as big data. Microsoft is promoting SQL 2012 as a very useful tool to observe big data and act as a link between unstructured data platforms and data warehouse based tools. An early user of SQL 2012 has to process about 350 GB of social networking data a day, by using SQL, SQL queries billions of rows of data in seconds and allows the user to iterate and test a large number of scenarios in a short amount of time.

The article related to our class topic this week because we discussed a bit more about SQL. I don’t have any experience in dealing with SQL but hopefully we can go in depth more in class. As far as I know, it seems like companies are starting to rely more and more on SQL even though there’s some potential security flaws with it.

I thought the article presented SQL 2012 as an innovative way to help deal with big data. As more and more people start becoming more reliant on the internet, social networking sites and the other services the internet provides, there’s a ton of data that companies have to deal with. If companies don’t utilize that data properly, they might lose out on potential business and all that data would just go to waste.

Jackson, J. (2012, March). Microsoft Courts Big Data Market With SQL Server Update. http://www.pcworld.com/article/251375/microsoft_courts_big_data_market_with_sql_server_update.html

4 thoughts on “Implementing SQL 2012 for Big Data

  • November 4, 2012 at 8:14 pm
    Permalink

    There are always new updates to the software and it’s amazing how far everything is coming along. For a program to process billions of rows of data in seconds would have been unthinkable years ago, now with the latest software it is not a problem at all. I think if you had added a little bit more about the updated software I would have learned more but now I can check it out on my own. Nice post.

  • November 4, 2012 at 9:01 pm
    Permalink

    As the success of Microsoft SQL Server 2008 R2, the 2012 update is a big deal. “MS SQL 2012 includes an in-memory data-visualization component called Power View that Microsoft has been developing and talking about for years under the code name Crescent.”(informationweek.com). It brings more than 200 performance, scaleability, and reliability improvements to the database.

  • November 4, 2012 at 10:04 pm
    Permalink

    Interesting article to read, it sounds a lot like Microsoft is trying to combine a NoSQL style database like Amazon uses with their traditional SQL server tools. It sounds as if it is trying to be a bridge between databases specialized in unstructured data and ones that are mainly for structured data. It is amazing to see just how far technology has come in just the last couple of years, not to mention over the past couple of decades.

Comments are closed.