News

Microsoft Releases SQL Server 2008 R2 SP2

Microsoft today announced that SQL Server 2008 R2 Service Pack 2 is available for download.

The new service pack fixes some minor issues, and not much has apparently changed since Microsoft first offered a test preview of SP2 back in May. Microsoft lists one new addition in the service pack, which is an improvement to the "dynamic management view" function. Dynamic management views are used to "return server state information," according to an MSDN library article description.

SP2 is available now to keep various editions of SQL Server 2008 R2 up to date. The editions supported by SP2 range from the lofty Parallel Computing edition to the no-cost Express edition. Microsoft's release notes, available here, point users to the right file to download. Alternatively, SP2 can be accessed via the Microsoft download center.

The no-cost SP2 contains cumulative updates 1 though 5 from the first service pack plus additional hotfixes. As previously reported with the beta, the main issues addressed by SP2 include fixing some format problems with SQL Server reporting services, as well as a batch file caching problem.

A list of the flaws addressed by SP2 can be found in this Knowledge Base article.

About the Author

Kurt Mackie is senior news producer for the 1105 Enterprise Computing Group.

Featured

  • Azure Backup for SQL Server Now Commercially Available

    Microsoft on Monday announced that Azure Backup for SQL Server had reached "general availability" status, meaning it's deemed ready for production-environment use.

  • Insights for MyAnalytics Getting Switched On for Office 365 Users This Month

    Microsoft is planning to activate "Insights for MyAnalytics" sometime late this month for most Office 365 users, but the ability of organizations to manage this feature won't be available until possibly mid-May.

  • SharePoint Framework 1.8 Now Generally Available

    Microsoft this week announced that SharePoint Framework 1.8 had reached "general availability" status, although some features are still at the preview stage.

  • How To Create Office 365 User Accounts in Bulk

    Manual account creation can be tedious, time-consuming and prone to human error, especially if you have more than a handful of Office 365 users to set up. Brien shows you a better way.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.