As I have noted in previous posts I'm currently migrating to a New Production Server. This always brings to the fore the question of installing new technologies.
Previously I was using SQL2005 (Workgroups) for Production and I have been using 2005 Express locally for Development. Just recently (two weeks ago) I switched to SQL 2008 Express on my dev machine, so far I haven't noticed any great differences other than the minor changes to the Management Studio.
So, should I use SQL 2008?
I think I need to do more research into this question.
[EDIT] Interesting article weighing up the pros and cons