[EN] SQL Server 2008 Service Pack 4 is available!

LOGO__SQLServer2008Very, very long awaited final Service Pack4 for Microsoft SQL Server 2008 is already available. This Service Pack 4 (build number 10.50.600.34) include whole previously published updates for Service Pack 3 and up to Cumulative Update 17 (sic!). And it is the last update for this platform, Microsoft will not release any Cumulative Update for Service Pack 4. So it is the same story like in my previous post: this is the last update for Microsoft SQL Server 2008.

You cand download this update form Microsoft Download Centre and you can get two files (for x86 and x64 platforms):

  • ENU\SQLServer2008SP4-KB2979596-x64-ENU.exe | 378.4 MB
  • ENU\SQLServer2008SP4-KB2979596-x86-ENU.exe | 310.9 MB

This package can be used for upgrading following SQL Server 2008 R2 editions:

  • SQL Server 2008 Enterprise Edition
  • SQL Server 2008 Developer Edition
  • SQL Server 2008 Standard Edition
  • SQL Server 2008 Evaluation Edition
  • SQL Server 2008 Workgroup Edition

 

In the same moment MIcrosoft released Microsoft® SQL Server® 2008 SP4 Feature Pack. It’s very important stand-alone packages which provide additional value of SQL Server 2008 R2 SP2. Here is the link for Knowledge Base Article and list of packages:

  • Microsoft ADOMD.NET 
  • Microsoft Analysis Management Objects 
  • Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider
  • Microsoft SQL Server 2008 Command Line Utilities 
  • Microsoft Connector 1.0 for SAP BI 
  • Microsoft SQL Server 2008 Management Objects
  • Microsoft SQL Server Remote Blob Store
  • Microsoft SQL Server 2008 Native Client
  • Microsoft Windows PowerShell Extensions for SQL Server
  • Microsoft SQL Service Broker External Activator 
  • Microsoft SQL Server System CLR Types 

and full list of downloadable files:

 

image

Please read more information on all of those products and updates under linked addresses:

 

More important notes from producer:

  • We are not releasing  SQL Server 2008 Express Service Pack 4 refresh.
  • We are not releasing IA64 packages of SQL Server 2008 Service Pack4. For IA64 it is recommended to apply the latest update we delivered on SQL Server 2008 Service Pack 3.
  • This Service Pack will not be available on Microsoft Update. To facilitate the deployment on your side you could either use custom rules in SCCM or local publishing in WSUS as explained here.
  • Slipstream technology is not available for SQL Server 2008. To slipstream a SQL Server 2008 with Service Pack 4 please see post.

[EN] SQL Server 2008 R2 Service Pack 3 is available!

LOGO__SQLServer2008SP3Long awaited Service Pack 3 for Microsoft SQL Server 2008 R2 is available from last week. This Service Pack 3 (build number 10.50.600.34) include whole previously published updates for Service Pack 2 and up to Cumulative Update 13. And it is the last update for this platform, Microsoft will not release any Cumulative Update for Service Pack 3.

You cand download this update form Microsoft Download Centre and you can get two files (for x86 and x64 platforms):

  • ENU\SQLServer2008R2SP3-KB2979597-x64-ENU.exe | 358.4 MB
  • ENU\SQLServer2008R2SP3-KB2979597-x86-ENU.exe | 247.2 MB

This package can be used for upgrading following SQL Server 2008 R2 editions:

  • SQL Server 2008 R2 Parallel Computing Edition
  • SQL Server 2008 R2 Datacenter Edition
  • SQL Server 2008 R2 Enterprise Edition and Developer Edition
  • SQL Server 2008 R2 Standard Edition
  • SQL Server 2008 R2 Web Edition
  • SQL Server 2008 R2 Workgroup Edition

 

In the same moment MIcrosoft released Microsoft® SQL Server® 2008 R2 SP3 Feature Pack. It’s very important stand-alone packages which provide additional value of SQL Server 2008 R2 SP2. Here is the link for Knowledge Base Article and list of packages:

  • Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
  • Microsoft® System CLR Types for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Remote Blob Store
  • Microsoft® SQL Server® 2008 R2 Native Client
  • Microsoft® SQL Server® 2008 R2 Command Line Utilities
  • Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2  The Microsoft SQL Server 2008 R2 Service Broker External
  • Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Shared Management Objects
  • Microsoft® SQL Server® 2008 R2 ADOMD.NET
  • Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Analysis Management Objects

and full list of downloadable files:

image

 

Please read more information on all of those products and updates under linked addresses:

 

More important notes from producer:

  • We are not releasing  SQL Server 2008 R2 Express Service Pack 3 refresh.
  • This Service Pack will not be available on Microsoft Update. To facilitate the deployment on your side you could either use custom rules in SCCM or local publishing in WSUS as explained here.
  • Slipstream technology is not available for SQL Server 2008 R2. To slipstream a SQL Server 2008 R2  with Service Pack 3 please see this post .
  • October 16th 2014: We have discovered an issue with Report Builder 3.0 that ships with SQL Server 2008 R2 Service Pack 3.You will find on the SQL Server Release Services blog a public message sharing details and mitigations.

[EN] SQL Server 2012 SP2 1st Cumulative Update is available!

LOGO__SQLServer2012SP2The second update package is also for SQL Server 2012 but this time for SQL Server 2012 with newest Service Pack 2. This Cumulative Update 1 (buil number 11.0.5532.0) contains all hotfixes in the initial release of SQL Server 2012 SP2 as well as all hotfixes in SQL Server 2012 SP1 CU#10. About forty five bugs has been fixed in this update. Here is the list:

 

