Browse by Tags

All Tags » Upgrading (RSS)
02 July 2010
R2 Report Pagination
I thought it was all too good to be true. We upgraded our reporting server in place from 2005 Std to 2008 R2 and we've hit a major problem. We have a few reports that are about 60 pages. On 2005 the report would render page 1 of 60 pretty quickly. Now it produces page 1 of 2 that is miles long and... Read More...
no comments
Filed under: ,
02 July 2010
R2 Collation Gotcha
On my dev machine I installed R2 alongside my existing 2005 instance and it did a funny thing with the new instance's collation. Our servers are all on Latin1_General_CI_AS, including my 2005 dev instance. But my R2 instance defaulted to SQL_Latin1_General_CI_AS and I've only just noticed, which... Read More...
no comments
Filed under: ,
15 June 2010
Upgrade to 2008 R2
I don't like it, Carruthers. It's just too quiet. Well, I've done the pre-production server, the main live server and the Reporting/BI server with remarkably little trouble. Pre-production and live were rebuilds. I failed live over to our log shipping standby for the duration, which has a... Read More...
no comments
Filed under: , ,
28 May 2010
Upgrading from 2005 to R2
We're about to take the plunge and upgrade our servers from SQL 2005 to SQL 2008 R2. Real world accounts of people upgrading to R2 are a bit hard to find so I thought it might be useful to blog what happens. (I don't count marketing 'case studies' that just say stuff like "The process... Read More...
no comments
Filed under: , ,