BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

SQL Server 2008 Major Updates

| by Al Tenhundfeld on Apr 20, 2009. Estimated reading time: 2 minutes |

Microsoft has released numerous updates for SQL Server 2008: Service Pack 1, Express Edition SP1, April Feature Pack, 2008 Upgrade Advisor, Reporting Services Report Builder 2.0, Reporting Services SharePoint Add-In, Data Mining Add-In for MS Office.

SQL Server 2008 Service Pack 1 includes the following updates (release notes):

  • Roll-up of Cumulative Update 1 to 3
  • Quick Fix Engineering (QFE) updates
  • Slipstream – You are now able to integrate the base installation with service packs (or Hotfixes) and install in a single step.
  • Service Pack Uninstall – You are now able to uninstall only the Service Pack (without removing the whole instance)
  • Report Builder 2.0 Click Once capability

SQL Server 2008 Express Edition SP1 is a similar update for the free edition of SQL Server.

Microsoft SQL Server 2008 Feature Pack, April 2009 is a "collection of stand-alone install packages that provide additional value for SQL Server 2008." Visit the download page for full details; the feature pack contains many useful utilities, including:

  • Microsoft ADOMD.NET
  • ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2008 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.
  • Microsoft Core XML Services (MSXML) 6.0
  • 2008 Management Objects
  • The SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2000, SQL Server 2005 and SQL Server 2008.
  • PowerShell Extensions for SQL Server
  • 2008 Replication Management Objects
  • Sync Framework
  • Remote Blob Store

Microsoft SQL Server 2008 Upgrade Advisor, April 2009 analyzes instances of SQL Server 2000 and SQL Server 2005 to help prepare servers for upgrades to SQL Server 2008.

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0, April 2009 offers a report authoring environment similar to MS Office 2007. There is a lot in this tool; if a system currently has users creating reports in Access or Excel, the new Report Builder is definitely worth reviewing. This new 2.0 version is focused on simplying the process of creating and editing reports.

Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies, April 2009 facilitates leveraging SQL Server 2008 report processing and management capabilities within Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server 2007. The Add-In includes a report view web part that provides report viewing capability, export to other rendering formats, page navigation, search, print, and zoom. The Add-In also includes support for creating SRS subscriptions and standard WSS managements of SRS report server content types.

Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007, April 2009 exposes more of SQL Server 2008 predictive analytics to Office Excel 2007 and Office Visio 2007.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and dont miss out on content that matters to you

BT