December 2010 - Technical Rollup Mail - SQL
News
Announcing an updated version of
PowerPivot for Excel
HELP SHAPE THE FUTURE OF SQL
SERVER!!!
CIOs share insight on best
practices and challenges in today’s enterprise environment
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