In-Depth

Microsoft Ships SQL Server 2005 SP2

SP2 provides support for Windows Vista and Office 2007, while also offering new data compression, business intelligence, and security capabilities.

Microsoft announced that its shipping Service Pack 2, or SP2, of SQL Server 2005—an update that brings its premier database server current with features in Windows Vista and Office 2007.

The community technology preview, or CTP, of SQL Server 2005 SP2 was released at the company's SQL PASS conference in Seattle last November (see Resources).

According to Microsoft statements, SP2 provides support for data compression, additional business intelligence capabilities, and security updates relating to Common Criteria. It also includes manageability enhancements and the ability to access information in other databases, including Hyperion's Essbase and Oracle.

But perhaps most notable is support for Vista and Office 2007. For example, Microsoft said, add-ins for Excel 2007 and Visio 2007 let users tap into data mining capabilities provided by SQL Server Analysis Services. Additionally, SP2 also provides integration between SQL Server Reporting Services and Office SharePoint Server 2007's Report Center feature.

SQL Server 2005 SP2 is available for download here.

About the Author

Stuart J. Johnston has covered technology, especially Microsoft, since February 1988 for InfoWorld, Computerworld, Information Week, and PC World, as well as for Enterprise Developer, XML & Web Services, and .NET magazines.

comments powered by Disqus

Featured

  • .NET for Apache Spark Debuts in Version 1.0

    The open source project .NET for Apache Spark has debuted in version 1.0, finally vaulting the C# and F# programming languages into Big Data first-class citizenship.

  • In-App Reviews Come to Xamarin.Forms Android

    Android is playing a little catch-up to iOS regarding in-app review functionality, just now coming tp Microsoft's Xamarin.Forms implementation.

  • C# Slides in Usage Ranking of Programming Languages

    "The fact that C# lost three places in the ranking of language communities during the last three years is mostly explained by its slower growth compared to C/C++ and PHP."

  • Telerik UI for Blazor Updated

    Progress announced an update to its Telerik UI for Blazor components, targeting Microsoft's open source Blazor framework that lets C# coders create web apps without having to rely upon JavaScript.

  • Infragistics Unveils UI Components for Blazor

    Infragistics, specializing in third-party UI/UX controls and tools, unveiled a new offering targeting Blazor, Microsoft's red-hot open source framework that allows for C#-based web development instead of traditional mainstay JavaScript.

Upcoming Events