[EN] SQL Server 2012 Cumulative Update 6 is available

LOGO__SQLServer2012About week ago Microsoft released three packages of Cumulative Updates for SQL Server environment. This is the third and last post in my short series will I write (in short mode as always) about those packages. 

In this Cumulative Update 6 [version build: 11.02401.0] Microsoft resolved over twenty two bugs which could be applied to:

  • Microsoft SQL Server 2012 (with no Service Pack), when used with:
    • Microsoft SQL Server 2012 Analysis Services
    • Microsoft SQL Server 2012 Business Intelligence
    • Microsoft SQL Server 2012 Developer
    • Microsoft SQL Server 2012 Enterprise
    • Microsoft SQL Server 2012 Express
    • Microsoft SQL Server 2012 Standard
    • Microsoft SQL Server 2012 Web

Here is the list of published bugs:

VSTS BUG: 1155738 | 2734191
FIX: Reports are not printed in the defined page size when you use the RSClientPrint control to print reports in SSRS 2008 R2 or in SSRS 2012

VSTS BUG: 1158565 | 2755192
FIX: SSMS freezes when you perform management operations that relate to roles to an SSRS 2008 R2 or SSRS 2012 database

VSTS BUG: 1158567 | 2765785
FIX: Access violation when you execute an SSIS 2008 R2 or SSIS 2012 package that contains a Sort transformation on a computer that has multiple CPUs

VSTS BUG: 1158569 | 2770258
FIX: You receive an incorrect result when you run a query against a partitioned table in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1169523 | 2770635 
FIX: Incorrect result when you run an MDX query against an SSAS 2008 R2 or SSAS 2012 database that has multiple data sources

VSTS BUG: 1087085 | 2772525
FIX: Improved Metadata Discovery process performance in SQL Server Native Client for SQL Server 2012

VSTS BUG: 1158571 | 2776344
FIX: Deadlocks occur when you execute a stored procedure to alter a temporary table if lock partitioning is enabled in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1158573 | 2778479
FIX: 17066 and 3624 errors when you run the sp_refreshview stored procedure in a large batch that performs binary large object-related operations in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1158577 | 2780146
FIX: "Incorrect syntax near ‘IDENTITY_VALUE’" error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2, SQL Server 2012 or in SQL Server 2008

VSTS BUG: 1158579 | 2781008
FIX: "User cannot be found" error message in SSRS 2008 R2 or in SSRS 2012 after the logon name is changed in Active Directory

VSTS BUG: 1155751 | 2781486
FIX: Error messages when you perform a product update to a UCP-managed instance of SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1130624 | 2783983
FIX: Scroll bar moves too fast when you move components in the control flow or data flow designer window in SSDT 2012

VSTS BUG: 1158587 | 2785079
FIX: A "non-yielding" error occurs on a server for Service Broker Message Forwarding in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1155757 | 2786212
FIX: Access violation occurs when you run a spatial query over a linked server in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1158591 | 2788362
FIX: Error 28921 and error 18054 when you start an instance of SQL Server 2008 R2 or SQL Server 2012 that is upgraded from SQL Server 7.0

VSTS BUG: 1172949 | 2791745
FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008

VSTS BUG: 988881 | 2800842
FIX: Performance improvement for the MDX query designer in SQL Server 2012 PowerPivot for Excel

VSTS BUG: 1176644 | 2807974
FIX: Error 3456 after you add new file groups to the principal database in a SQL Server 2012 asynchronous database mirroring environment

VSTS BUG: 1166623 | 2811020
FIX: Memory is not released when you use the Microsoft.SqlServer.XEvent.Linq assembly to read events in SQL Server 2012 Extended Events files

VSTS BUG: 1155600 | 2811607
FIX: MDX query returns no results when a row-level security user runs an MDX query in SQL Server 2012

VSTS BUG: 1155748 | 972936
FIX: "SqlDumpExceptionHandler: Process <spid> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION." error when you run a query in SQL Server 2012, in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005

VSTS BUG: 898456 | 980142
FIX: "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server WMI provider to obtain information about SQL Server 2012, SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 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 6

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 32-bit and 64-bit / Itanium of course is not available) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2012    All (Global) | x86 | 2012_RTM_DAC_CU6_2728897_11_0_2401_x86
  • SQL Server 2012    All (Global) | x86 | 2012_RTM_SapBI_CU6_2728897_11_0_2401_x86
  • SQL Server 2012    All (Global) | x86 | 2012_RTM_PPExcel_CU6_2728897_11_0_2401_x86
  • SQL Server 2012    All (Global) | x86 | SQLServer2012_RTM_CU6_2728897_11_0_2401_x86
  • SQL Server 2012    All (Global) | x64 | 2012_RTM_DAC_CU6_2728897_11_0_2401_x64
  • SQL Server 2012    All (Global) | x64 | 2012_RTM_SapBI_CU6_2728897_11_0_2401_x64
  • SQL Server 2012    All (Global) | x64 | SQLServer2012_RTM_CU6_2728897_11_0_2401_x64
  • SQL Server 2012    All (Global) | x64 | 2012_RTM_PPExcel_CU6_2728897_11_0_2401_x64

Enjoy!

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

LOGO__SQLServer2008R2SP2About week ago Microsoft released three packages of Cumulative Updates for SQL Server environment. In next three posts I will write (in short mode as always) about those packages. 

