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
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
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
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
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