question

Melvyn Harbour 1 avatar image
Melvyn Harbour 1 asked

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?

sql-server-2008-r2sql-serverupgradeplanning
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Matt Whitfield avatar image
Matt Whitfield answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.