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

LOGO__SQLServer2012At the outtage of Azure time Microsoft released two packs wit Cumulative Updates. Both for Microsoft SQL Server 2012 but for different versions. In this post I’ll write about update for SQL Server 2012 with Service Pack 1. In this Cumulative Update No 13 /and still counting?/ {build no 11.0.3482.0} Microsoft fixed about ten bugs and here is the list.

VSTS BUG: 2369445 | KB: 2793580
FIX: An update enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server
Management Tools

VSTS BUG: 3074321 | KB: 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012
SQL service

VSTS BUG: 3029598 | KB: 2994082
FIX: Error when you edit models for some groups or users in SQL Server 2012 MDS
Data Quality Services (DQS)

VSTS BUG: 3053494 | KB: 2995352
FIX: "No catalog entry found for partition ID <ID> in database <Database Name>" error when you use SQL Server 2012
SQL service

VSTS BUG: 3127645 | KB: 2997020
FIX: "An item with the same key has already been added" error when you review a report in SSRS 2012
Reporting Services

VSTS BUG: 3047505 | KB: 2998870
FIX: "The record ID is incorrect" error when you use DAX to execute query in a parent/child dimension in SSAS 2012
Analysis Services

VSTS BUG: 3242852 | KB: 3000494
FIX: The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode
Reporting Services

VSTS BUG: 3153124 | KB: 3005300
FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012
SQL service

VSTS BUG: 3158657 | KB: 3008000
FIX: Error when you use Microsoft Office 15.0 Access Database Engine OLE DB Provider as data source in SSMS 2012
Integration Services

VSTS BUG: 3443831 | KB: 3013551
FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update
SQL service

 

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 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Reporting Services
  • 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 13

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP:

  1. Install the service pack on the passive node.
  2. Install the service pack on the active node (This step requests servicerestart).

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_DAC_CU13_3002044_11_0_3482_x64
>>2012_SP1_RSShrPnt_CU13_3002044_11_0_3482_x64
>>SQLServer2012_SP1_CU13_3002044_11_0_3482_x64
>>2012_SP1_PPExcel_CU13_3002044_11_0_3482_x64
>>2012_SP1_PPExcel_CU13_3002044_11_0_3482_x86
>>2012_SP1_DAC_CU13_3002044_11_0_3482_x86
>>SQLServer2012_SP1_CU13_3002044_11_0_3482_x86

Enjoy!

[EN] SQL Server 2012 SP2 Cumulative Update #3 is available!

LOGO__SQLServer2012SP2At the outtage of Azure time Microsoft released two packs wit Cumulative Updates. Both for Microsoft SQL Server 2012 but for different versions. In this post I’ll write about update for SQL Server 2012 with Service Pack 2. In this Cumulative Update No 3 {build no 11.0.5556.0 } Microsoft fixed about forty bugs and here is the list. As you see the links are in different place than on my all previous posts. Beginning of this update, Microsoft SQL Server Service Team (which is responsible for publishing those informations) added link fo description of fixed bug instead of KB number. A little strange, but I don’t want to spend too much time for reformating all structure.

 

VSTS BUG: 3260585 | KB: 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server
SQL service

VSTS BUG: 3260585 | KB: 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server
SQL service

VSTS BUG: 3260587 | KB: 2975743
FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS
Analysis Services

VSTS BUG: 2785223 | KB: 2981424
FIX: Exception when you select more than one hierarchy from parent/child dimension with naming template in SSAS 2012
Analysis Services

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

VSTS BUG: 3260583 | KB: 2982544
FIX: Slow to access "Explorer" or "System Administration" on MDM home page
Data Quality Services (DQS)

VSTS BUG: 3260593 | KB: 2986722
FIX: Error 7105 when you execute UPDATE on sparse column set while ONLINE INDEX REBUILD is running on the same table in SQL Server
SQL performance

VSTS BUG: 3260595 | KB: 2987935
FIX: Long wait on CLR_CRST when you execute spatial query that is under heavy load in SQL Server
SQL service

VSTS BUG: 3260589 | KB: 2988667
FIX: Query results keep unchanged when filter is applied in a parent-child dimension with unary operators in SSAS 2012
Analysis Services

VSTS BUG: 3260581 | KB: 2989043
FIX: Access denied when you view report history on a SharePoint site with the View Items permission
Reporting Services

VSTS BUG: 2921742 | KB: 2989478
FIX: Poor performance for cdc.fn_cdc_get_net_changes_<capture_instance> in SQL Server 2012 SP2
SQL performance

VSTS BUG: 3260577 | KB: 2989512
FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model
Analysis Services

VSTS BUG: 3260599 | KB: 2990152
FIX: Unexpected Simplified Chinese characters appear in TextData field of Distributed Replay trace in SQL Server
Management Tools

VSTS BUG: 3260575 | KB: 2994993
FIX: Text in a hyperlink in its own paragraph is not indexed in full-text in SQL Server 2012
SQL service

VSTS BUG: 3008500 | KB: 2995211
FIX: Incorrect error when you set rotation of chart series label greater than 90 or less than -90 in an SSRS 2012 report
Reporting Services

VSTS BUG: 3075681 | KB: 2995622
FIX: "Specified cast is not valid" error when you load an XML document that has time zone information in SSIS 2012
Integration Services

