Share via


March 2011 - Technical Rollup Mail – SQL Server

News

Customers are seeking industry-specific solutions utilizing Microsoft Business Intelligence platform stack

https://blogs.technet.com/b/dataplatforminsider/archive/2011/02/25/customers-are-seeking-industry-specific-solutions-utilizing-microsoft-business-intelligence-platform-stack.aspx

Microsoft offering New Oracle to Microsoft SQL Server Data Migration Assistant

https://blogs.technet.com/b/dataplatforminsider/archive/2011/02/23/microsoft-offering-new-oracle-to-microsoft-sql-server-data-migration-assistant.aspx

Announcing Fast Track Data Warehouse 3.0 at TDWI World Conference

https://blogs.technet.com/b/dataplatforminsider/archive/2011/02/14/announcing-fast-track-data-warehouse-3-0-at-tdwi-world-conference.aspx

Premier

OpsVault — Operate and Optimize IT

https://www.opsvault.com/

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)

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

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

https://support.microsoft.com/kb/922672/en-US