Microsoft Server SQL 2012{1}


by Chris S

Microsoft has been long developing its latest version of SQL under the code name “Denali.” Recently in a press release, they announced that the codename was dropped and the project was going to be titled simply, “Microsoft Server SQL 2012.” Microsoft President announced also that they look to contribute to the Apache Hadoop project and Big Data. Apache Hadoop is a project that develops open-source software for distributed computing. Using a user-friendly programming model, the software allows for distributed processing of large data sets across multiple nodes. The software relies on its library to detect and handle failures at the application layer, allowing those that use it to capture, store and process big data efficiently. Many companies use different forms of this project to access data from servers over the internet. It cuts data being held on one computer to being spread over a cluster of computers.

I feel this is a huge leap in the right direction for data and technology. We are constantly seeing huge amounts of data being stored and accessed over the internet, but the hardware currently out there isn’t keeping up with that data growth. Apache Hadoop allows businesses to access big data without having to go deep into their pockets. Companies would spend large sums of money on a single server and rely on that to hold all of their data. That just isn’t acceptable anymore as data needs to be spread across many servers for many reasons. Why? Well data that is bundled up on a single server will cause that serve performance to fall dramatically and thus inhibiting data access time. Therefore by spreading the data over multiple servers and implementing software that knew how to accurately retrieve the data with superior results, they avoided any snags in big data access. This software is laying the foundation for the future success of businesses.

Sources:
Stuart J. Johnston (October 12, 2011) Microsoft ‘Denali’ set for 2012
http://www.databasejournal.com/features/mssql/microsoft-denali-2012-release.html