In this Cumulative Update 5 [version build: 10.50.4276.0] Microsoft resolved over twenty one  bugs which could be applied to:

  • Microsoft SQL Server 2008 R2, when used with:
    • Microsoft SQL Server 2008 R2 Analysis Services
    • Microsoft SQL Server 2008 R2 Datacenter
    • Microsoft SQL Server 2008 R2 Developer
    • Microsoft SQL Server 2008 R2 Enterprise
    • Microsoft SQL Server 2008 R2 Express
    • Microsoft SQL Server 2008 R2 Reporting Services
    • Microsoft SQL Server 2008 R2 Standard
    • Microsoft SQL Server 2008 R2 Web
    • Microsoft SQL Server 2008 R2 Workgroup
    • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
    • Microsoft SQL Server 2008 R2 Express with Advanced Services

Here is the list of resolved bugs:

VSTS BUG: 1155737 | 2734191
FIX: Reports are not printed in the defined page size when you use the RSClientPrint control to print reports in SSRS 2008 R2 or in SSRS 2012

VSTS BUG: 1155740 | 2761400
FIX: An incomplete data import is reported as successful after a time-out in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 1155750 | 2781486
FIX: Error messages when you perform a product update to a UCP-managed instance of SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1155756 | 2786212
FIX: Access violation occurs when you run a spatial query over a linked server in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1143163 | 2790668
FIX: Incorrect result when you use the BCP utility to export data from a SQL Server 2008 R2 instance to a data file

VSTS BUG: 1145361 | 2791626
FIX: "Incorrect syntax near" error when you use a "datetimeoffset" type column as the partitioning column in SQL Server 2008 R2

VSTS BUG: 1172948 | 2791745
FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008

VSTS BUG: 1149775 | 2793580
FIX: An update is available that enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server 2008 R2

VSTS BUG: 1148153 | 2794260
FIX: Session deadlock occurs when you use an Analysis Services personalization extension in SSAS 2008 R2

VSTS BUG: 1161849 | 2800013
FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2

VSTS BUG: 1162730 | 2800284
FIX: Incorrect result when you run an MDX query that includes an Aggregate function that is used in a calculated member in SSAS 2008 R2

VSTS BUG: 1162588 | 2800797
FIX: Incorrect results when you run a FULL JOIN query that uses the CROSS APPLY clause in SQL Server 2008 R2

VSTS BUG: 1172956 | 2802244
FIX: Installation or upgrade process fails when you install or upgrade a SQL Server 2008 clustered instance on mount points

VSTS BUG: 1170316 | 2803799
FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2

VSTS BUG: 1171295 | 2803994
FIX: Data corruption occurs when LOB data is loaded into a Transact-SQL variable in SQL Server 2008 R2

VSTS BUG: 1150794 | 2806241
FIX: SSRS 2008 R2 report is not displayed if you set the PageBreak property for a group in SQL Server 2008 R2

VSTS BUG: 1173669 | 2806244
FIX: Access violation when you restore transaction log backups in a SQL Server 2008 R2-based log shipping environment

VSTS BUG: 1174229 | 2809198
FIX: Access violation after you run an ALTER statement to add a sparse column to a table in SQL Server 2008 R2

VSTS BUG: 1156216 | 2809339
FIX: High memory usage or OOM error when you run an MDX query in SSAS 2008 R2 that uses the INT function

VSTS BUG: 1165833 | 2809431
FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008 R2

VSTS BUG: 1155747 | 972936
FIX: "SqlDumpExceptionHandler: Process <spid> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION." error when you run a query in SQL Server 2012, in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005

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 5

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 32-bit and 64-bit and Itanium) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2008 R2 | All (Global) | x86 | 2008R2_SP2_SNAC_CU5_2797460_10_50_4276_x86
  • SQL Server 2008 R2 | All (Global) | x86 | SQLServer2008R2_SP2_CU5_2797460_10_50_4276_x86
  • SQL Server 2008 R2 | All (Global) | x64 | 2008R2_SP2_MDS_CU5_2797460_10_50_4276_x64
  • SQL Server 2008 R2 | All (Global) | x64 | 2008R2_SP2_SNAC_CU5_2797460_10_50_4276_x64
  • SQL Server 2008 R2 | All (Global) | x64 | SQLServer2008R2_SP2_CU5_2797460_10_50_4276_x64
  • SQL Server 2008 R2 | All (Global) | x64 | 2008R2_SP2_RSShrPnt_CU5_2797460_10_50_4276_x64
  • SQL Server 2008 R2 | All (Global) | ia64 | SQLServer2008R2_SP2_CU5_2797460_10_50_4276_IA64
  • SQL Server 2008 R2 | All (Global) | ia64 | 2008R2_SP2_SNAC_CU5_2797460_10_50_4276_IA64

Enjoy!

[PL] define WP_TEMP_DIR… coś się zepsuło

Wpadłem ostatnio na pomysł przeprowadzenia aktualizacji pluginów oraz samego głównego silnika (jeśli jest poprawka dostępna) na kilku stronach posadowionych na WordPress. Nic szczególnego, w zasadzie comiesięczne prace obejmują takie działanie: sprawdzenie, aktualizacja, kopia zapasowa. Rzeczywiście w katalogu było widać że coś można zaktualizować, a tymczasem system mówi nie!

Rys.1 | Dwie możliwe do przeprowadzenia aktualizacje i niestety obie zakończone niepowodzeniem i błędem.

Trochę szukania w internecie i okazało sie że winę za tę niedogodność ponosi nowa wersja WordPress i jej współpraca między innymi z IIS. Należy w tym wypadku odrobinę zmodyfikować plik konfiguracyjny.

Rys.2 | Właściwy plik: wp-config.php

Rys.3 | Widok pliku (podgląd w NotePad++) przez zmianą: linijki 85-88

Rys.4 | Widok pliku (podgląd w tym samym narzędziu) po zmianie: linijki 85-89

Rys.5 | Na samym końcu pozytywnie zakończona aktualizacja.

Niby proste i łatwe, ale jednak uciążliwe. Zwłaszcza gdy takich stron ma się nie jedną a na przykład dziesięć.