Share via


December 2010 - Technical Rollup Mail - SQL

News

Announcing an updated version of
PowerPivot for Excel

https://blogs.technet.com/b/dataplatforminsider/archive/2010/10/28/announcing-an-updated-version-of-powerpivot-for-excel.aspx

HELP SHAPE THE FUTURE OF SQL
SERVER!!!

https://blogs.technet.com/b/dataplatforminsider/archive/2010/10/27/help-shape-the-future-of-sql-server.aspx

CIOs share insight on best
practices and challenges in today’s enterprise environment

https://blogs.technet.com/b/dataplatforminsider/archive/2010/10/21/cios-share-insight-on-best-practices-and-challenges-in-today-s-enterprise-environment.aspx

Other

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

 

 

Downloads

SQL 2005

SSMA for Access v4.2

Microsoft SQL Server Migration Assistant (SSMA) is a toolkit
that dramatically cuts the effort, cost, and risk of migrating from Access to
SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.

https://www.microsoft.com/downloads/en/details.aspx?familyid=5abe098d-c7e1-46c6-994a-09a2856eef0b
 

 

SQL Server 2005 Express Edition SP4 CTP

Microsoft SQL Server 2005 Express Edition is a free,
easy-to-use, lightweight version of SQL Server 2005. It is fast and easy to
learn, allowing you to quickly develop and deploy dynamic data-driven
applications.

https://www.microsoft.com/downloads/en/details.aspx?familyid=c4501128-ede3-4226-a54c-a620dd5691a2
 

 

SQL Server 2005 SP4 CTP

Download Service Pack 4 for Microsoft SQL Server 2005.

https://www.microsoft.com/downloads/en/details.aspx?familyid=ca6523d1-d265-4c15-b89a-9268e5e3cda4
 

 

Partial Database Availability

SQL Server 2005 features that enable appropriately designed
solutions to achieve partial availability and remain online even after a disk
subsystem hardware failure.

https://www.microsoft.com/downloads/en/details.aspx?familyid=11a7ae65-c792-47ea-8b4e-fb87d0ece9b6
 

 

 

SQL 2008

Contoso Sales Manager Sample Solution

This solution allows you to track contacts from an External
System database (a sample database provided free by Microsoft named “Adventure
Works”) in Outlook as native Outlook contacts, with the ability to create, edit
and delete customers to the backend External System.

https://www.microsoft.com/downloads/en/details.aspx?familyid=0fef46fa-5472-451a-8a99-0e3039126336
 

 

Partial Database Availability

SQL Server 2005 features that enable appropriately designed
solutions to achieve partial availability and remain online even after a disk
subsystem hardware failure.

https://www.microsoft.com/downloads/en/details.aspx?familyid=11a7ae65-c792-47ea-8b4e-fb87d0ece9b6
 

 

 

Events/Webcasts

SPLA 101 Orientation

Wednesday, December 01, 2010 11:00 AM Pacific Time (US
& Canada)

Please join our SPLA 101 Orientation for New providers who
have recently enrolled in SPLA. The course agenda is below:

Course Agenda

Agreement Benefits

Services Provider Use Rights (SPUR)

Media Requests, License Keys, and Product Activation

Microsoft Partner Network Hosting Competency Membership

Licensing & Reporting Best Practices

Reseller Contacts

Open Q&A

 

 

https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032467116&culture=en-US
 

 

New KB's

Other

Microsoft SQL Server 6.5 Standard Edition: Error
0x84B30002 when you perform Edition Upgrade of a SQL Server instance

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

 

Microsoft SQL Server 7.0 Standard Edition: Description
of SQL Server blocking caused by compile locks

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

 

SQL 2005

Microsoft SQL Server 2005 Analysis Services: An SPN
for the SQL Server Browser service is required when you establish a connection
to a named instance of SQL Server Analysis Services or of SQL Server

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

 

Microsoft SQL Server 2005 Developer Edition: Use of
system filter drivers can lead to SQL Server Database Engine performance
degradation and consistency problems

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

 

Microsoft SQL Server 2005 Standard Edition: List of
the bugs that are fixed in SQL Server 2005 Service Pack 4 CTP

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

 

