Share via


October 2011 - Technical Rollup Mail - SQL

News

Whats new in PowerPivot for Excel

https://blogs.technet.com/b/dataplatforminsider/archive/2011/09/28/what-s-new-in-powerpivot-for-excel-with-sql-server-code-name-quot-denali-quot-ctp3.aspx

Answers & Links

https://blogs.technet.com/b/dataplatforminsider/archive/2011/09/22/answers-and-links-for-the-questions-asked-during-the-24hop-sql-denali-challenge.aspx

130 Characters Could Get You Into PASS

https://blogs.technet.com/b/dataplatforminsider/archive/2011/09/20/130-characters-could-get-you-into-pass-summit-2011.aspx

Master Data Services – What’s New in SQL Server “Denali”

https://blogs.technet.com/b/dataplatforminsider/archive/2011/08/24/master-data-services-what-s-new-in-sql-server-code-name-denali-ctp3.aspx

Other

https://blogs.technet.com/trm/default.aspx

Events

SQL PASS Summit 2011

https://www.sqlpass.org/summit/2011/

Documents

SQL Server Code Name “Denali” CTP3 Product Guide

https://www.microsoft.com/download/en/details.aspx?id=27069

SQL Server Code Name “Denali” Data Sheet

https://download.microsoft.com/download/D/3/3/D3339887-EE32-4780-B5C6-E819F62E2BBC/SQL_Server_Denali_Overview.pdf

New KB Articles

SQL 7.0

Microsoft SQL Server 7.0 Standard Edition

BUG: You receive an "OLE DB Provider 'atlprov' reported an error" error message when you try to use an ATL wizard-generated OLE DB Provider in Visual C++

https://support.microsoft.com/kb/198520

SQL 2008

Microsoft SQL Server 2008 Developer Edition

FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008

https://support.microsoft.com/kb/2591461

Microsoft SQL Server 2008 Developer

FIX: High memory usage when you run Replication Snapshot Agent in SQL Server 2008

https://support.microsoft.com/kb/2606301

Microsoft SQL Server 2008 Developer

FIX: XML data loss when a merge replication encounters a foreign key violation error in SQL Server 2005, in SQL Server 2008, or in SQL Server 2008 R2

https://support.microsoft.com/kb/2591902

Microsoft SQL Server 2008 Developer

FIX: "Server: Msg 7359" error when you run a distributed query in SQL Server 2008 or in SQL Server 2008 R2 if a schema version is updated more than five times

https://support.microsoft.com/kb/2588970

Microsoft SQL Server 2008 Developer

SQL Server Replication Agents may exhibit blocking when applying snapshot

https://support.microsoft.com/kb/2615479

Microsoft SQL Server 2008 Enterprise Edition

FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 if an SSIS package executes again after it fails or stops

https://support.microsoft.com/kb/2583994

Microsoft SQL Server 2008 Enterprise Edition

FIX: Size of a data file that is committed by online page compression is larger than that is committed by offline page compression in SQL Server 2008 or in SQL Server 2008 R2

https://support.microsoft.com/kb/2574973

Microsoft SQL Server 2008 Enterprise Edition

FIX: Assertion failure or other issues occur when you run a DML query against a table or a view that has two indexes in SQL Server 2008

https://support.microsoft.com/kb/2542225

Microsoft SQL Server 2008 Integration Services

FIX: Incorrect results when you commit the Unpivot transformation to a SSIS package in SSIS 2008 or in SSIS 2008 R2

https://support.microsoft.com/kb/2580224

Microsoft SQL Server 2008 R2 Analysis Services

FIX: Internal error when you run a MDX query that uses the Descendants function after you upgrade from SSAS 2005 to SSAS 2008 or to SSAS 2008 R2

https://support.microsoft.com/kb/2605756

Microsoft SQL Server 2008 R2 Analysis Services

FIX: SSAS 2008 or SSAS 2008 R2 crashes when you perform synchronization in TFS 2010 after you rebuild a cube

https://support.microsoft.com/kb/2591295

Microsoft SQL Server 2008 R2 Analysis Services

Analysis Services SharePoint integration Dll is not updated with SP1 for SQL Server 2008 R2

https://support.microsoft.com/kb/2619924

Microsoft SQL Server 2008 Reporting Services

FIX: Me.Value is evaluated incorrectly when it is used to access the Value property of a text box in a SSRS 2008 report if the report has a page header or a page footer

https://support.microsoft.com/kb/2608108

Microsoft SQL Server 2008 Service Pack 1

Cumulative update package 16 for SQL Server 2008 Service Pack 1

https://support.microsoft.com/kb/2582282