[EN] SQL Server 2008 R2 SP1 CTP 14 Feature Packs are available

LOGO_SQLServer2008R2The last but not least of three big packages, whis has been released by Microsoft last Friday (22nd April) is 14 Feature Packs. before You start to think about using is You must donload and install Microsoft SQL Server 2008 R2 Service Pack 1 CTP for Your environment. As always is a collection (in total 35 files) of stand-alone files which provide additional value as:
     * redistributable components for SQL Server
     * add-on providers for SQL Server

What You can find in this package? Those list is really impressive:

Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2 SP1 CTP
Note: This component requires Microsoft .NET Framework 3.5 SP1
Audience(s): Customer, Partner, Developer.
DOWNLOAD: ReportBuilder3.msi

Microsoft® SQL Server® PowerPivot for Microsoft® Excel
Audience(s): Customer, Partner, Developer
DOWNLOAD: PowerPivot_For_Excel_amd64 | PowerPivot_For_Excel_X86

Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010
Audience(s): Customer, Partner, Developer
DOWNLOAD: rsSharePoint

Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
Audience(s): Partner, Developer
DOWNLOAD: X86 Package | X64 Package | IA64 Package

Microsoft® System CLR Types for SQL Server® 2008 R2
Note: This component also requires Windows Installer 4.5.
Audience(s): Customer, Partner, Developer
DOWNLOAD: X86 Package | X64 Package | IA64 Package

Microsoft® SQL Server® 2008 R2 Remote Blob Store
Audience(s): Developer, DBA
DOWNLOAD: X86 Package | X64 Package | IA64 Package

Microsoft® SQL Server® 2008 R2 Native Client
Audience(s): Customer, Partner, Developer
DOWNLOAD: X86 Package | X64 Package | IA64 Package

Microsoft® SQL Server® 2008 R2 Command Line Utilities
Note: This component 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
DOWNLOAD: X86 Package | X64 Package | IA64 Package

Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
Note: Windows PowerShell Extensions for SQL Server requires SQL Server 2008 R2 Management Objects, also available on this page. This component also requires Windows PowerShell 1.0; download instructions are on the Windows Server 2003 Web site.
Audience(s): Customer, Partner, Developer
DOWNLOAD: X86 Package | X64 Package | IA64 Package

Microsoft® SQL Server® 2008 R2 Shared Management Objects
Note: Microsoft SQL Server 2008 R2 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0, Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types. These are available on this page.
Audience(s): Customer, Partner, Developer
DOWNLOAD: X86 Package | X64 Package | IA64 Package

Microsoft® SQL Server® 2008 R2 ADOMD.NET
Note:The English ADOMD.NET setup package installs support for all SQL Server 2008 R2 languages.
Audience(s): Customer, Partner, Developer
DOWNOAD: X86 Package | X64 Package | IA64 Package

Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
Note: Microsoft SQL Server 2008 R2 Analysis Services OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.
Audience(s): Customer, Partner, Developer
DOWNLOAD: X86 Package | X64 Package | IA64 Package

Microsoft® SQL Server® 2008 R2 Analysis Management Objects
Audience(s): Customer, Partner, Developer
DOWNLOAD: X86 Package | X64 Package | IA64 Package

Microsoft® Datamining Viewer Controls For Microsoft® SQL Server® 2008
Audience(s): Customer, Partner, Developer
DOWNLOAD: X86 Package

Some of those packages include Internet-enabled features like Customer Experience Improvement Program and Error and Usege Reporting components. You can turn-off this features. Some of components could be distributed in two versions :

  • Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.
  • Un-attend Installation – this is a DOS command Line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.
  • More information, release notes, comments and files You can find on the Download Page HERE.

    [EN] SQL Server 2008 R2 Service Pack 1 CTP for Express Edition is now available for download

    LOGO_SQLServer2008r2ExpressIn the same time as has been published Microsoft® SQL Server® 2008 R2 Service Pack 1 Community Technology Preview [build version: 10.50.2418.0], Microsoft released in seperate distrubution Microsoft® SQL Server® 2008 R2 Service Pack 1 Community Technology Preview for Express Edition [build version: 10.50.2418.0].

    This distributon is separate because Microsoft SQL Server 2008 R2 Express Edition is free (SP1 CTP of course too) and companies and users use three differents editions of SQL Server 2008 R2 SP1 CTP Express:
         * SQL Server 2008 R2 Express with Tools (Core edition of Express that supports development. Includes SQL Server 2008 Database Engine and SQL Server Management Studio Express);
         * SQL Server 2008 R2 Express with Advanced Services (Extends SQL Server 2008 Express with tools to include support for Integrated Full-text Search and Reporting Services);
         * SQL Server 2008 R2 Express – Runtime Only (Includes the SQL Database Engine only and is designed for deployments and ISV redistribution)

    All files which You need for Your environment are below:

    Download | SQLEXPR_x86_ENU.exe | 176.8MB
    Download | SQLEXPR32_x86_ENU.exe* | 156.0MB
    Download | SQLEXPRADV_x64_ENU.exe | 998.6MB
    Download | SQLEXPRADV_x86_ENU.exe | 885.3MB
    Download | SQLEXPRWT_x64_ENU.exe | 349.1MB
    Download | SQLEXPRWT_x86_ENU.exe | 327.6MB

    * SQLEXPR32 is the smallest vertion of Microsofr SQL Server 2008 R2 Express Edition and must be use only on 32-bit operation systems. All athers SQLEXP files might be use on 64-bits version of operating systems (WOW install).

    More information, release notes, comments and files You can find on the Download Page HERE.

    [EN] SQL Server 2008 R2 Service Pack 1 CTP is now available for download

    LOGO_SQLServer2008R2On early Friday, 22nd April Microsoft published Microsoft® SQL Server® 2008 R2 Service Pack 1 Community Technology Preview [build version:  10.50.2418.0].  This package should be use only for testing purpose in non-production environment. Service Pack 1 package cover all updates published before SQL Server 2008 R2 Cumulative Update 7 [up to CU6]. You can install this package for the following  editions:
    Microsoft SQL Server 2008 R2 Editions: Workgroup, Web, Standard, Enterprise, Developer, Datacenter, Parallel Computing (Warehouse) and Express Edition.

    For last (express) edition You should obtain special version for SQL Server 2008 R2 Express Edition (with or without Advanced Services). For all other edition You can download those files:

    Download | Microsoft SQL Server 2008 R2 SP1 Readme.htm | 18KB
    Download | SQLManagementStudio_x64_ENU.exe | 193.8MB
    Download | SQLManagementStudio_x86_ENU.exe | 190.0MB
    Download | SQLServer2008R2SP1-KB2463333-IA64-ENU.exe | 302.5MB
    Download | SQLServer2008R2SP1-KB2463333-x64-ENU.exe | 314.9MB
    Download | SQLServer2008R2SP1-KB2463333-x86-ENU.exe | 207.5MB

    And the most important question is: What’s new in SQL Server 2008 R2 Service pack 1?

    • Dynamic Management Views for increased supportability
    • ForceSeek for improved querying performance
    • Data-tier Application Component Framework (DAC Fx) for improved database upgradest
    • Disk space control for PowerPivot

    Those packages are supported for operating systems below:

    • Windows Server 2003 R2 (32-Bit x86);
    • Windows Server 2003 R2 x64 editions;
    • Windows Server 2003 Service Pack 2;
    • Windows Server 2008 R2;
    • Windows Server 2008 Service Pack 2
    • 64-bit systems (x64, ia64)

    More information, release notes, comments and files You can find on the Download Page HERE.