May 2010 - Posts

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: , ,
18 May 2010
Unused Indexes Gotcha
I'm currently looking into dropping unused indexes to reduce unnecessary overhead and I came across a very good point in the excellent SQL Server MVP Deep Dives book that I haven't seen highlighted anywhere else. I was thinking it was simply a case of dropping indexes that didn't show as... Read More...
2 comment(s)
Filed under: ,
07 May 2010
R2 and Idera Idera SQL Safe (Freeware Edition)
Good news: the Freeware edition of Idera SQL Safe works on R2. You might not care but I certainly do. Here's why: In September last year I started using Idera SQL Safe (the Freeware Edition) to get backup compression on my SQL 2005 servers. It seemed like a good idea at the time - it was free and... Read More...
no comments
Filed under: ,
04 May 2010
R2 download site is looking good
The MSDN downloads for R2 appeared as promised yesterday. Congratulations to everyone on the SQL team. I must have got one of the first downloads of the Developer Edition and it was nice and fast. I've just downloaded Standard Edition and it's still nearly as fast. Nice. I'm guessing they... Read More...
no comments
Filed under: