[EN] SQL Server 2012 SP1 Cumulative Update 9 is available

LOGO__SQLServer2012SP1Two weeks ago, two cumulative packages for two different SQL Server versions. This is the post about second of two. In this Cumulative Update No 9 (build no 11.0.3412.0) Microsoft fixed over thirty bugs for many parts of SQL Server environment. Here is the list of fixed bugs (with new feature – Fix Area):

VSTS BUG: 2027275 | 2723979
FIX: Access violation in SQL Server internal deadlock monitor when you run multiple applications together with Multiple Active Result Sets enabled in SQL Server 2008 R2 or in SQL Server 2012
SQL service

VSTS BUG: 2041570 | 2861456
FIX: Access violation in replication Distribution Agent in SQL Server 2008 R2 or SQL Server 2012 Transactional Replication
SQL service

VSTS BUG: 1852108 | 2913206
FIX: Cannot pass report parameters to reports in a SharePoint Document Library in SSRS 2008 R2 or SSRS 2012 by using HTML forms
Reporting Services

VSTS BUG: 2076868 | 2920987
FIX: Poor performance when many table-valued parameters are used in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 1993314 | 2921630
FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008 or SSAS 2008 R2 or SSAS 2012
Analysis Services

VSTS BUG: 1920886 | 2922935
FIX: Excel rendering extension produces corrupted files when you use nonprintable codes in SSRS 2012
Reporting Services

VSTS BUG: 1993311 | 2923837
FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 1941216 | 2924827
FIX: dtexec.exe cannot execute a package when one of the configuration files does not exist in SQL Server 2012
Integration Services

VSTS BUG: 1966828 | 2926089
FIX: Error when you create new report subscriptions after you apply CU7 or CU8 for SQL Server 2012 SP1
SQL security

VSTS BUG: 2021036 | 2926217
FIX: Performance problems occur when database lock activity increases in SQL Server 2012
SQL service

VSTS BUG: 2021037 | 2926223
FIX: Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012
SQL service

VSTS BUG: 1972245 | 2926699
FIX: Operating system version information that is returned from SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012 is incorrect in Windows 8.1
SQL service

VSTS BUG: 2021038 | 2926712
FIX: Performance decreases after an ALTER INDEX…ONLINE operation is aborted in SQL Server 2012
SQL service

VSTS BUG: 1994633 | 2927511
FIX: Access violation may occur when trigger query joins large dataset in deleted/inserted table and runs in parallel in SQL server 2012
SQL performance

VSTS BUG: 1994687 | 2927524
FIX: MDX query does not reuse cache after clear cache command on different Measure Group with Non-Admin login in SSAS 2012
Analysis Services

VSTS BUG: 2021039 | 2927748
FIX: PowerPivot workbook cannot do data refresh in SharePoint 2013 after you apply SQL Server 2012 CU7
Analysis Services

VSTS BUG: 1999508 | 2927779
FIX: Database shows "recovery pending" state when you use TDE with EKM provider in SQL Server 2012
SQL security

VSTS BUG: 1999683 | 2927844
FIX: Large DistinctCount become slower in tabular mode in SQL Server 2012
Analysis Services

VSTS BUG: 1968031 | 2929193
FIX: SQL Server 2012 instance shuts down when you join database as secondary replica during AlwaysOn Availability Groups configuration
High Availability

VSTS BUG: 1929567 | 2929832
FIX: Decimal precision is incorrect when you calculate based on size of scale in SQL Server 2012 MDS
Data Quality Services (DQS)

VSTS BUG: 1924585 | 2929903
FIX: Merge agent fails when you apply snapshot in SQL Server 2012 instance if cross database dependencies are present
SQL service

VSTS BUG: 2024625 | 2931001
FIX: Distribution Agent skips applying sp_MSins_, sp_MSupd_, sp_MSdel_ stored procedures on a Subscriber that is initialized with Backup in SQL Server 2012
SQL service

VSTS BUG: 2032571 | 2931241
FIX: Access violation occurs when you update a table that has an XML calculated column in SQL Server 2012
SQL service

VSTS BUG: 2047687 | 2932120
FIX: SQL Server takes long time to open the databases after the recovery phase when the number of databases or database files or both is large in SQL Server 2012
SQL service

VSTS BUG: 2035100 | 2932340
FIX: Errors when you add member in SQL Server 2012 MDS
DQS

VSTS BUG: 2043007 | 2932341
FIX: Content of member details window is locked when you add a new member to MDS Explorer in SQL Server 2012 MDS
DQS

VSTS BUG: 1909862 | 2933780
FIX: Message is not removed from transmission queue even though the ACK is received successfully in an AlwaysOn availability group in SQL Server 2012
SQL service

