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?

more ▼

asked Oct 12, 2009 at 12:15 PM in Default

avatar image

Melvyn Harbour 1 ♦♦
1.4k 19 40 26

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Oct 12, 2009 at 12:29 PM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 12, 2009 at 12:15 PM

Seen: 2429 times

Last Updated: Oct 15, 2009 at 05:42 AM

Copyright 2018 Redgate Software. Privacy Policy