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

  • Microsoft Revamps Fledgling AutoGen Framework for Agentic AI

    Only at v0.4, Microsoft's AutoGen framework for agentic AI -- the hottest new trend in AI development -- has already undergone a complete revamp, going to an asynchronous, event-driven architecture.

  • IDE Irony: Coding Errors Cause 'Critical' Vulnerability in Visual Studio

    In a larger-than-normal Patch Tuesday, Microsoft warned of a "critical" vulnerability in Visual Studio that should be fixed immediately if automatic patching isn't enabled, ironically caused by coding errors.

  • Building Blazor Applications

    A trio of Blazor experts will conduct a full-day workshop for devs to learn everything about the tech a a March developer conference in Las Vegas keynoted by Microsoft execs and featuring many Microsoft devs.

  • Gradient Boosting Regression Using C#

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the gradient boosting regression technique, where the goal is to predict a single numeric value. Compared to existing library implementations of gradient boosting regression, a from-scratch implementation allows much easier customization and integration with other .NET systems.

  • Microsoft Execs to Tackle AI and Cloud in Dev Conference Keynotes

    AI unsurprisingly is all over keynotes that Microsoft execs will helm to kick off the Visual Studio Live! developer conference in Las Vegas, March 10-14, which the company described as "a must-attend event."

Most   Popular

Subscribe on YouTube