SQL Server 2008 R2 has been in the market for quite some time, and has proven to be very reliable. However, SQL Server 2012 which has been in the market for over a year has not failed to impress. In fact, as we speak SQL Server 2012 Service Pack 1 has already been launched. As a computer professional or a person who makes use of SQL Server, you probably may be confused on whether to go for the older but well respected SQL Server 2008 R2, or go with the times and acquire the newer SQL Server 2012 instead. The following are some reasons that will influence your decision.
Unlike what is usually norm, newer and more improved systems always come at a higher price. However, this is not the case with SQL Server 2012. In fact, there are minimal price differences between the newer version and the older SQL Server 2008
R2. The standard edition of SQL Server 2008 R2 goes for between $ 7,499 to about $ 29, 996. SQL Server 2012 costs $7,171 up to $ 28,688. The enterprise edition of SQL Server 2008 R2 costs from $28,749 to about $229,992, while SQL Server 2012 goes for $13,748 to around $137,480. We may clearly see that the new enterprise edition of SQL Server is on average cheaper than SQL Server 2008 R2.Clearly a case of more value at a cheaper price.
Unlike Server 2008 R2, the newer Server 2012 features more refined applications. The brand new indexing function known as Line Shop Catalog”, offers more improvement and efficiency. These new enhancement makes it much easier to use it in running various applications in data source administration, cloud based computing, information integration, and much more. This function helps in coping with large information without necessarily using an appropriate OLAP answer. It is dependent on the real Vertipaq technology that works within PowerPivot. The use of 15K dividers helps in handling large amount of data especially when using directories or full-text analysis.
SQL Server 2012 codenamed “Denali” has a reduced server downtime of up to 50 % as compared to SQL Server 2008 R2 codenamed “Kilimanjaro”. This is because 2008 R2 requires rebooting when patching the OS unlike Server 2012.SQL Server 2012 is way faster than SQL Server 2008 R2. The operating speed of SQL Server 2012 is 10 times faster than its predecessor. This is attributed to in-memory processing which together with “Dispersed Replay Function” also allow a user to monitor workloads as a way of performance improvement. The Company Cleverness Semantic Design (BISM) which also featured in SQL Server 08 R2 has become a common Bl strategy hence working alongside SSAS, Powerview, SharePoint, as well as SSRS.
SQL Server 2012 features a disaster recovery as well as high accessibility function. This allows data to be copied or duplicated hence assisting in the data recovery process. In the previous system SQL Server 08 R2, the mirror copy of the database could not be read hence hindering any attempts to recover data. In actual fact, even accessing the mirrored copy was a problem. A person had to make use of SystemManager. In a situation where you had to access two different databases, you may have been forced to rely on two different servers. A failed mirror that was related to a good mirror could also make a user go offline. All these issues have been addressed in the new SQL Server system.
The new “AlwaysOn (AO) function featured in SQL Server 2012 has brought Data Visualization. You can access up to four primary databases (read-only copies).You are also able to combine the multiple databases to a single failover form referred to as “Availability Group”. Here you have the option of Synchronous or Asynchronous.
Filestream data has made accessing data faster and more secure. In SQL Server 2008 R2, SharePoint Data came as Binary Large Objects (blobs). It was more of copying a data file from file to disk. This made it easy for anyone included people without permission to access the o/s files. SQL Server 2012 stores the files differently thoughSQL Server shell which can only be accessed by going through SQL Security.
From the above comparison of the two SQL, we can see that the newer SQL Server 2012 scores much better than the previous SQL Server 2008 R2. If you are a person after high performance, reliable service, and wide array of options, you will be well served by SQL Server 2012. If already owning SQL Server 2008 R2, you have two options of upgrading to SQL Server 2012. The first one is “In-Place” where the SQL Server may be upgraded onsite, while the second method is via “Migration” where data and content is copied or moved to a newly created environment.
Roman is a keen guest blogger and a passionate marketer. He has recently got interested in technology and writes about the latest news on different technological programs. Roman attends several technology courses like SQL training to deepen his knowledge on technology and provide his users with more accurate information.