[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!

[EN] SQL Server 2012 SP1 Cumulative Update 11 is available!

LOGO__SQLServer2012SP1Microsoft released in this week two collections of packaged updates for SQL Server product. In this Cumulative Update No 11 for SQL Server 2012 SP1 (Build number: 11.0.3449.0) producer resolved and fixed thirty two bugs. Here is the list:

 

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

VSTS BUG: 2525247 | 2952260
FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL Server
SQL service

VSTS BUG: 2363899 | 2962767
FIX: "Cannot insert duplicate key" error occurs in Spool operation when you update a table in SQL Server 2012
SQL performance

VSTS BUG: 2365851 | 2963137
FIX: Incorrect result is returned when you query multiple dimension members in MDX and DAX in SSAS 2012
Analysis Services

VSTS BUG: 2556601 | 2963408
FIX: Error 5180 occurs when you query BLOB column data in SQL Server
SQL service

VSTS BUG: 2415767 | 2965069
FIX: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012
SQL performance

VSTS BUG: 2442076 | 2965654
FIX: SSRS 2012 report is cut horizontally after you apply Update MS13-088 on a computer
Reporting Services

VSTS BUG: 2437139 | 2965758
FIX: Memory leak occurs when you start and stop an XEvent session repeatedly in SQL Server 2012
SQL service

VSTS BUG: 2442014 | 2965922
FIX: Issue when you configure scheduled data refresh for the PowerPivot workbook in SharePoint 2013
BI Azure

VSTS BUG: 2403797 | 2967103
FIX: Service broker stops working when you unregister and remove a session in SQL Server
SQL service

VSTS BUG: 2525259 | 2967240
FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server
SQL service

VSTS BUG: 2468660 | 2967594
FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL Server 2012
SQL service

VSTS BUG: 2515401 | 2968909
FIX: Access violation when you query sys.extended_properties table in SQL Server 2012
SQL service

VSTS BUG: 2515449 | 2968914
FIX: Undetected deadlock occurs when you use a sequence object in SQL Server 2012
SQL service

VSTS BUG: 2681957 | 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: 2551031 | 2970421
FIX: The database sticks in role configuration phase when you perform a manual failover of a mirrored database
High Availability

VSTS BUG: 2598016 | 2972411
FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012
Reporting Services

VSTS BUG: 2425939 | 2972463
FIX: Report cache is not cleaned up after the cache expiration when you use SSRS 2012 in SharePoint integrated mode
Reporting Services

VSTS BUG: 2610505 | 2972996
FIX: Error when you execute a Transact-SQL query that contains a long case statement in SQL Server 2012
SQL service

VSTS BUG: 2521049 | 2973561
FIX: Error when you insert a record into a FileTable or FILESTREAM in SQL Server 2012
SQL service

VSTS BUG: 2624969 | 2973921
FIX: "allow mixed content" popup when you use PowerView that contains map data in SSRS 2012 on SharePoint website
Reporting Services

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

VSTS BUG: 2425013 | 2975322
FIX: The blank value does not equal to the NULL value in a business rules in MDS of SQL Server 2012
Data Quality Services (DQS)

VSTS BUG: 2415102 | 2975385
FIX: User obtains incorrect data when two users in the same security role run the same client report in SSAS 2012
Analysis Services

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

VSTS BUG: 2679072 | 2975498
FIX: Cannot view Power View sheet from SharePoint 2013 when a workbook use certain Korean characters as file name
Reporting Services

VSTS BUG: 2522972 | 2976953
FIX: The DAX query with filter returns incorrect result after you run a DAX query without any filters in SSAS 2012
Analysis Services

VSTS BUG: 2689849 | 2976966
FIX: Cannot install the Windows Forms application that has ReportViewer control
Reporting Services

VSTS BUG: 2403004 | 2977271
FIX: Poor performance when you create spatial index on Point data in SQL Server 2012
SQL service

VSTS BUG: 2777901 | 2979121
FIX: Log Reader Agent fails when you upgrade from SQL Server 2008 to SQL Server 2012
SQL service

VSTS BUG: 2735399 | 2979304
FIX: Error when you run RBS Maintainer in SQL Server 2012
SQL service

VSTS BUG: 2718528 | 2980395
FIX: A sever error occurs when you run a query that uses a hash join parallel execution plan in SQL Server 2012
SQL performance

 

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

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

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 11

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:

>> 2012_SP1_RBS_CU11_2975396_11_0_3449_x64
>> 2012_SP1_RSShrPnt_CU11_2975396_11_0_3449_x64
>> 2012_SP1_DAC_CU11_2975396_11_0_3449_x64
>> SQLServer2012_SP1_CU11_2975396_11_0_3449_x64
>> 2012_SP1_PPExcel_CU11_2975396_11_0_3449_x64
>> 2012_SP1_RBS_CU11_2975396_11_0_3449_x86
>> 2012_SP1_DAC_CU11_2975396_11_0_3449_x86
>> 2012_SP1_PPExcel_CU11_2975396_11_0_3449_x86
>> SQLServer2012_SP1_CU11_2975396_11_0_3449_x86

Enjoy!