VSTS BUG: 3122214 | KB: 2996729
FIX: "Non-yielding Scheduler" condition occurs when you run a complex query in SQL Server 2012
SQL performance

VSTS BUG: 3134680 | KB: 2997392
FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012
SQL service

VSTS BUG: 3140832 | KB: 3000562
FIX: ImageConsolidation device information setting does not work when it is specified in the RSReportServer.config file
Reporting Services

VSTS BUG: 3203999 | KB: 3000835
FIX: "An internal error occurred on the report server" error when you export a report to a .pdf file in SSRS 2012
Reporting Services

VSTS BUG: 3187734 | KB: 3001713
FIX: The .csv file contains field separators when you export a report that has a tablix that has no data in SSRS 2012
Reporting Services

VSTS BUG: 3256393 | KB: 3002071
FIX: "System objects could not be updated…" error when you use AlwaysOn Availability Groups feature in SQL Server 2012
High Availability

VSTS BUG: 3277704 | KB: 3002883
FIX: Error in OpenFileStream API when you open FILESTREAM data that is hosted on dynamic disks in SQL Server 2012
SQL service

VSTS BUG: 3252239 | KB: 3003102
FIX: The date value in the Last Run column is blank in Report Manager Details View in SSRS 2012
Reporting Services

VSTS BUG: 3306817 | KB: 3004355
FIX: SQL Server crashes when you retrieve an SQL statement hash for logging XEvent in SQL Server 2012
SQL service

VSTS BUG: 3331484 | KB: 3006648
FIX: Data corruption occurs in target table when you use a SQL Server destination in a data flow component in SSIS 2012
SQL service

VSTS BUG: 3401421 | KB: 3008135
FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report
SQL service

VSTS BUG: 3406283 | KB: 3008416
FIX: Duplicate records in the report rendering when you use Lookup function in the expression of a matrix in SSRS 2012
Reporting Services

VSTS BUG: 3443909 | KB: 3009576
FIX: Cannot restore database by using the full backup and differential backup files that contain defunct files
SQL service

VSTS BUG: 3449716 | KB: 3009883
FIX: Error when you execute statistics update on a table that has sql_variant data type in SQL Server 2012
SQL performance

VSTS BUG: 3389698 | KB: 3010773
FIX: Power View report plots values incorrectly for line chart in SSRS 2012 in SharePoint integrated mode
SQL service

VSTS BUG: 3266265 | KB: 3011807
FIX: Large chain of blocking occurs when you use merge replication in SQL Server 2012
SQL service

VSTS BUG: 3343220 | KB: 3012182
FIX: Log_Send_Rate column in sys.dm_hadr_database_replica_states cannot reflect the rate accurately in SQL Server 2012
High Availability

VSTS BUG: 3012389 | KB: 3013553
FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012
SQL service

 

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

  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • SQL Server 2012 Reporting Services
  • 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 3

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP:

  1. Install the service pack on the passive node.
  2. Install the service pack on the active node (This step requests servicerestart).

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_CU3_3002049_11_0_5556_x64
>> SQLServer2012_SP2_CU3_3002049_11_0_5556_x86

Enjoy!

[EN] First PASS Summit 15 blog post

I have never been on PASS Summit. Yes I know, it’s my mistake, but for last few years I wasn’t ready. Even this yeas I was ready, but small tornado in my professional life, canceled my scheduled plan for going to PASS Summit 14 in Seattle. It wasn’t easy decition, but each day we must choose right way and try to go on right way. Year 2014 is another year where I didn’t go to Summit. But of course I had chance for being a part of summit – even only virtually. I watched PASStv {TWITTER HASH #PASStv} for second and third day. From keynote by Adam Jorgensen and Denise McInerney (with support of Thomas LaRock) wher PASSion Award has been annouced to Grant Frithey’s session – I was online.

And I really, really enjoyed it. Between dreat sessions transmitted by PASStv I had chance to hear Voices of Comunity – in many, many short interviews. And I saw many of my friends from around the world with tv table and I really missed this place. And my decision could be only one – from Summit 2015 I will be (NO, I AM) a part of this Festival of SQL Family. Especially that this community made everything for inviting me – via interviews, via facebook finally via twitter. And those last medium was most important.

The host of PASStv Justin Rodino annouces a small twitter competition: ‘just twitt your favourite query using #passtv and #usbme and enter to competition’. Of course as “twitter machine” (as @SteffLocke said on our last SQL Relay Autumn Tour in UK)  I made it. And… I got a twitter message:

image

Whhoooohhaaaa! But what this is mean in fact? In next few weeks I should expect band new, hot USB stick with ALL RECORDED SESSION form this year PASS Summit 2014 from Seattle. More details?

PASS Summit 2014 Session Recordings: USB (for non-attendees) PASS Summit 2014 session recordings stored on a convenient 32GB USB drive. Weren’t able to join us in Seattle? Enjoy the full conference sessions lineup from the comfort of your office or home. The content for the non-attendees USB is the same as that for attendees. Sessions will be available 4-5 weeks after the conference. Order now.

And I will be ready for October 2015 in Seattle! See You there!

PS. If you want to have the same stuff, go to PASS Boutique and order your copy: http://www.passboutique.com/passsummit/passbsummit2014sessionrecordingsnonattendees.html