News

Announcing an updated version of PowerPivot for Excel

http://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!!!

http://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

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

 

Other

 

http://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.

http://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.

http://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.

http://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.

http://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.

http://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.

http://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

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

 

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

http://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

http://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

http://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

http://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

http://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

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

 

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

http://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

http://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

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

 

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

http://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

http://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

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

 

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

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

 

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

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

 

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

http://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

http://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

http://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

http://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

http://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

http://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

http://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

http://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

http://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

http://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

http://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

http://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

http://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

http://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

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