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

SQL Server 2008 RC0 feature pack

  • Comments 3
  • Likes

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


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.


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.

Comments
  • In April I wrote about Reporting Services in SQL 2008 with MOSS 2007 ( here ), and also a small article

  • Although the new design features are very nice, enterprises will need backward compatibility on the following features:

     a) access through click-once. This allows for zero deployment. Note: another option would be to create a Silverlight version ...

     b) ability to only allow business users to create an ad-hoc report based on a pre-defined report model. This is important at the enterprise architecture level since you need to control who can access what data as well as manage the load on your database servers

     c) ability to show available report models directly on the side of the surface (like in 1.0) to ensure direct access and usability

    Without these features enterprise customers like us will not be able to upgrade and get the nice design enhancements.

    PS: See my other post in the MSDN forum: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3467438&SiteID=1

  • My 2c

    It will have web deployment.  

    You can limit what data sources get deployed to reporting services and so limit what users can report against.

    Report Builder 2 is not finished yet and I would expect to see the report model in the way youdescribe.

    Finally out all this feedback on connect, to make it visible to the product team

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment