Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

SQL 2012 v SQL 2014 - is it worth going for 2014? Expand / Collapse
Posted Wednesday, October 23, 2013 3:33 AM


Group: General Forum Members
Last Login: Monday, April 14, 2014 3:21 AM
Points: 2,797, Visits: 3,079
As you have not started your build, I would suggest going straight to SQL 2014.

You will have read about the in-memory and column-store stuff, and they will help BI just as much as OLTP, the only pain is they are Enterprise Edition features. SQL 2014 also has other improvements such as improvements to the query optimiser that everyone benefits from, regardless of use of the other features. IMHO SQL 2014 Enterprise Edition gives enough to make the upgrade almost a no-brainer if you already run Enterprise Edition workloads.

I do not know when SQL 2014 will be released, but I have read two publicly available things that make me think it will be Q1 2014, maybe even January...

a) Upgrade to SQL 2014 RTM from SQL 2014 CTP2 is supported - my view is this means there is not a lot of new stuff coming.

b) SQL 2012 CTP2 expires on 31 March 2014 - my view is that with a CTP3 being very unlikely (due to lack of new features) then the RTM date has to be at least a month before CTP2 expires so that people have time to upgrade to RTM.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 25 March 2014: now over 28,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1507520
Posted Wednesday, October 23, 2013 3:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 8:19 AM
Points: 247, Visits: 689
TheSQLGuru (10/22/2013)
Yeah - AG is Availability Group. Stuff with the Always On sphere.

That you asked that question has me a bit concerned. Implementing ANY form of HA/DR is a complex and risky undertaking. I do hope you will be either getting some proper training or some professional assistance before you embark on your mission. Please do not think you can just slap together a system and expect to truly have HA/DR and an optimal configuration that also matches your various and sundry requirements. I know of some horror stories out there (some of them created by consulting firms that did the very thing I just warned against)!! DAMHIK

Oh yes! We're getting consultants in to assist with that side don't you worry. lol Thanks for the advice at any rate.
Post #1507524
Posted Wednesday, October 23, 2013 5:55 AM

Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:01 AM
Points: 1,150, Visits: 6,252
At this time, there is no RTM date set for 2014. I would lean more towards 2012 and get the project started. Especially if you have a select agreement and can move up for free. I'd give some consideration to the hardware side, planning for memory expansion, especially given the in memory capabilities of both versions.

Depending on the timing of release, you could end up developing on 2012, but upgrading and going live on 2014. I'd assume that it will take some time to build backend processes.

It seems like versions come out more often, with fewer ground breaking features, and better upgrade paths (not as many show stoppers requiring a lot of rework).
Post #1507562
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse