[EN] SQL Server 2012 Service Pack 1 Cumulative Update 3 is available

LOGO__SQLServer2012The second update packages in March (till today) which Microsoft released for SQL Server Environment,  is for SQL Server 2012 with Service Pack 1.

In this Cumulative Update [build 11.0.3349.0.] Microsoft resolved about FORTY bugs which could be applies to:

  • Microsoft SQL Server 2012 with Service Pack 1, when used with:
    • Microsoft SQL Server 2012 Developer
    • Microsoft SQL Server 2012 Enterprise
    • Microsoft SQL Server 2012 Standard
    • Microsoft SQL Server 2012 Web
  • and is NOT for Microsoft SQL Server 2012 Business Edition

Here is the list of published and resolved bugs:

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

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

VSTS BUG: 1169525 | 2764343
FIX: The DateTime parameter is not displayed by using the regional setting format of a SharePoint website in SSRS 2012

VSTS BUG: 1169524 | 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: 1201576 | 2772525
FIX: Improved Metadata Discovery process performance in SQL Server Native Client for SQL Server 2012

VSTS BUG: 1201571 | 2783983
FIX: Scroll bar functionality too sensitive when you drag components in the control flow or data flow designer window in SSDT

VSTS BUG: 1145230 | 2791496
FIX: Security token leak occurs when you run more than two PowerShell steps by using a proxy account in a SQL Server Agent job

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

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

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

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

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

VSTS BUG: 1167499 | 2801889
FIX: You cannot open a PowerPivot workbook after you install SQL Server 2012 SP1 PowerPivot for Excel

VSTS BUG: 1168983 | 2803065
FIX: Memory leak when you run queries against a temporary table in a nested stored procedure in SQL Server 2012

VSTS BUG: 1170481 | 2803529
FIX: Poor performance in SQL Server 2012 when you run a SQL Server trace

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

VSTS BUG: 1171274 | 2803911
FIX: "Errors in cell writeback" message when you run UPDATE CUBE statements after you upgrade to SSAS 2012

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

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

VSTS BUG: 1174860 | 2806601
FIX: Error when you open a tabular model file in SQL Server 2012

VSTS BUG: 1175459 | 2806979
FIX: You experience poor performance when you run a query against an RCSI-enabled table in SQL Server 2012

VSTS BUG: 1175526 | 2807487
FIX: Dimension property is not translated correctly when you query the property by using an MDX query that has the tabular format configured in SSAS 2012

VSTS BUG: 1201573 | 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: 1150340 | 2809127
FIX: Error when you edit the connection string in Analysis Services Deployment Wizard tool after you apply SQL Server 2012 SP1

VSTS BUG: 1183628 | 2809338
FIX: High "log write waits" counter value on a SQL Server 2012 node

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

VSTS BUG: 1161808 | 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: 1201572 | 2811607
FIX: MDX query returns no results when a row-level security user runs an MDX query in SQL Server 2012

VSTS BUG: 1165556 | 2811723
FIX: Access violation and error 2905 when you run a Service Broker application in SQL Server 2012

VSTS BUG: 1186917 | 2813214
FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server

VSTS BUG: 1190509 | 2814780
FIX: Value of the NORECOMPUTE property for a partitioned index is not retained after you rebuild the index in SQL Server 2012

VSTS BUG: 1200058 | 2818780
FIX: Incorrect background color returned if you export an SSRS 2012 report to Microsoft Excel

VSTS BUG: 1195332 | 2819382
FIX: Incorrect decimal separator is used when you browse data in MDS in SQL Server 2012

VSTS BUG: 1195802 | 2819383
FIX: Business rule does not work when a member code contains some special characters in MDS in SQL Server 2012

VSTS BUG: 1136313 | 2819662
FIX: SQL Server 2012 experiences performance issues in NUMA environments

VSTS BUG: 1201432 | 2821686
FIX: SSAS 2012 freezes when a scheduled data update starts while you run complex DAX queries

