News

SQL Server 2008 SP4: Really, That's It This Time

The differences between this release and the SQL Server 2008 R2 SP3 release from last week are distinct enough to warrant separate releases.

As soon as we told you boldly that SQL Server 2008 R2 SP3 was the last update you'd see from Microsoft on this version of the DBMS, the company released SQL Server 2008 Service Pack 4. One might ask, why the two versions?

For a quick historical perspective, you'll have to go back a bit and recall the names "Kilimanjaro" and "Gemini." Kilimanjaro was the code name for the version of SQL Server that would contain a bevy of data warehousing capabilities. The original Microsoft release specifically highlighted Master Data Services, multi-server management capabilities, and scability coming from added support for 64 logical processors. Gemini referred to the development of self service business intelligence features that were also included at some point prior to the R2 release.

I asked Visual Studio Magazine frequent contributor Peter Vogel for some insight and he offered parallels to how Microsoft often maintains discrete development tracks for its operating systems. In this case, the specificity of features for the R2 release meant development had to be maintained separately from plain vanilla SQL Server 2008. "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," he said.

Now that we have that straightened out, here are the basic facts on what's contained in SQL Server 2008 SP4:

  • It's a cumulative update of all the incremental issues and fixes for SQL Server 2008 SP3, with the inclusion of a last round of updates that are detailed" target="_blank">here.
  • There were 17 of them since the original SP3 release back in October 2011, if you're keeping track. They're all listed on a KB support page here.
  • Any updates moving forward will not include functional fixes (so says the blog).
  • There will be no more cumulative updates to these packages, but Microsoft will continue to provide security updates as needed and within the guidelines of its mainstream and extended support policies.

For details and download information on SQL Server 2008 R2 SP3, go here; for SQL Server 2008 SP4, go here.

About the Author

You Tell 'Em, Readers: If you've read this far, know that Michael Domingo, Visual Studio Magazine Editor in Chief, is here to serve you, dear readers, and wants to get you the information you so richly deserve. What news, content, topics, issues do you want to see covered in Visual Studio Magazine? He's listening at mdomingo@1105media.com.

comments powered by Disqus

Featured

  • Color Shards

    Sharing Data and Splitting Components in Blazor

    ASP.NET Core Version 3.1 has at least two major changes that you'll want to take advantage of. Well, Peter thinks you will. Depending on your background, your response to one of them may be a resounding “meh.”

  • How to Create a Machine Learning Decision Tree Classifier Using C#

    After earlier explaining how to compute disorder and split data in his exploration of machine learning decision tree classifiers, resident data scientist Dr. James McCaffrey of Microsoft Research now shows how to use the splitting and disorder code to create a working decision tree classifier.

  • Microsoft: Move from Traditional ASP.NET to 'Core' Requires 'Heavy Lifting'

    There are plenty of reasons to move traditional ASP.NET web apps -- part of the old .NET Framework -- to the new cross-platform direction, ASP.NET Core, but beware it will require some "heavy lifting," Microsoft says.

  • Purple Blue Nebula Graphic

    How to Compute Disorder for Machine Learning Decision Trees Using C#

    Using a decision tree classifier from a machine learning library is often awkward because it usually must be customized and library decision trees have many complex supporting functions, says resident data scientist Dr. James McCaffrey, so when he needs a decision tree classifier, he always creates one from scratch. Here's how.

  • Blazor's Future: gRPC Is Key

    Blazor guru Steve Sanderson detailed what Microsoft is thinking about the future of the revolutionary project that enables .NET-based web development using C# instead of JavaScript, explaining how gRPC is key, along with a new way of testing and a scheme for installable desktop apps.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events