April 2011 - Technical Rollup Mail - SQL Server
News
SQL Server 2008 R2 Offers Enhancements, New Management Capabilities
Is Microsoft’s SQL Server really cheaper than Oracle ?
https://www.networkworld.com/community/node/63390
Seven Reasons to Care About SQL Server 2008 R2
https://www.infoworld.com/d/data-management/seven-reasons-care-about-sql-server-2008-r2-631
Microsoft Announces Additional Details about System Center Advisor (formerly codename “Atlanta”)
Virtualize SQL Server With Hyper-V and System Center
Important support changes for SQL Server 2000 and SQL Server 2005
Other
https://blogs.technet.com/trm/default.aspx
Events/Webcasts
TechNet Webcast: Talk Technet. Edwin Sarmiento on SQL Server DBA (Level 100)
Talk TechNet is all about discussing topics and trends in the world of IT Professionals. In this show we’ll have guest Edwin Sarmiento. Edwin is a Microsoft SQL MVP. Call in and join us for what promises to be a lively 60 minute session. Get some burning questions answered on SQL Server DBA tasks.
New KB's
SQL 2005
Microsoft SQL Server 2005 Enterprise Edition: FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005
https://support.microsoft.com/kb/2515286
Microsoft SQL Server 2005 Standard Edition: FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page"
https://support.microsoft.com/kb/969142
SQL 2008
Microsoft SQL Server 2008 Analysis Services: Cumulative update package 3 for SQL Server 2008 Service Pack 2
https://support.microsoft.com/kb/2498535
Microsoft SQL Server 2008 Developer Edition: FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005 or SQL Server 2008
https://support.microsoft.com/kb/2498818
Microsoft SQL Server 2008 Developer Edition: FIX: "The integer value is out of range" error when you pass a bigint value as the last_sync_version argument of the CHANGETABLE function in SQL Server 2008
https://support.microsoft.com/kb/2519358
Microsoft SQL Server 2008 Developer Edition: FIX:A query that has a CONTAINS predicate in a WHERE clause takes a long time to compile in SQL Server 2008
https://support.microsoft.com/kb/2491510
Microsoft SQL Server 2008 Developer Edition: FIX: "Insufficient data for an Image" error when you open a .pdf file that is exported from a SQL Server 2008 Reporting Services environment
https://support.microsoft.com/kb/2506795
Microsoft SQL Server 2008 Developer Edition: FIX: The dbo schema is preappended when you use a custom stored procedure in the sp_addarticle stored procedure
https://support.microsoft.com/kb/2509659
Microsoft SQL Server 2008 Developer Edition: FIX: "The merge process could not access row data" error occurs when the Merge Agent stops, and rows are set to 4 in the genstatus column in the msmerge_genhistory system table
https://support.microsoft.com/kb/2478514
Microsoft SQL Server 2008 Integration Services: You can now use Package Installation Wizard (Dtsinstall.exe) to run the deployment manifest file of an SSIS package when SSIS 2008 is not installed
https://support.microsoft.com/kb/2510668
Microsoft SQL Server 2008 Reporting Services: FIX: Incorrect newsletter-style report when a text box value extends from one column to another in SSRS 2008 if you use hard-page-break renderer format
https://support.microsoft.com/kb/2497585
Microsoft SQL Server 2008 Service Pack 1: FIX: A common table expression-based query that uses the CHANGETABLE function runs very slowly in SQL Server 2008 Service Pack 1
https://support.microsoft.com/kb/2476322
Microsoft SQL Server 2008 Standard Edition: FIX: Error message when you try to bulk insert data into a table that contains a DATE type column that uses a US date format in SQL Server 2008: "Bulk load data conversion error"
https://support.microsoft.com/kb/968215
Microsoft SQL Server 2008 Standard Edition: FIX: You receive error messages when you perform a population for a large full-text index in SQL Server 2008