VSTS BUG: 1182790 | 2823086
FIX: "The MDX function failed because the coordinate for the ‘AttributeName’ attribute contains a set." message when you run an MDX query in SQL Server 2012

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

 

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

  • SQL Server 2012 | All (Global) | x86 | 2012_SP1_PPExcel_CU3_2812412_11_0_3349_x86
  • SQL Server 2012 | All (Global) | x86 | SQLServer2012_SP1_CU3_2812412_11_0_3349_x86
  • SQL Server 2012 | All (Global) | x64 | 2012_SP1_DAC_CU3_2812412_11_0_3349_x64
  • SQL Server 2012 | All (Global) | x64 | 2012_SP1_PPExcel_CU3_2812412_11_0_3349_x64
  • SQL Server 2012 | All (Global) | x64 | SQLServer2012_SP1_CU3_2812412_11_0_3349_x64

Enjoy!

[EN] SQL Server 2008 Service Pack 3 Cumulative Update 10 is available

LOGO__SQLServer2008SP3In March (till today) Microsoft released two packages of updates for SQL Server Environment. First post is for SQL Server 2008 with Service Pack 3.

In this Cumulative Update 10 [version build: 10.00.5835.00] Microsoft resolved about twelve bugs which could be applies to:

  • Microsoft SQL Server 2008 with Service Pack 3, when used with:
    • Microsoft SQL Server 2008 Enterprise
    • Microsoft SQL Server 2008 Developer
    • Microsoft SQL Server 2008 Standard
    • Microsoft SQL Server 2008 Standard Edition for Small Business
    • Microsoft SQL Server 2008 Web
    • Microsoft SQL Server 2008 Workgroup
    • Microsoft SQL Server 2008 Express with Advanced Services
    • Microsoft SQL Server 2008 Express

Here is the list of resolved bugs:

VSTS BUG: 1182695 | 2504090
FIX: Access violation or incorrect result when you insert data into or update a new partition of a partitioned table in SQL Server 2008 R2 or SQL Server 2008

VSTS BUG: 1181850;1182472 | 2566163
FIX: Poor performance when table-valued functions use many table variables in SQL Server 2008 R2 or SQL Server 2008

VSTS BUG: 878127;877088 | 2675522
FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012

VSTS BUG: 1178048;1144394;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 or in SQL Server 2008

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

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

VSTS BUG: 1186852 | 2812884
FIX: Index size increases significantly after you rebuild the index online and RCSI is enabled in SQL Server 2008

VSTS BUG: 1167994 | 2821836
FIX: Incorrect result when you run an MDX query that returns multiple calculated members in SSAS 2008

 

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 10

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 | All (Global)| x86| SQLServer2008_SP3_CU10_2814783_10_00_5835_x86
  • SQL Server 2008 | All (Global) | x64 | SQLServer2008_SP3_CU10_2814783_10_00_5835_x64
  • SQL Server 2008 | All (Global) | ia64 | SQLServer2008_SP3_CU10_2814783_10_00_5835_IA64

Enjoy!

[EN] Changes “in plus” in Windows Azure: new regions ad add-on

CapturawasWindows Azure Team published a week ago interesting informations about changes in Windows Azure Environment.

First news is about expanding markets for Windows Azure Store for next twenty five countries, including Poland. Here is the list: Australia, Belgium, Brazil, Chile, Colombia, Costa Rica, Czech Republic, Finland, Greece, Hong Kong SAR, Hungary, Israel, Luxembourg, Malaysia, Mexico, Netherlands, New Zealand, Peru, Poland, Portugal, Romania, Singapore, Sweden, Switzerland, and Trinidad and Tobago. And now with “old countries” (United States, Canada, Denmark, France, Germany, Ireland, Italy, Japan, South Korea, Spain, and United Kingdom) Windows Azure Store is more available for customers in Europe.

Second news is aboud add-on’s. Using Windows Azure Store customers (and developers of course) have possibillity (it’s opportunity for devs) to providing, using, producing special add-ons for applications and data. List is not very big, but is interesting:

For App Services

For Data

 

And now Microsoft released four new add-on:

For more information, go to Windows Azure Store site.