Microsoft Releases Final SQL Server 2008 R2 Service Pack -- Redmondmag.com

Microsoft Releases Final SQL Server 2008 R2 Service Pack

By Michael Domingo
09/30/2014

Microsoft has rolled out another version of SQL Server 2008, dubbed Release 2 Service Pack 3.

According to the SQL Server Releases blog, its "primarily a roll up of Cumulative Updates as it is the last Service Pack for SQL Server 2008 R2."

SQL Server 2008 is ancient in technology years, with more than six years since its release. While mainstream support ended in July, extended support will continue to 2019, of which this cumulative update is a result. In Microsoft parlance, that means customers who maintain an extended support agreement will continue to see and be able to download non-security and security-related updates. (The official Microsoft Support Lifecycle Policy is here.)

Meanwhile, the SQL Server team has been moving steadily with the new release of SQL Server 2014 in April of this year, and was one of newly installed Microsoft CEO Satya Nadella's first product pronouncements that highlighted the cloud and Internet of Things (IoT).

SQL Server 2014 has strong integration with the Microsoft Azure cloud service mainly on the backup and recovery side, but there's lots of tooling to allow for scaling of databases and projects and for connecting, gathering and managing data from devices and sensors as part of its embrace of the IoT. It also introduced Azure HDInsight for supporting Hadoop in the cloud, and PowerBI for Office 365 for self-service BI in the cloud.

For feature details on SQL Server 2014, go here.

About the Author

Michael Domingo has held several positions at 1105 Media, and is currently the editor in chief of Visual Studio Magazine.

Featured

What's Inside Microsoft 365's Security Toolbox?

Microsoft provides plenty of native tools to secure Microsoft 365. IT pros just have to know where to look.
Microsoft Kills 30-Day Data Retention Policy for Copilot in Fabric

Microsoft this week announced several usability improvements coming to Copilot in Fabric in preparation of its general availability release later this year.
Using Microsoft Office to Build a Network Diagram 2

Now that we've set up our process, let's dig in with the actual execution.
Microsoft Graph 'Activity Logs' Feature Goes Live

Microsoft announced the general availability of the "activity logs" capability in Microsoft Graph, giving administrators more options to track user activity and identify patterns of potential misuse.
Fallout from Microsoft's 'Midnight Blizzard' Saga Hits Feds

When the Russian attack group Midnight Blizzard successfully breached Microsoft corporate e-mail accounts late last year, it apparently managed to steal U.S. government agency e-mails, too.