Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server 2008 RC0 feature pack

The sharp eyed amongst you will have noticed that there are a few things missing in RC0 that were in CTP6 and I was a bit annoyed that one of my favorites, the report designer preview had disappeared.

Don’t panic it’s tucked away in the SQL Server 2008 RC0 feature pack along with lots of other goodies including:

Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider

Note: Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.
Audience(s): Customer, Partner, Developer

      X86 Package(SQLServer2008_ASOLEDB10.msi) – 19490 KB
      X64 Package (SQLServer2008_ASOLEDB10_x64.msi) – 43945 KB
      IA64 Package(SQLServer2008_ASOLEDB10_ia64.msi) – 50682 KB


Microsoft SQL Server 2005 Backward Compatibility Components

The SQL Server Backward Compatibility package includes the latest versions of Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with both SQL Server 2005 and SQL Server 2008 and include all fixes shipped through SQL Server 2000 SP4 and SQL Server 2005 SP2.
Audience(s): Customer, Partner, Developer


Microsoft SQL Server 2008 Command Line Utilities

The SQLCMD utility allows users to connect, send Transact-SQL batches, and output rowset information from SQL Server 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 2008 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.
Note: This component also requires both Windows Installer 4.5 and Microsoft SQL Server Native Client (which is another component available from this page).
Audience(s): Customer, Partner, Developer


SQL Server Compact 3.5 SP1

SQL Server Compact is a free, easy-to-use embedded database engine that lets developers build robust Windows Desktop and mobile applications that run on all Windows platforms including Windows XP, Vista, Pocket PC, and Smartphone. Run the Microsoft Windows installer file (MSI) to install the product. The single setup program will install the provider and tools on x86 and x64 computers. The package includes product updates in the form of an integrated Service Pack 1. Read the installation guide and Readme for more information.
Audience(s): Customer, Partner, Developer


Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007

Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 enables you to take advantage of SQL Server 2008 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes the following components:

  • Table Analysis Tools for Excel: This add-in provides easy-to-use tools that leverage SQL Server 2008 data mining features to perform powerful analytics on your spreadsheet data. Two new tools have been added for this release: Prediction Calculator and Shopping Basket Analysis.
  • Data Mining Client for Excel: This add-in enables you to go through the full data mining model development lifecycle within Excel 2007 using your spreadsheet data or external data accessible through your SQL Server 2008 Analysis Services instance. This release adds support for new SQL Server 2008 data mining features including holdout and cross-validation, a new Document Model wizard, and improvements to existing wizards.
  • Data Mining Templates for Visio: This add-in enables you to render and share your mining models as annotatable Visio 2007 drawings.
    Audience(s): Customer, Partner, Developer
      X86 Package (SQLServer2008_DMAddin.msi) – 18100 KB
      Readme (DMAddins_SS08_Office2007_Readme.htm) – 24 KB


Microsoft Core XML Services (MSXML) 6.0

    Microsoft Core XML Services (MSXML) 6.0 is the latest version of the native XML processing stack. MSXML 6.0 provides standards-conformant implementations of XML 1.0, XML Schema (XSD) 1.0, XPath 1.0, and XSLT 1.0. In addition, it offers 64-bit support, increased security for working with untrusted XML data, and improved reliability over previous versions of MSXML.

Microsoft SLQ Server 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.
Note: Microsoft SQL Server 2008 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0 and Microsoft SQL Server Native Client, also available on this page.

      X86 Package (SharedManagementObjects.msi) – 3225 KB
      X64 Package (SharedManagementObjects_x64.msi) – 3895 KB
      IA64 Package (SharedManagementObjects_ia64.msi) – 5640 KB


Microsoft OLEDB Provider for DB2

      Package (DB2OLEDB.exe) – 44607 KB


Microsoft SQL Server 2008 Native Client

    Microsoft SQL Server 2008 Native Client (SQL Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 features. This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API.
    Audience(s): Customer, Partner, Developer


Microsoft SQL Server 2008 Policies

Microsoft SQL Server 2008 Policies are examples of how you can take advantage of Policy Based Management. These policies will help you follow some of the SQL Server best practices and avoid common pitfalls. For more information, please see Administering Servers by Using Policy Based Management in SQL Server 2008 Books Online.
Note: This component also requires Windows Installer 4.5.
Package (SQLServerBestPracticesPolicies.msi) -1343 KB


Microsoft SQL Server 2008 Report Builder 2.0

    Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. Report Builder 2.0 supports the full capabilities of the Report Definition Language (RDL) including tablix, new data visualizations, and richly formatted text features of SQL Server 2008 Reporting Services. The download provides a stand-alone installer for Report Builder 2.0.
    Note: This component also requires .NET Framework 3.5.
    Package (ReportBuilder.msi) -18640 KB


Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies

    Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of SQL Server 2008 report processing and management capabilities in SharePoint integrated mode. This version also includes data-driven subscriptions. The download provides a Report Viewer web part, web application pages, and support for using standard Windows SharePoint Services or Microsoft Office SharePoint Services.
    Download site


Microsoft SQL Server System CLR Types

    The SQL Server System CLR Types package contains the components implementing the new geometry, geography, and hierarchyid types in SQL Server 2008. This component can be installed separately from the server to allow client applications to use these types outside of the server.
    Note: This component also requires Windows Installer 4.5.
    Audience(s): Customer, Partner, Developer

Microsoft SQL Server 2008 Upgrade Advisor

    Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 in preparation for upgrading to SQL Server 2008. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.
    Note: This component also requires Windows Installer 4.5.
    Audience(s): Customer, Partner, Developer

I have to say I am puzzled as to why some of this has moved out of the install, although some of it is included in both, for example the upgrade advisor.