News
Follow up to the SQL Server Fireside Chats after the 24Hours of PASS Sessions
http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/27/follow-up-to-the-sql-server-fireside-chats-after-the-24-hours-of-pass-sessions.aspx
A closer look at the HADR capabilities of the HPEnterprise Database Consolidation Appliance
http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/25/a-closer-look-at-the-hadr-capabilities-of-the-hp-enterprise-database-consolidation-appliance.aspx
Dell Parallel Data Warehouse Appliance Announced @PASSSummit!
http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/21/dell-parallel-data-warehouse-appliance-release.aspx
Microsoft SQL Server 2008 SP3 Now Available
http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/06/sql-server-2008-sp3-is-now-available.aspx
Other
http://blogs.technet.com/trm/default.aspx
Events
SQL PASS Summit 2011
http://www.sqlpass.org/summit/2011/Registration.aspx
Documents
SQL Server 2012 Product Guide V2
http://go.microsoft.com/fwlink/?LinkID=2258142
New KB Articles
SQL 7.0
Microsoft SQL Server 7.0Standard Edition
PRB: ARCserveIT Open File Manager(Ofant.sys) May Affect SQL Server 7.0 Disk IO Performance
https://premier.microsoft.com/kb/275555
SQL 2000
Microsoft SQL Server 2000Developer Edition
FIX: Error messages when you tryto update table rows or insert table rows into a table in SQL Server 2000:"644" or "2511"
http://support.microsoft.com/kb/929440
FIX: A memory leak may occur whena client application uses the Dbmslpcn.dll shared memory network libraryversion 2000.80.828.0 and connects to a local computer that is running SQLServer 2000
http://support.microsoft.com/kb/900961
Microsoft SQL Server 2000Enterprise Edition
BUG: IsAlive check does not rununder the context of the BUILTIN\Administrators account in SQL Server 2000Enterprise Edition
http://support.microsoft.com/kb/291255
Microsoft SQL Server 2000Personal Edition
FIX: You may receive an accessviolation error message when you run a linked server query that includes asubquery
http://support.microsoft.com/kb/911569
Microsoft SQL Server 2000Standard Edition
Query performance may decreasewhen you try to run a query in a parallel plan in SQL Server 2000
http://support.microsoft.com/kb/919638
FIX: The synchronization processmay take a long time when you synchronize merge replication publications in SQLServer 2000
http://support.microsoft.com/kb/914439
Considerations for the"autogrow" and "autoshrink" settings in SQL Server
http://support.microsoft.com/kb/315512
Application errors occur after yourun Xmlinst.exe on production servers
http://support.microsoft.com/kb/278636
How to enable SSL encryption forSQL Server 2000 if you have a valid Certificate Server
http://support.microsoft.com/kb/276553
How to use Kerberos authenticationin SQL Server
http://support.microsoft.com/kb/319723
Microsoft SQL Server 2000Windows CE Edition
How to upgrade an InternetInformation Services server after applying SQL Server 2000 Service Pack 3 orSQL Server 2000 Service Pack SP3a
http://support.microsoft.com/kb/330014
SQL 2005
Microsoft SQL Server 2005Analysis Services
FIX: The sum total of a columncontains incorrect data when you browse or query a cube in SQL Server 2005Analysis Services
http://support.microsoft.com/kb/926775
FIX: You may receive unexpectedresults when you run an MDX query in SQL Server 2005 Analysis Services
http://support.microsoft.com/kb/926515
FIX: In SQL Server 2005 AnalysisServices, the query may not return all the expected rows when you use theTopCount function in an MDX query
http://support.microsoft.com/kb/926235
FIX: Error message when you run aquery against a cube that contains linked objects in SQL Server 2005 AnalysisServices: "Internal error An unexpected error occurred"
http://support.microsoft.com/kb/925566
An update is available for SQLServer 2005 Analysis Services that adds partition information to the existingschema that is returned by the DISCOVER_PARTITION_INFO rowset
http://support.microsoft.com/kb/924939
FIX: Unfiltered results may begenerated when you use a drillthrough action on a dimension that is stored inthe ROLAP storage mode in SQL Server 2005 Analysis Services
http://support.microsoft.com/kb/923477
FIX: An MDX query may never finishwhen you run the MDX query against a parent/child dimension in SQL Server 2005Analysis Services
http://support.microsoft.com/kb/923476
FIX: A member property is returnedin an unexpected data type when you call the"IMDDataset::GetAxisRowset" interface in SQL Server 2005 AnalysisServices
http://support.microsoft.com/kb/922798
FIX: A query may return incorrectresults when you run the query against a SQL Server 2005 Analysis Services cube
http://support.microsoft.com/kb/920340
FIX: You may receive incorrectresults when you run a Multidimensional Expressions (MDX) query that involves acalculated member and the autoexist functionality in SQL Server 2005 AnalysisServices
http://support.microsoft.com/kb/919955
FIX: SQL Server Analysis Services2005 system performance may be slow after you use the ADOMD.NET data providerto run an MDX query that returns a large result set from a cube
http://support.microsoft.com/kb/919731
FIX: You may receive unexpectedresults when you query data from a set that uses the MDX Crossjoin function inSQL Server 2005 Analysis Services
http://support.microsoft.com/kb/915796
FIX: An MDX query that uses theunique name property returns incorrect results when you use a client tool torun the query in SQL Server 2005 Analysis Services
http://support.microsoft.com/kb/914597
FIX: You cannot connect to SQLServer 2000 Analysis Services when you configure the Office Web Components datasource connection string to use OLE DB Provider for Analysis Services 9.0 toconnect to SQL Server 2005 Analysis Services
http://support.microsoft.com/kb/912631
Microsoft SQL Server 2005Developer Edition
Error message when you try toinstall SQL Server 2005 on a volume mount point: "There is not enoughspace on the destination disk for the current SQL Server installation"
http://support.microsoft.com/kb/934012
You cannot connect to a localinstance of SQL Server on a Windows XP-based computer or on a Windows2000-based computer when you use "localhost" in the pipe name
http://support.microsoft.com/kb/929152
How do I open the firewall portfor SQL Server on Windows Server 2008?
http://support.microsoft.com/kb/968872
Microsoft SQL Server 2005Enterprise Edition
FIX: You receive error 1456 whenyou try to add a witness to a DBM session in SQL Server 2005
http://support.microsoft.com/kb/930284
Microsoft SQL Server 2005Express Edition
Error message when you try touninstall a SQL Server 2005 Express Edition hotfix package: "1731 Thesource installation package for the product [2] is out of sync with the clientpackage"
http://support.microsoft.com/kb/955250
Microsoft SQL Server 2005Reporting Services
FIX: Error message when you open areport in Report Manager in SQL Server 2005 Reporting Services: "An errorhas occurred during report processing. There is already an open DataReaderassociated with this Command which must be closed first"
http://support.microsoft.com/kb/927290
FIX: Error message when you useReport Builder after you install SQL Server 2005 Reporting Services SP1:"Short time pattern does not include hours and minutes"
http://support.microsoft.com/kb/923623
Microsoft SQL Server 2005Standard Edition
The remote instance of SQL Server2000 does not stop when you use SQL Server Management Studio on the server thatis running SQL Server 2005
http://support.microsoft.com/kb/930878
FIX: A script task or a scriptcomponent is executed multiple times in duplicate when you run packages thatcontain script tasks or script components in parallel in SSIS
http://support.microsoft.com/kb/928323
FIX: You may receive an errormessage when you run a CLR stored procedure or CLR function that uses a contextconnection in SQL Server 2005
http://support.microsoft.com/kb/928083
FIX: You may experience very largegrowth increments of a principal database after you manually fail over adatabase mirroring session in SQL Server 2005
http://support.microsoft.com/kb/925277
BUG: You may receive an accessviolation error message when you try to run an SSIS package in SQL Server 2005
http://support.microsoft.com/kb/924016
FIX: SQL Server 2005 mayoverestimate the cardinality of the JOIN operator when a SQL Server 2005 querycontains a join predicate that is a multicolumn predicate
http://support.microsoft.com/kb/920346
FIX: System performance may beslow when an application submits many queries against a SQL Server 2005database that uses simple parameterization
http://support.microsoft.com/kb/920206
FIX: A query plan is not cached inSQL Server 2005 when the text of the hint is a large object
http://support.microsoft.com/kb/918882
FIX: You cannot restore the logbackups on the mirror server after you remove database mirroring for the mirrordatabase in SQL Server 2005
http://support.microsoft.com/kb/915793
On a computer that has a multicoreprocessor, you may be unable to install SQL Server 2005
http://support.microsoft.com/kb/954835
Error message when you execute aCLR routine or use an assembly in SQL Server 2005: "Assembly in host storehas a different signature than assembly in GAC. (Exception from HRESULT:0x80131050)"
http://support.microsoft.com/kb/949080
FIX: The synchronization operationof a merge replication times out in Microsoft SQL Server 2005
http://support.microsoft.com/kb/953568
SQL 2008
Microsoft SQL Server 2008Developer Edition
The Full Text Search componentinstallation fails when you try to install the SQL Server 2008 database enginefrom an installation DVD on a computer that has SQL Server 2008 Express editioninstalled
http://support.microsoft.com/kb/967103
Microsoft SQL Server 2008Developer
FIX: "Unexpected error fromSE OLEDB interface" error when you run a full-text search query in SQLServer 2008
http://support.microsoft.com/kb/2606301
FIX: XML data loss when a mergereplication encounters a foreign key violation error in SQL Server 2005, in SQLServer 2008, or in SQL Server 2008 R2
http://support.microsoft.com/kb/2591902
FIX: "Server: Msg 7359"error when you run a distributed query in SQL Server 2008 or in SQL Server 2008R2 if a schema version is updated more than five times
http://support.microsoft.com/kb/2588970
Microsoft SQL Server 2008 Developer
SQL Server Replication Agents mayexhibit blocking when applying snapshot
http://support.microsoft.com/kb/2615479
Microsoft SQL Server 2008Enterprise Edition
FIX: SSIS Checkpoint restores an incorrectvariable value for an Execute SQL Task item of a For Loop Container item inSSIS 2008 if an SSIS package executes again after it fails or stops
http://support.microsoft.com/kb/2583994
FIX: Size of a data file that iscommitted by online page compression is larger than that is committed byoffline page compression in SQL Server 2008 or in SQL Server 2008 R2
http://support.microsoft.com/kb/2574973
FIX: Assertion failure or otherissues occur when you run a DML query against a table or a view that has twoindexes in SQL Server 2008
http://support.microsoft.com/kb/2542225
Microsoft SQL Server 2008Integration Services
FIX: Incorrect results when youcommit the Unpivot transformation to a SSIS package in SSIS 2008 or in SSIS 2008R2
http://support.microsoft.com/kb/2580224
Microsoft SQL Server 2008 R2Analysis Services
FIX: Internal error when you run aMDX query that uses the Descendants function after you upgrade from SSAS 2005to SSAS 2008 or to SSAS 2008 R2
http://support.microsoft.com/kb/2605756
FIX: SSAS 2008 or SSAS 2008 R2crashes when you perform synchronization in TFS 2010 after you rebuild a cube
http://support.microsoft.com/kb/2591295
Analysis Services SharePointintegration Dll is not updated with SP1 for SQL Server 2008 R2
http://support.microsoft.com/kb/2619924
Microsoft SQL Server 2008Reporting Services
FIX: Me.Value is evaluatedincorrectly when it is used to access the Value property of a text box in aSSRS 2008 report if the report has a page header or a page footer
http://support.microsoft.com/kb/2608108
Microsoft SQL Server 2008Service Pack 1
Cumulative update package 16 forSQL Server 2008 Service Pack 1
http://support.microsoft.com/kb/2582282