Planning for SQL Server 2008 R2

SQL Server 2008 R2 is apparently planned for the first half of calendar year 2010. We're just about to do a chunk of work to move some of our SQL Server 2005 databases up to 2008. Is there anything we should factor into our planning to ease our upgrade path to 2008 R2 when it arrives?

asked Oct 12 '09 at 12:15 PM in Default

Melvyn Harbour 1 ♦♦
1.4k ● 17 ● 20 ● 22

(comments are locked)

1 answer:

The main 'adds' with SQL Server 2008 R2 are:

Scalability for very large scale data stores (in the 10s of Terabytes+)
'Self-service' business intelligence
Deployment model
Management enhancements

I would say that the deployment model would have the biggest effect on most developers, as it promises to package up database and application deployments into a single logical unit, as a few third party tools allow you to do today. Whether they are as effective in reality remains to be seem. I know I was spectacularly underwhelmed by the IntelliSense in 2008 RTM.

answered Oct 12 '09 at 12:29 PM