October 2011 - Technical Rollup Mail - SQL
News
Whats new in PowerPivot for Excel
Answers & Links
130 Characters Could Get You Into PASS
Master Data Services – What’s New in SQL Server “Denali”
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
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