Share via


April 2011 - Technical Rollup Mail - SQL Server

News

SQL Server 2008 R2 Offers Enhancements, New Management Capabilities

https://www.eweek.com/c/a/IT-Infrastructure/SQL-Server-2008-R2-Offers-Enhancements-New-Management-Capabilities-518969

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”)

https://blogs.technet.com/b/dataplatforminsider/archive/2011/03/24/microsoft-announces-additional-details-about-system-center-advisor-formerly-codename-atlanta.aspx

Virtualize SQL Server With Hyper-V and System Center

https://blogs.technet.com/b/dataplatforminsider/archive/2011/03/22/virtualize-sql-server-with-hyper-v-and-system-center.aspx

Important support changes for SQL Server 2000 and SQL Server 2005

https://blogs.technet.com/b/dataplatforminsider/archive/2011/03/09/important-support-changes-for-sql-server-2000-and-sql-server-2005.aspx

Other

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

Events/Webcasts

TechNet Webcast: Talk Technet. Edwin Sarmiento on SQL Server DBA (Level 100)

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032483824&EventCategory=4&culture=en-US&CountryCode=US

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

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