April 2011 – Technical Rollup Mail – SQL Server


SQL Server 2008 R2 Offers Enhancements, New Management Capabilities


Is Microsoft’s SQL Server really cheaper than Oracle ?


Seven Reasons to Care About SQL Server 2008 R2


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





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


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"


SQL 2008

Microsoft SQL Server 2008 Analysis Services: Cumulative update package 3 for SQL Server 2008 Service Pack 2


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


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


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


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


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


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


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


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


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


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"


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


Comments (0)