SQL Server 2008 R2

Question

I heard on the grapevine that Microsoft will be releasing SQL Server 2008 R2 within a year. Though I initially thought this was a patch for the just released 2008 version, I realised that it’s actually a completely different version that you would have to pay for. (Am I correct, if you had SQL Server 2008, would you have to pay again if you wanted to upgrade to 2008 R2?)

If you’re already running SQL Server 2008, would you say it’s still worth the upgrade? Or does it depend on the size of your company and current setup. For what I’ve initially read, I do get the impression that this version would be more useful for the very high end hardware setup where you want to have very good scalability.

With regard to programming, is there any extra enhancements/support in there which you’re aware of that will significantly help .NET Products/Web Development?

Initially found a couple of links (could only post one) on it, but I was wondering if anyone had anymore info to share on subject as I couldn’t find nothing on SO about it?

Thanks.

Microsoft SQL 2008 R2

Answer 1

The R2 upgrade is mostly focused on data warehousing and BI features. They are incorporating some technology from a few companies that they purchased. You can read more here: http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx

If you have a need for the items, like more than 64 logical processors, or are heavily using some SQL Server 2008 specific features, it might be worth it. If you are upgrading from 2005/2000, I'd go with this one as well since it extends out the support, and it's a "smoother" release of 2008. They've fixed some things from 2008, and it should be more stable. Think SS2K8 SP3.

However, if you are trying to just keep current, I think you would be better focused on learning more about how you can use SS2K8 in your environment rather than spending time testing an upgrade.

This release has a few interesting incremental features (some nice SSRS enhancements), but mostly it appears to be trying to get a few customers with the data warehousing enhancements, make some large BI customers happy with the > 64 processor enhancement, and set a base platform on which to build for SQL 11. I'm not sure I'd jump onto too many of those new platform features here as they'll be 1.0 releases.

Answer 2

In cases where you've purchased SQL Server with software assurance (SA) , or you have a SPLA license then you don't have to pay for upgrades.