March 2011 - Technical Rollup Mail – SQL Server
News
Customers are seeking industry-specific solutions utilizing Microsoft Business Intelligence platform stack
Microsoft offering New Oracle to Microsoft SQL Server Data Migration Assistant
Announcing Fast Track Data Warehouse 3.0 at TDWI World Conference
Premier
OpsVault — Operate and Optimize IT
Microsoft Premier Support UK - Site Home - TechNet Blogs
https://blogs.technet.com/b/mspremuk/
Other
https://blogs.technet.com/trm/default.aspx
Events/Webcasts
TechNet Webcast: Thrive Live! SQL Server Locking and Blocking Made Simple (Level 200)
A good working knowledge of how Microsoft SQL Server makes use of locking and transaction isolation levels can help you greatly improve an application's performance. In this webcast, we explore the SQL Server locking methodology and share techniques for enhancing query response times.
Documents
SQL 2008
Microsoft SQL Server Protocol Documentation
The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in Microsoft SQL Server 2008.
https://www.microsoft.com/downloads/en/details.aspx?familyid=91ef5106-944a-41e1-b3a0-5bd3f2356f32
New KB's
Other
Microsoft SQL Server 7.0 Standard Edition: PRB: Setup on Windows 2000 Fails Through Terminal Client
https://support.microsoft.com/kb/246694/en-US
Microsoft SQL Server 7.0 Standard Edition: PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow Error
https://support.microsoft.com/kb/281517/en-US
SQL 2005
Microsoft SQL Server 2005 Standard Edition: BUG: The full-text crawl takes a long time to finish when you create a full-text index on a column that has the varchar data type in SQL Server 2005
https://support.microsoft.com/kb/937086/en-US
SQL 2008
Microsoft SQL Server 2008 Analysis Services: SQL Server Installation Center may display English content on a localized version of SQL Server after applying a cumulative update
https://support.microsoft.com/kb/2496344/en-US
Microsoft SQL Server 2008 Service Pack 1: FIX: "Could not open global shared memory to communicate with performance DLL" warning when you run an SSIS 2008 or SSIS 2008 R2 package on a computer that is running Windows XP
https://support.microsoft.com/kb/2496375/en-US
SQL 2008 R2
Microsoft SQL Server 2008 R2 Datacenter: A drop-down list is always displayed instead of a search box when you double-click the value of the filter criteria box for an attribute in Entities Explorer of the SQL Server 2008 R2 MDS website
https://support.microsoft.com/kb/2486113/en-US
Microsoft SQL Server 2008 R2 Developer: FIX: SQL Server 2008 R2 performs poorly when most threads wait for the CMEMTHREAD wait type if the threads use table variables or temp tables to load or update rowsets
https://support.microsoft.com/kb/2492381/en-US
Microsoft SQL Server 2008 R2 Developer: Support policy for untested .NET Framework assemblies in the SQL Server CLR-hosted environment