Microsoft SQL Server 2005 Standard Edition: FIX: A
database shrink may not succeed or unexplained transaction log growth may occur
in SQL Server 2005

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

 

SQL 2008

Microsoft SQL Server 2008 Analysis Services: FIX: The
memory usage in SSAS 2008 may be larger than in SSAS 2005 when you create a
local cube

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

 

Microsoft SQL Server 2008 Analysis Services: Where to
find information about the latest SQL Server builds

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

 

Microsoft SQL Server 2008 Developer: FIX: High CPU
usage when you run a SQL Server Agent job in SQL Server 2008 if a column of a
dynamic SELECT statement has a value that is many characters long

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

 

Microsoft SQL Server 2008 Developer: "Bulk
Insert with another outstanding result set should be run with XACT_ABORT
on" error message may occur when you run a DTC or MARS transaction in SQL
Server 2008

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

 

Microsoft SQL Server 2008 Developer: Cumulative
update package 11 for SQL Server 2008 Service Pack 1

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

 

Microsoft SQL Server 2008 Developer: FIX: A
performance condition alert is incorrectly raised in SQL Server 2008 if a
case-sensitive collation is configured

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

 

Microsoft SQL Server 2008 Developer: You may
experience connectivity issues if SQL Server service account delegation
settings are misconfigured

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

 

Microsoft SQL Server 2008 Developer: You may
experience connectivity issues to SQL Server if SPNs are misconfigured

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

 

Microsoft SQL Server 2008 Developer: FIX: MOF
compilation errors occur and Setup fails for SQL Server 2008

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

 

Microsoft SQL Server 2008 Developer: Introduction to
the Microsoft StreamInsight 1.1 release

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

 

Microsoft SQL Server 2008 Enterprise: FIX: High
memory consumption may occur when you rebuild a single partition of the heap
table in SQL Server 2008

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

 

Microsoft SQL Server 2008 Enterprise: FIX: You may
receive an incorrect result when you run a query that uses the ROW_NUMBER
function together with a left outer join in SQL Server 2008

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

 

Microsoft SQL Server 2008 Enterprise: FIX: A SQL
Server Agent job incorrectly runs after the specified end date in SQL Server
2008

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

 

Microsoft SQL Server 2008 Enterprise: FIX: A column
that uses the DATETIME data type does not replicate to an Oracle subscriber by
using a transactional replication in SQL Server 2008

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

 

Microsoft SQL Server 2008 Enterprise: FIX: The
sys.syscommittab system table is not cleaned up after the retention period for
change tracking in SQL Server 2008

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

 

Microsoft SQL Server 2008 Enterprise: FIX: The
columns do not replicate correctly when you use Web synchronization for a merge
replication in SQL Server 2008 if a column contains a NULL value

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

 

Microsoft SQL Server 2008 Enterprise: FIX:
"ConnConnectAndSetCryptoForXpstar failed (0)"error message occurs
when you try to start the SQL Server Agent service from a Remote Desktop
session in SQL Server 2008

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

 

Microsoft SQL Server 2008 Reporting Services: FIX:
The application stops responding for 100 seconds and then a SoapException
exception occurs after an application calls the ReportExecutionService.Render2
method in SQL Server 2008 Reporting Services

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

 

Microsoft SQL Server 2008 Reporting Services: FIX: An
embedded image of a report is incorrectly displayed as a red cross in SQL
Server 2008 Reporting Services

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

 

Microsoft SQL Server 2008 Reporting Services: FIX:
Error message and the report is not printed from the Report Manager website in
SSRS 2008 if you use Internet Explorer Protected Mode in Internet Explorer 8

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

 

Microsoft SQL Server 2008 Reporting Services: FIX:
MHTML-formatted reports are not compliant with section 1194.22 of the
Electronic and Information Technology Accessibility Standards when you use SSRS
2008 to generate the report

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

 

Microsoft SQL Server 2008 Reporting Services: FIX:
"An error occurred during local report processing" error message may
occur when you export a report in SQL Server 2008 Reporting Services

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

 

Microsoft SQL Server 2008 Standard: The SQL Server
2008 builds that were released after SQL Server 2008 Service Pack 2 was
released

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

 

SQL 2008 R2

Microsoft SQL Server 2008 R2 Enterprise: Cannot
connect to a named instance of a clustered analysis services

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