Select Page

Microsoft Releases Final SQL Server 2008 Service Pack

Andy McDermid | | November 11, 2014

SQL Server Service PackMicrosoft announced it was releasing a final update for the SQL Server 2008 Service Pack recently, but no sooner than you could determine how to correctly spell “Kilimanjaro” did the folks in Redmond issue SQL Server 2008 Service Pack 4.

SQL Server 2008 R2 SP3 was supposedly the last release, but there were two different releases for this particular version of SQL Server.

As Peter Vogel explained to Visual Studio Magazine, the issue extends to the different SQL Server releases – “Kilimanjaro” and “Gemini.” The former release included data warehousing capabilities while the latter included self service business intelligence features in the version prior to the R2 release. Microsoft handled development of each release separately. He says:

The patches are slightly different for each version of SQL Server so they have to be targeted to a specific version of SQL Server. However, because the different versions share a code base, the patches are similar in nature.

So, which of these service packs do you need? Grab SQL Server 2008 SP4. It includes all the fixes and updates found in SQL Server 2008 SP3. Microsoft claims this will be the last of the functional fixes for this version of SQL Server.

The newest service pack can be used to upgrade SQL Server 2008 editions, including:

  • Enterprise
  • Standard
  • Evaluation
  • Developer
  • Workgroup

Service packs aren’t really optional additions. These bundles of updates and fixes “are created and released for recognized issues,” explains Microsoft. By updating to the latest service pack, you are unquestionably using the latest and most secure version of the product available. In some cases, the most current supported service pack has to be installed in order for your organization to continue getting full support from Microsoft.

Here’s Microsoft’s description of the differences between the two service packs:

SQL Server 2008 R2 SP3 and SQL Server 2008 SP4 contain fixes to issues that have been reported through our customer feedback platforms. They contain Hotfix solutions provided in SQL Server 2008 R2 cumulative updates up to and including Cumulative Update 13, and SQL Server 2008 cumulative updates up to and including Cumulative Update 17. The Service Packs also include the security bulletin MS14-044. SQL Server 2008 and 2008 R2 are now in extended support, which means there will not be Cumulative Updates for these Service Packs.

In addition to the security benefits associated with downloading Service Pack 4, there are several enhancements the package offers. For example, it includes enhanced warning messages triggered when creating the maintenance plan if the Shrink Database option is enabled. It also offers transparent data encryption for databases – even those which may have had a security certificate dropped.

Database administrators will also appreciate that optimized query outcomes are available when the indexed Spatial Data Type column is used by the Database Tuning Advisor. It also tweaked the user interface, placing the Sequence Functions in a parallel execution plan.

Microsoft ended mainstream support for SQL Server 2008 in July. It will provide extended support for it until 2019. This means, if your organization has signed an extended support agreement with Microsoft, you can still download non-security and security-related updates for SQL Server 2008.

You can download SQL Server 2008 SP4 here.

If you have questions or concerns Microsoft hasn’t answered with these releases or if you’re considering upgrading to a new version of SQL Server and need assistance, please contact Datavail to discover how our database professionals can tailor a custom solution to your organization’s specific needs.

Image by alehdats/123RF.

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS