News

SQL 2008 R2

SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available today

http://blogs.technet.com/b/dataplatforminsider/archive/2010/05/12/sql-server-2008-r2-powerpivot-for-excel-and-sharepoint-is-here-volume-licensing-downloads-available-today.aspx

SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available today

Guest Blogger: Adrian Simays, Technical Architect, EMC Microsoft Alliance

http://blogs.technet.com/b/dataplatforminsider/archive/2010/05/20/guest-blogger-adrian-simays-technical-architect-emc.aspx

Guest Blogger: Adrian Simays, Technical Architect, EMC Microsoft Alliance

Other

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

Downloads

SQL 2000

SQL Server 2000 Best Practices Analyzer

SQL Server 2000 Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices on your servers.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=b352eb1f-d3ca-44ee-893e-9e07339c1f22

SQL Server Compact 3.5 SP2 for Windows Desktop

SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=e497988a-c93a-404c-b161-3a0b323dce24

SQL 2005

SQL Server 2008 R2 Books Online

Download the release version of the documentation and tutorials for Microsoft SQL Server 2008 R2.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=c18bad82-0e5f-4e82-812b-5b23e5d52b9c

SQL Server Compact 3.5 SP2 for Windows Desktop

SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=e497988a-c93a-404c-b161-3a0b323dce24

New KB's

SQL 2000

SQL Svr Standard Edtn 2000 EN: You experience slow performance when you back up the database in SQL Server 2000 (Updated)

http://support.microsoft.com/kb/904804/EN-US

SQL 2005

SQL Svr Developer Edtn 2005 EN: Microsoft Advisory Services Engagement Scenario - Analysis SQL Transactional Replication High Latency (Updated)

http://support.microsoft.com/kb/982895/EN-US

SQL Svr Enterprise Edtn 2005 EN: SQL Server support for mounted volumes (Updated)

http://support.microsoft.com/kb/819546/EN-US

SQL Svr Express Edtn 2005 EN: Error message when you try to install SQL Server Express or SQL Server Express Edition or SQL Server Express Edition with Advanced Services: "The SQL Server service failed to start" (Updated)

http://support.microsoft.com/kb/920114/EN-US

SQL Svr Standard Edtn 2005 EN: How to uninstall an instance of SQL Server 2005 manually (Updated)

http://support.microsoft.com/kb/909967/EN-US

SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 service pack installation stops unexpectedly, and the following error message is logged in the setup log file: "Unable to install Windows Installer MSP file" (Updated)

http://support.microsoft.com/kb/926622/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005 (Updated)

http://support.microsoft.com/kb/933564/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error messages and an event may be logged when you use the Virtual Device Interface in SQL Server 2005 or in SQL Server 2000 (Updated)

http://support.microsoft.com/kb/934396/EN-US

SQL Svr Standard Edtn 2005 EN: The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005 (Updated)

http://support.microsoft.com/kb/937531/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: You cannot kill a session that is running a query on a linked server in SQL Server 2005 and in SQL Server 2008 (Updated)

http://support.microsoft.com/kb/961237/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: You receive a "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server 2005 WMI provider to obtain information about SQL Server 2005 services (Updated)

http://support.microsoft.com/kb/980142/EN-US

SQL 2008

SQL Svr Enterprise 2008 R2 EN: Two shortcuts function incorrectly after you upgrade from SQL Server 2008 to SQL Server 2008 R2 CTPs or from SQL Server 2008 R2 CTPs to SQL Server 2008 R2 RTM

http://support.microsoft.com/kb/980495/EN-US

SQL Svr Enterprise 2008 R2 EN: You cannot upload the Utility Information data collection set in SQL Server 2008 R2

http://support.microsoft.com/kb/980497/EN-US

SQL Svr Enterprise 2008 R2 EN: Some pages in Books Online cannot be displayed when SQL Server 2008 and SQL Server 2008 R2 are installed on the same computer

http://support.microsoft.com/kb/981591/EN-US

SQL Svr Standard 2008 EN: You cannot add a cluster node when you install SQL Server 2008 Analysis Services and you do not install the SQL Server 2008 Database Engine (Updated)

http://support.microsoft.com/kb/956427/EN-US

SQL Svr Standard 2008 EN: FIX: Error message when you rebuild indexes for a table that contains sparse columns in SQL Server 2008: "Cannot alter table '<TableName>' because the table either contains sparse columns or a column set column which are incompatible with compression" (Updated)

http://support.microsoft.com/kb/958792/EN-US

SQL Svr Standard 2008 EN: The Full Text Search component installation fails when you try to install the SQL Server 2008 database engine from an installation DVD on a computer that has SQL Server 2008 Express edition installed (Updated)

http://support.microsoft.com/kb/967103/EN-US

SQL Svr Standard 2008 EN: FIX: Error message when you rebuild a table that has sparse columns in SQL Server 2008: "Cannot alter table '<TableName>' because the table either contains sparse columns or a column set column which are incompatible with compression" (Updated)

http://support.microsoft.com/kb/968742/EN-US

SQL Svr Standard 2008 EN: The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released (Updated)

http://support.microsoft.com/kb/970365/EN-US

SQL Svr Standard 2008 EN: Microsoft Advisory Services Engagement Scenario - SQL Server Performance (Updated)

http://support.microsoft.com/kb/974626/EN-US

SQL Svr Standard 2008 EN: FIX: You receive an error message when you run a query that uses a parent/child dimension in SSAS 2008

http://support.microsoft.com/kb/979778/EN-US

SQL Svr Standard 2008 EN: FIX: Error message when you use the Script Wizard to generate scripts for stored procedures in SQL Server 2008

http://support.microsoft.com/kb/979785/EN-US

SQL Svr Standard 2008 EN: FIX: An unexpected line break is appended to a text box in an SSRS 2008 report after you export the report to Word

http://support.microsoft.com/kb/981146/EN-US

SQL Svr Standard 2008 EN: FIX: An access violation occurs when you use the COUNT_BIG function and the OVER clause in a query in SQL Server 2008

http://support.microsoft.com/kb/981611/EN-US

SQL Svr Standard 2008 EN: FIX: An unhandled managed exception occurs when you try to export an SSRS 2008 report to an Excel format

http://support.microsoft.com/kb/981626/EN-US

SQL Svr Standard 2008 EN: FIX: An MDX query returns an incorrect result when you run the query by using a clean cache in SSAS 2008

http://support.microsoft.com/kb/981838/EN-US

SQL Svr Standard 2008 EN: FIX: "The selected data extension <data extension name> cannot be loaded" error message when you use Report Builder 2.0 to run an SSRS 2008 report that uses a custom data processing extension in server mode

http://support.microsoft.com/kb/981881/EN-US

SQL Svr Standard 2008 EN: FIX: An exception occurs when you filter or run an MDX query on a database that contains a dynamic set in SSAS 2008

http://support.microsoft.com/kb/981899/EN-US

SQL Svr Standard 2008 EN: FIX: An assertion failure occurs when you run a parameterized query that has many parameters in SQL Server 2008 and that has the SHOWPLAN_XML option enabled

http://support.microsoft.com/kb/981922/EN-US

SQL Svr Standard 2008 EN: FIX: The DynamicHeight property and the DynamicWidth property for a Chart control inside a tablix data region are not applied correctly for all the charts in SSRS 2008

http://support.microsoft.com/kb/981928/EN-US

SQL Svr Standard 2008 EN: FIX: The data in a custom report item is displayed incorrectly after you export the report to a PDF format file by using the ReportExecutionService.Render method in SQL Server 2008 Reporting Services

http://support.microsoft.com/kb/981973/EN-US

SQL Svr Standard 2008 EN: FIX: Error message when you process an index of a partition in SSAS 2008

http://support.microsoft.com/kb/982321/EN-US

SQL Svr Standard 2008 EN: FIX: "An unexpected error occurred" error message when you use the OPENROWSET function to access an SSAS 2008 database

http://support.microsoft.com/kb/982418/EN-US

SQL Svr Standard 2008 EN: FIX: You receive error 666 when you rebuild an index online on a partition scheme in SQL Server 2008

http://support.microsoft.com/kb/982441/EN-US

SQL Svr Standard 2008 EN: FIX: A SQL Server 2008 Reporting Services report that contains a table with a child group does not comply with the Section 508 standards (Updated)

http://support.microsoft.com/kb/982631/EN-US

SQL Svr Standard 2008 EN: Microsoft Advisory Services Engagement Scenario - SQL Merge Replication Non-Convergence (Updated)

http://support.microsoft.com/kb/982900/EN-US

SQL Svr Standard 2008 EN: FIX: "System.Exception: Win32.ExtTextOut failed; Win32 error:997" error message when the EMF printing renderer is under stress or when you try to print multiple reports at the same time in SSRS 2008

http://support.microsoft.com/kb/982924/EN-US

SQL Svr Standard 2008 EN: FIX: "A connection cannot be made" error message in SSAS 2008 when you try to connect to a database

http://support.microsoft.com/kb/983286/EN-US

SQL Svr Standard 2008 R2 EN: Cumulative Update package 1 for SQL Server 2008 R2 (Updated)

http://support.microsoft.com/kb/981355/EN-US

SQL Svr Standard 2008 R2 EN: The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released (Updated)

http://support.microsoft.com/kb/981356/EN-US

SQL Svr Standard 2008 R2 EN: You receive an error message when you try to browse directly to the SSRS 2008 R2 report server after you create a SharePoint claim site

http://support.microsoft.com/kb/981588/EN-US

SQL Svr Standard 2008 R2 EN: Configuration options are missing on the SharePoint Central Administration Web site

http://support.microsoft.com/kb/981592/EN-US

SQL Svr Standard 2008 R2 EN: You receive an error message in the x64-based Italian version of SQL Server 2008 R2 BIDS when you try to create a project

http://support.microsoft.com/kb/981597/EN-US

SQL Svr Standard 2008 R2 EN: SQL Server 2008 Management Studio functions incorrectly after you install SQL Server 2008 R2 Analysis Services

http://support.microsoft.com/kb/982360/EN-US