VSTS BUG: 2022961 | 2934934
FIX: Non-yielding scheduler tries to close the listener for availability group in SQL Server 2012
High Availability

VSTS BUG: 2082516 | 2935681
FIX: Bing Map functionality does not work in Power View or SSRS 2012
Reporting Services

 

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

  • Microsoft SQL Server 2012 Analysis Services
  • 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

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 09

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

>> x86 | 2012_SP1_PPExcel_CU9_2931078_11_0_3412_x86
>> x86 | 2012_SP1_DAC_CU9_2931078_11_0_3412_x86
>> x86 | SQLServer2012_SP1_CU9_2931078_11_0_3412_x86
>> x64 | 2012_SP1_DAC_CU9_2931078_11_0_3412_x64
>> x64 | 2012_SP1_RSShrPnt_CU9_2931078_11_0_3412_x64
>> x64 | SQLServer2012_SP1_CU9_2931078_11_0_3412_x64
>> x64 | 2012_SP1_PPExcel_CU9_2931078_11_0_3412_x64

Enjoy!

[EN] SQL Server 2008 SP3 Cumulative Update 16 is available

LOGO__SQLServerW2K8reverseTwo weeks ago, two cumulative packages for two different SQL Server versions. This is the post about first of two. In this Cumulative Update No 16 (build no 10.00.5852.00) – I hope that is the last and highest number – for SQL Server 2008 Service Pack 3, Microsoft released… only two fixed bugs. Both for SQL Server Engine. Here are some deatails for this updates:

VSTS BUG: 1972234 | 2926699
FIX: Operating system version information that is returned from SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012 is incorrect in Windows 8.1
SQL service

VSTS BUG: 1988282 | 2927325
FIX: Thesaurus expansion for phrases returns unexpected results in SQL Server 2008
SQL service

This update could be applied for: Microsoft SQL Server 2008 Service Pack 3, when used with:

  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Integration Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 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 16

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

>> x86 | SQLServer2008_SP3_CU16_2936421_10_00_5852_x86
>> x64 | SQLServer2008_SP3_CU16_2936421_10_00_5852_x64
>> ia64 | SQLServer2008_SP3_CU16_2936421_10_00_5852_IA64

Enjoy!

[EN] 00:00 Saturday, 29th March – The Day of GWAB

It’s Midnight of March, 29th. Today is the GWAB Day. W0000t?

GWAB_logoGWAB – better known as Global Windows Azure Bootcamp is the second and last global event oriented to Windows Azure (keep mind for news from BUILD Conference in USA). One Year ago I was an attendee of FIRST AND ONLY ONE event in Poland, in Wroclaw. We played with rendering project and for few hours we have been in TOP10 in the World! This year is a little different, especially that I’m not only attendee, I’m speaking too.

GWAB – “In April of 2013 we held the first Global Windows Azure Bootcamp at more than 90 locations around the globe! This year we are again again offering up a one day deep dive class to help thousands of people get up to speed on developing Cloud Computing Applications for Windows Azure. In addition to this great learning opportunity the hands on labs are pooling ahuge global compute farm to perform diabetes research.

In Poland this year GWAB will be held in four cities Wrocław, Warsaw, Katowice and Szczecin. Most important and best place for it is of course in Wrocław (my city). But we are very happy to having competitors in different cities, especially that in all cities organizers focusing on different subjects and values of Microsoft Cloud Services. Of course based on different time zones – GWAB is now running and statistics too:

Captura_GWAB_progress

Out timm will join for this global event in next nine ours. Who is in our team? Great, great local community folks, influencers, leaders of local user groups, speakers, and more, more, more: Łukasz Gąsior {@lukaszgasior}, Gosia Borzęcka {@GosiaBorzecka}, Mirosław Pragłowski {@mpraglowski} and Paweł Łukasik {@pawel_lukasik}. And yes, I know no easy names for foreigners… What we will do? We prepared full, looong busy day with several sessions, unlimited coffee, lunch and of course unlimited level of fun. Here is our agenda:

09:15 | Superfarm Experiment | Łukasz Gąsior
09:45 | Introduction to Windows Azure | Gosia Borzęcka
11:00 | YouTube in Polish means Media Services in Cloud | Paweł Łukasik
12:30 | Windows Azure SQL Server Tips and Tricks | Tobiasz J. Koprowski
14:30 | Windows Azure Service Bus | Łukasz Gąsior
16:30 | Azure without ‘clickology’ | Mirosław Pragłowski
18:15 | Counting Azure | Paweł Łukasik

Exciting! And here is the link for our event site: http://gwab-2014.codingtv.pl/