VSTS BUG: 2578289 | 2881285
FIX: You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012 or SQL Server 2014
Integration Services

VSTS BUG: 2525262 | 2928300
FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server
SQL performance

VSTS BUG: 2525267 | 2932559
FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 2594745 | 2933103
FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server
SQL performance

VSTS BUG: 2594747 | 2936154
FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server
Management Tools

VSTS BUG: 2556592 | 2936984
FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server
SQL service

VSTS BUG: 2525271 | 2938192
FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 2525280 | 2950209
FIX: Access violation when the start offset is larger than the string length in Substring function in SQL Server
SQL service

VSTS BUG: 2525283 | 2952101
FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server
SQL performance

VSTS BUG: 2594735 | 2953354
FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server
SQL service

VSTS BUG: 2578277 | 2954861
FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDT 2012
Integration Services

VSTS BUG: 2578296 | 2956619
FIX: The execution of an SSIS package that is stored in MSDB is slower than it is stored on the file system
Integration Services

VSTS BUG: 2100367 | 2950189
FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server
SQL service

VSTS BUG: 2578281 | 2957768
FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012
Reporting Services

VSTS BUG: 2578275 | 2957957
FIX: Attributes sort incorrectly after you use the Attribute Properties function in SQL Server 2012 MDS Add-in for Excel
Data Quality Services (DQS)

VSTS BUG: 2525287 | 2958012
FIX: Poor performance on I/O when you execute select into temporary table operation in SQL Server 2012
SQL service

VSTS BUG: 2525285 | 2958062
FIX: Error 515 when you add a subscription and then delete it in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2578287 | 2959342
FIX: Data-driven subscription can’t be created when the driving query takes longer than 30 seconds to execute in SQL Server 2012
Reporting Services

VSTS BUG: 2525278 | 2960237
FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server
DQS

VSTS BUG: 2578299 | 2960310
FIX: Access violation when you maintain RBS with the .NET Framework 4.0 in related configuration file in SQL Server
SQL service

VSTS BUG: 2525300 | 2960735
FIX: Windows Update for SQL Server 2012 or SQL Server 2014 image does not work in Microsoft Azure Virtual Machine gallery
Setup & Install

VSTS BUG: 2525293 | 2960989
FIX: Error when you use DQS Cleansing component with large batch in an SSIS 2012 or SSIS 2014 package
DQS

VSTS BUG: 2525289 | 2961254
FIX: The execution of an MDX query in SSAS 2012 or SSAS 2014 is much slower than it is in SSAS 2008 R2
Analysis Services

VSTS BUG: 2525296 | 2961525
FIX: Keyboard keys do not work for Report Viewer 2012 in a Windows Forms application
Reporting Services

VSTS BUG: 2578301 | 2961559
FIX: Incorrect folder when deploying SQL Server 2012 PowerPivot solutions by using SharePoint 2013 Central Admin
Analysis Services

VSTS BUG: 2525298 | 2962650
FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 2578273 | 2963138
FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server 2012
SQL service

VSTS BUG: 2578303 | 2963372
FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012
Analysis Services

VSTS BUG: 2594749 | 2963373
FIX: Performance regression when you operate on a string or Boolean column by using DAX functions in SQL Server 2012
Analysis Services

VSTS BUG: 2578279 | 2963377
FIX: Exception and access violation occurs when you run an MDX calculation in SSAS 2012
Analysis Services

VSTS BUG: 2578284 | 2963836
FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012
Reporting Services

VSTS BUG: 2512105 | 2965035
FIX: SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2
Analysis Services

VSTS BUG: 2525264 | 2967634
FIX: SSIS 2012 or SSIS 2014 XML validator only outputs "TRUE" or "FALSE" when you perform XML validation
Integration Services

VSTS BUG: 2525291 | 2967635
FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS
DQS

VSTS BUG: 2516114 | 2969023
FIX: The objects or tasks move to corner when you move or resize them in an SSIS 2012 package
Integration Services

VSTS BUG: 2701948 | 2969896
FIX: Data corruption occurs in clustered index when you run online index rebuild in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 2775472 | 2974948
FIX: SQL Server resource goes offline when you change password for service account in SQL Server 2012
Management Tools

VSTS BUG: 2665730 | 2975402
FIX: Log Reader Agent crashes during initialization when you use transactional replication in SQL Server 2012
SQL service

VSTS BUG: 2682780 | 2976172
FIX: An access violation occurs when you perform Process Data or Process Full on a partition in a table in SSAS 2012
Analysis Services

VSTS BUG: 2676516 | 2976861
FIX: The time is longer and longer to perform process full on an SSAS 2012 tabular model database
Analysis Services

VSTS BUG: 2436389 | 2979587
FIX: Image completion setup fails when you use SysPrep to install localized version of SQL Server 2012
Setup & Install

VSTS BUG: 2739737 | 2980208
FIX: Permissions cannot be propagated to Subscriber in transaction replication when the Distributor is SQL Server 2012
SQL service

VSTS BUG: 2792700| 2982019
FIX: Error when you restart the Merge Agent after you upgrade the Publisher to SQL Server 2012 SP2
SQL service

VSTS BUG: 2817693 | 2982843
FIX: Longer latency for SQL Server 2012 database when you use Service Broker, database mirroring, and AlawysOn
High Availability

 

This update could be applied to Microsoft SQL Server 2012 Service Pack 2, when used with:

  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Reporting Services

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 1

You may have to restart the computer after you apply this cumulative update.

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

>> SQLServer2012_SP2_CU1_2976982_11_0_5532_x64
>> SQLServer2012_SP2_CU1_2976982_11_0_5532_x86

Enjoy!