SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2012 v SQL 2014 - is it worth going for 2014?


SQL 2012 v SQL 2014 - is it worth going for 2014?

Author
Message
Griffster
Griffster
Say Hey Kid
Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)

Group: General Forum Members
Points: 691 Visits: 713
We're in the process of investigating the implementation of SQL Server 2012 across our infrastructure, however, as time's gone on regarding pricing etc. SQL 2014 is getting closer for release. Is it worth waiting for that to be released and upgrading from our current environment (SQL 2008) straight to 2014 rather than the proposed 2012?
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27167 Visits: 13268
Depends on the features you want I guess.
If you desperately want Hekaton for your OLTP, I would wait for SQL 2014.

If you have an environment which is more used for BI, SQL 2012 has almost everything you want (except clustered columnstore indexes perhaps).


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Griffster
Griffster
Say Hey Kid
Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)

Group: General Forum Members
Points: 691 Visits: 713
We're at an embryonic stage with a big BI project really, and are planning on re-working all our internally developed web applications utilising SharePoint (especially SharePoint workflow designer for case management).
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27167 Visits: 13268
For the moment, SQL 2014 doesn't have much BI improvements (except for clustered columnstore), but they might announce new features. Who knows?

SSIS will get some new adaptors (OData and Azure for example), but I'm not sure they are SQL 2014 exclusive.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
TheSQLGuru
TheSQLGuru
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12295 Visits: 8546
Griffster (10/22/2013)
We're at an embryonic stage with a big BI project really, and are planning on re-working all our internally developed web applications utilising SharePoint (especially SharePoint workflow designer for case management).


Since you say "big BI project" does that mean you are going to be on Enterprise Edition? If so then if you make a true EDW the significant enhancements to column store indexes, more online operations, improved optimizer engine, better partitioning, etc could be worth the wait.

If you aren't doing Enterprise Edition I don't think I would wait (and incur the non-zero risk of using 2014 soon after release).

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Griffster
Griffster
Say Hey Kid
Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)

Group: General Forum Members
Points: 691 Visits: 713
Yes, we will be buying the Enterprise Edition. Looks like it would be worthwhile then so long as it's not too long a wait. If the release will be in Q2 or later in 2014 it may be too far away. We wanted to go for Enterprise Edition mainly for the Always On functionality which is a key driver for getting the procurement through.
TheSQLGuru
TheSQLGuru
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12295 Visits: 8546
Griffster (10/22/2013)
Yes, we will be buying the Enterprise Edition. Looks like it would be worthwhile then so long as it's not too long a wait. If the release will be in Q2 or later in 2014 it may be too far away. We wanted to go for Enterprise Edition mainly for the Always On functionality which is a key driver for getting the procurement through.


Be careful with AGs and SharePoint. The replay gets a SINGLE THREAD on each end per database and can be a bottleneck. The best you can hope for is 50MB per second and even that is not achievable on many systems. SP and it's huge blobs can be an issue when it comes to mirroring throughput. Be sure to test at scale before you roll out, and don't be disappointed if things don't work as you desire.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Griffster
Griffster
Say Hey Kid
Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)

Group: General Forum Members
Points: 691 Visits: 713
TheSQLGuru (10/22/2013)
Griffster (10/22/2013)
Yes, we will be buying the Enterprise Edition. Looks like it would be worthwhile then so long as it's not too long a wait. If the release will be in Q2 or later in 2014 it may be too far away. We wanted to go for Enterprise Edition mainly for the Always On functionality which is a key driver for getting the procurement through.


Be careful with AGs and SharePoint. The replay gets a SINGLE THREAD on each end per database and can be a bottleneck. The best you can hope for is 50MB per second and even that is not achievable on many systems. SP and it's huge blobs can be an issue when it comes to mirroring throughput. Be sure to test at scale before you roll out, and don't be disappointed if things don't work as you desire.


Sorry Kevin, what did you mean by AGs here? Is it something to do with the Always On functionality?
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27167 Visits: 13268
Griffster (10/22/2013)
TheSQLGuru (10/22/2013)
Griffster (10/22/2013)
Yes, we will be buying the Enterprise Edition. Looks like it would be worthwhile then so long as it's not too long a wait. If the release will be in Q2 or later in 2014 it may be too far away. We wanted to go for Enterprise Edition mainly for the Always On functionality which is a key driver for getting the procurement through.


Be careful with AGs and SharePoint. The replay gets a SINGLE THREAD on each end per database and can be a bottleneck. The best you can hope for is 50MB per second and even that is not achievable on many systems. SP and it's huge blobs can be an issue when it comes to mirroring throughput. Be sure to test at scale before you roll out, and don't be disappointed if things don't work as you desire.


Sorry Kevin, what did you mean by AGs here? Is it something to do with the Always On functionality?


If I'm not mistaken AG is Availability Group.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
TheSQLGuru
TheSQLGuru
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12295 Visits: 8546
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 Blink

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search