I hate SQL Service Packs. Yeah, you heard me! They just add so much more time to the installation time. Yeah, you can “slipstream” them, but only a few people ever do it.
Good news everybody! SQL Server 2008 R2 SP1 is launched. Some new features are listed on that page but it’s all beyond an accidental DBA like me so I won’t copy/paste and present to understand it all.
Don’t just lash this SP out and hope for the best. Check your application compatibility. That applies to your System Center admins too! There are support lists and you shouldn’t go upgrading without checking for support first. Assuming there is support is your problem, not Microsoft’s. You break it – you fix it