[EN] Feature Pack for SQL Server 2008 R2 SP2 is available

The third part for all SQL Server 2008 R2 Service Pack 2 software (I wrote about first and second parts in my previous post) is more complicated and/but for a lot of administrators more important, no maybe not important; maybe more efficiency, productivity and so on. Feature Pack is a collection of stand-alone packages which provide additional values for SQL Server Environment. As always lets look for details. Each items was intended or minimum one target:

  • Customer: An individual may want to install this for additional licensed functionality.
  • Partner: An ISV may want to ship this as a redistributable component as part of their application.
  • Developer: A programmer may want to install this to support application development.
  •  

    Based on SQL Server documentation – KB2630458 – You can use features as follows:

    Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2 SP2
    Audience(s): Customer, Partner, Developer
    Download: first go to the special page

    Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010
    Audience(s): Customer, Partner, Developer
    Download: first go to the special page

    Microsoft® SQL Server® 2008 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2007
    Audience(s): Customer, Partner, Developer
    Download: first go to the special page

    Microsoft® SQL Server® PowerPivot for Microsoft® Excel
    Audience(s): Customer, Partner, Developer
    Download: first go to the special page

    Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
    Audience(s): Partner, Developer
    Download: x86, x64, itanium

    Microsoft® System CLR Types for SQL Server® 2008 R2
    Audience(s): Customer, Partner, Developer
    Download: x86, x64, itanium

    Microsoft® SQL Server® 2008 R2 Remote Blob Store
    Audience(s): Developer, DBA
    Download: x86, x64, itanium

    Microsoft® SQL Server® 2008 R2 Native Client
    Audience(s): Customer, Partner, Developer
    Download: x86, x64, itanium

    Microsoft® SQL Server® 2008 R2 Command Line Utilities
    Audience(s): Customer, Partner, Developer
    Download: x86, x64, itanium

    Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2
    Audience(s): Customer, Developer
    Download: x86, x64, itanium

    Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
    Audience(s): Customer, Partner, Developer
    Download: x86, x64, itanium

    Microsoft® SQL Server® 2008 R2 Shared Management Objects
    Audience(s): Customer, Partner, Developer
    Download: x86, x64, itanium

    Microsoft® SQL Server® 2008 R2 ADOMD.NET
    Audience(s): Customer, Partner, Developer
    Download: x86, x64, itanium

    Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
    Audience(s): Customer, Partner, Developer
    Download: x86, x64, itanium

    Microsoft® SQL Server® 2008 R2 Analysis Management Objects
    Audience(s): Customer, Partner, Developer
    Download: x86, x64, itanium

     

    More information, details, links and knowledge base You will find HERE. Please remember about compability: features above are pomatible with build 10.50.4000.0 (SQL Server 2008 R2 SP2).

    [EN] SQL Server 2008 R2 Service Pack 2 is available

    LOGO__SQLServer2008R2Sp2Just about two weeks ago (exactly on 26th July) Microsoft has released a long awaited Service pack 2 for SQL Server 2008 R2. Generally as almost always there are three parts of those packages:

    • for SQL Server (Standard, Enterprise, DataCenter and so on)
    • for SQL Express Edition
    • for Feature Packs

    In this post I will share some basic info about service pack for engines. SP2 contains changes from SP1 and Cumulative Updates from 1 to 5. after Depends of version of Your software You can use different software:

    FOR SQL SERVER

    This service pack {build number: 10.50.4000.0} KB2630458 is available for three platforms: x86 {241 MB LINK}, x64 {352 MB LINK} and for Itanium {337 MB LINK}.  Full information and more links You can find on SP2 page HERE.

    FOR SQL SERVER EXPRESS

    Another pack, but the same build number and KB number (but different SITE). Based on public information most important Key Features in this service pack looks pretty well:

    • Supports stored procedures, triggers, functions, and views
    • Store all kinds of business data with native support for relational data, XML, FILESTREAM and spatial data
    • Improved performance, usability, visualization, in addition to integration with the Microsoft 2007 Office System in SQL Server Reporting Services
    • Simplify development efforts by leveraging existing T-SQL skills, ADO.NET Entity Framework and LINQ
    • Closely integrated with Visual Studio and Visual Web Developer

    Software are available in more than three (ha!) versions: SQLSRVEXP_32 {runtime 87MB LINK}; SQL Server Express {x86 110MB LINK and x64 122MB LINK}; SQL Server with Advanced Tools {x86 894MB LINK and x64 1008MB LINK}; SQL Server Express Edition With Tools {x86 318MB LINK and x64 340MB LINK}; SQL Server Management Studio only {x86 158MB LINK and x64 161MB LINK}.

    It doesn’t matter which version You will use. Before You start updating,

    read SQL Server 2008 R2 SP2 Release Notes, then download a right file (look above),

    backup your environment, test in dev zone and at last – update.

    For additional information which bugs was solved in Service Pack 2 for SQL Server 2008 R2 look below (and/or on page):

    Fixed issues:

    VSTS BUG: 820875 922578
    FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

    VSTS BUG: 728527
    2216456
    FIX: SQL Server 2008 Service Pack 2 and SQL Server 2008 R2 Service Pack 2 enhancements to the "Operation has been cancelled" error message text in Analysis Services

    VSTS BUG: 820858
    2550375
    FIX: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 when you run log shipping from many databases to one secondary server

    VSTS BUG: 820878
    2565683
    FIX: You may receive incorrect results when you run a complex query that contains aggregates functions, join functions, and distinct functions in subqueries in a SQL Server 2008 or SQL Server 2008 R2 environment

    VSTS BUG: 820756
    2588050
    FIX: Slipstream installation of a SQL Server 2008 or SQL Server 2008 R2 service pack fails when you add new features to the SQL instance if database engine is installed

    VSTS BUG: 901689
    2653857
    FIX: You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version

    Additional fixed issues:

    VSTS BUG: 820845
    The fix is related to usage of BindParameter method and the reference of long type parameters that are used by this method.

    VSTS BUG: 852397
    The fix is to update UpgradeIncompleteFeatureConfigEventHandler.cs to include RebuildDatabase scenario when you reset ConfigurationState.

    VSTS BUG: 887672
    For document libraries with the “Opening Documents in the Browser” setting set to “Open in the client application” GetSnapshot.exe ignore the configuration and always displays the workbook by using Excel Services as if the setting was “Open in the browser”.

    VSTS BUG: 820805
    On a Russian Localized build of the Reporting Services Configuration Manager, Execution Account information that is contained clipped strings.

    VSTS BUG: 718430
    The ExpectedCount and ExpectedElapsedMs usage counts are updated to reflect the actual counts respectively.

    VSTS BUG: 737914
    Fixes an issue in which SQL Server 2008 R2 Analysis Services crashes during the database synchronization.

    VSTS BUG: 788389
    Trace flag 1264 is removed and so that the process name is collected by default in non-yielding scenario dumps. The number of thread records in non-yielding scenario dump files is increased from 1K to 16K.

    VSTS BUG: 820762
    SQL Server 2008 R2 changes the FireAgain parameter to True if an event should be logged. However, after some codes are removed by mistake, some logs are missing because of the FireAgain parameter is only determined by the external event listener. After you apply this hotfix, the issue is resolved.

    VSTS BUG: 820764
    Consider the following scenario. You have indexed view projects columns from base and non-base tables in SQL Server 2008 R2. A column from the non-base table has the same order id and type as a column of the base table. In this scenario, SQL Server 2008 R2 switches the partitions. After you apply the hotfix, SQL Server 2008 R2 experiences an error instead of switches the partitions.

    VSTS BUG: 820792
    Fixes an issue in which an object that is allocated on a SOS_Task PMO could be also used by other TASK which has a different life span. This service pack uses the correct PMO for allocating the object.

    VSTS BUG: 820796
    After you apply the hotfix, the optimizer understands that CRYPT_GEN_RANDOM can return different outputs for the same input.

    VSTS BUG: 820859
    Fixes an issue in which an incorrect value is returned when you run the SCOPE_IDENTITY().

    VSTS BUG: 820864
    Fixes an issue in which the SQL Server 2008 R2 setup crashes when you install SxS with Shiloh OLAP SP3a. This issue occurs because the Shiloh OLAP SP3a incorrectly writes the version registry key as "Service Pack 3.0."

    VSTS BUG: 820873
    Fixes an issue in which an incorrect CPU time is reported by sys.dm_exec_query_stats when parallel query plans are involved.

    VSTS BUG: 820880
    Fixes an issue that occurs when internal asynchronous file reading buffers are splitting the multi-character column delimiter in two parts. The fix is to correctly reset the current parsing pointer after buffers are switched.

    VSTS BUG: 847805
    The fix will only use the synchronization if the SQLWixCompilerExtension operation runs in candle.

    VSTS BUG: 890643
    This fix changes the HierarchyGet operation to avoid a certain code path for the explicit cap that only applies to the derived part of the hierarchy. The update is a one-line update that is low risk.

    VSTS BUG: 731796
    Fixes an issue in which you receive errors in a statement when purging from snapshots.notable_query_text.

    VSTS BUG: 820829
    Bad GUID values parsed from flat files could cause errors. The fix is to fall back into a truncation mode if the source buffer is bigger than max size of a GUID string.

    [EN] How to DO IT? Installation SQL Server Service Pack on more than one instance

    In previous post I wrote about new stuff: Service Pack 2 Customer Technology Preview for Microsoft SQL Server 2008 R2. In this one I’ll show what’s happen when we install this (and any other) service pack update on more than one instance. In this case I’ve two SQL Server 2008 R2 instances: one in Enterprise Edition and one in Express Edition with Advanced Services (both with SP1 installed). Generally We can use different Service Packs (one for Enterprise and one for Express) but it is not necessary. OK before we start we should download right file – in this case SQLServer2008R2SP2-KB2630455-x64-ENU.exe (349.8 MB) from THIS place. After, we can start:

    Capture_SQLSRV2008R2SP2CTP_01

    Pic.01 | First step as always is for checking compability and possibility for success installation. Eight rules passed, one skipped (because it is not a cluster environment).

    Capture_SQLSRV2008R2SP2CTP_02

    Pic.02 | Licence Agreemend SHOULD be read and MUST be accepted.

    Capture_SQLSRV2008R2SP2CTP_03

    Pic.03 | First instance – JOTARO on SQL Server Enterprise Edition (with SP1)

    Capture_SQLSRV2008R2SP2CTP_04

    Pic.04 | Second instance – MIFUNE on SQL Server Express with AdvServ. As we see installator found third KEYKO and fourth SQLEXPRESS instances. Both are under SQL Server 2008 Express and this service pack is not appropriate for updating process.

    Capture_SQLSRV2008R2SP2CTP_05

    Pic.05 | We should check Files in Use for our security, we should know which services are collerated with those instances BEFORE we start update.

    Capture_SQLSRV2008R2SP2CTP_06

    Pic.06 | And we have collerated service.

    Capture_SQLSRV2008R2SP2CTP_07

    Pic.07 | When we are ready to update we can look last time for summary before we going further – for SQL Server Express Edition (I apologize my readers, I missed screen for Enterprise Edition)…

    Capture_SQLSRV2008R2SP2CTP_08

    Pic.08 | and for Shared Features of course.

    Capture_SQLSRV2008R2SP2CTP_09

    Pic.09 | Installator start update for first instance – SQL Server Enterprise Edition…

    Capture_SQLSRV2008R2SP2CTP_10

    Pic.10 | and finishing them. next we must waif few minutes (on my laptop about five) before next phase will start.

    Capture_SQLSRV2008R2SP2CTP_11

    Pic.11 | And the second phase is starting. If we have more instances we will have more phases.

    Capture_SQLSRV2008R2SP2CTP_12

    Pic.12 | At the end we have GREEN LIGHT and link for summary log.

    Capture_SQLSRV2008R2SP2CTP_13

    Pic.13 | The last – unfortunatelly we must restart computer. Another one reason for announce maintenance tasks for company.

    *** **** ***

    After that is really good practice to review summary log. Is not very big, and is not hard to understand, but give us a lot of necessary information: what happened with my server. Let see it.

    By default all reports are stored in this folder (and we shouldn’t change it): C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120518_235654\SystemConfigurationCheck_Report.htm

    Inside this file we will find informations below:

    Overall summary:
      Final result:        Passed but reboot required, see logs for details
      Exit code (Decimal): 3010
      Exit message:        Passed but reboot required, see logs for details
      Start time:          2012-05-18 23:57:06
      End time:            2012-05-19 00:29:57
      Requested action:    Patch

    Instance JOTARO overall summary: {FIRST INSTANCE}
      Final result:        Passed but reboot required, see logs for details
      Exit code (Decimal): 3010
      Exit message:        Passed but reboot required, see logs for details
      Start time:          2012-05-19 00:11:19
      End time:            2012-05-19 00:24:42
      Requested action:    Patch

    Instance MIFUNE overall summary: {SECOND INSTANCE}
      Final result:        Passed
      Exit code (Decimal): 0
      Exit message:        Passed
      Start time:          2012-05-19 00:24:58
      End time:            2012-05-19 00:29:52
      Requested action:    Patch

    Machine Properties:
      Machine name:        WRON023
      Machine processor count:       2
      OS version:          Future Windows Version {WINDOWS 8 CONSUMER PREVIEW}
      OS service pack:             
      OS region:           Ísland
      OS language:         English (United States)
      OS architecture:     x64
      Process architecture:64 Bit
      OS clustered:        No

    Product features discovered:
    {details in text normally but the graphical looks better, see below}
    Product, Instance, Instance ID, Feature, Language, Edition, Version, Clustered

    Package properties:
      Description:         SQL Server Database Services 2008 R2
      ProductName:         SQL2008
      Type:                RTM
      Version:             10
      SPLevel:             2
      KBArticle:           KB2630455
      KBArticleHyperlink: 
    http://support.microsoft.com/?kbid=2630455
      PatchType:           SP
      AssociatedHotfixBuild:         0
      Platform:            x64
      PatchLevel:          10.52.3720.0
      ProductVersion:      10.50.1600.1
      GDRReservedRange:    10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
      PackageName:         SQLServer2008R2-KB2630455-x64.exe
      Installation location:         e:\86645666867d6b8cf018fff81c2985\x64\setup\

    Updated product edition:
      Instance             Edition            
      JOTARO               ENTERPRISE         
      MIFUNE               EXPRESS_ADVANCED   

    User Input Settings:
      ACTION:              Patch
      ALLINSTANCES:        False
      CLUSTERPASSIVE:      False
      CONFIGURATIONFILE:            
      ENU:                 False
      FARMACCOUNT:         <empty>
      FARMADMINPORT:       0
      FARMPASSWORD:        *****
      HELP:                False
      INDICATEPROGRESS:    False
      INSTANCEID:          <empty>
      INSTANCENAME:        <empty>
      PASSPHRASE:          *****
      QUIET:               False
      QUIETSIMPLE:         False
      UIMODE:              Normal
      X86:                 False

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file:    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120518_235654\SystemConfigurationCheck_Report.htm

     

    Information from file under part: ‘Product features discovered ‘ looks better when we turn SQL Server Setup Discovery Report. Result is much better in table view:

    Capture_SQLSRV2008R2SP2CTP_14