November 2009 - Technical Rollup Mail - SQL Server
News
Forrester Research
SQL Server 2008 Ups Pressure On Competitors; Microsoft Boosts Manageability, BI, Performance, Productivity, and Security
For the majority of mission-critical applications today, SQL Server 2008 already has the strongest combination of price/performance, manageability, security, and DBA productivity. The latest version of SQL Server from Microsoft SQL Server 2008 offers hundreds of new DBMS features that boost the productivity of database administrators (DBAs) and developers, improve support for larger databases, and enhance security.
Forrester Research
The Forrester Wave: Enterprise Database Management Systems, Q2 2009
This Forrester Wave assesses more than a dozen firms based primarily on their enterprise open source and closed source database management systems. Forrester named Microsoft a ‘leader’ in the DBMS Wave and states that Microsoft is “The most aggressive DBMS vendor with a strong road map.” In this Wave, Forrester categorizes Leaders as offering “broad set of functionality to support any critical transactional application.”
Gartner, Inc.
Gartner 2006 worldwide RDBMS market share reports highest growth rate in market share for Microsoft SQL Server. With 28% growth in market share, growth is almost twice the nearest competitor at 14.8% growth.
Gartner, Inc.
This Magic Quadrant depicts Gartner's analysis of how data warehouse DBMS software-only vendors measure against specific criteria within the marketplace.
Gartner, Inc.
Gartner 2006 worldwide RDBMS market share reports highest growth rate in market share for Microsoft SQL Server. With 28% growth in market share, growth is almost twice the nearest competitor at 14.8% growth.
Gartner, Inc.
Microsoft is positioned in Leaders Quadrant for Magic Quadrant for Business Intelligence Platforms, 2009.
IDC
SQL Server is the fastest growing Database and Business Intelligence vendor.
IDC
SQL Server ships more units than Oracle and IBM combined.
The OLAP Report
SQL Server is the #1 OLAP Server on the market
Dark Reading
Study: SQL Server Is Safest DB
NGS Software Insight Security Research
Which database is more secure? Oracle vs. Microsoft. Since July 2003 more than 100 critical Oracle database security vulnerabilities have been identified, compared to zero for SQL Server for that period.
Transaction Processing Performance Council
Microsoft SQL Server and Unisys are the first to publish TPC-E benchmark results.
Winter Corporation
SQL Server Manages the World's Largest Databases.
ChannelWeb: CRN Staff
Microsoft SQL Server recognized as Best Seller and Top Growth Best Seller by CRN Magazine.
Other
Technical RollUp
https://blogs.technet.com/trm/default.aspx
Downloads
Other
SQL Server Compact 3.5 SP2 Beta 2 for Windows Desktop
SQL Server Compact 3.5 SP2 Beta 2 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 Beta 2 on Windows desktop.
SQL Server Compact 3.5 SP2 Beta 2 for Windows Desktop
SQL Server Compact 3.5 SP2 Beta 2 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 Beta 2 on Windows desktop.
SQL Server Compact 3.5 SP2 Beta 2 for Windows Desktop
SQL Server Compact 3.5 SP2 Beta 2 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 Beta 2 on Windows desktop.
Security Update for SQL Server Reporting Services 2000 Service Pack 2 (KB970899)
A security issue has been identified in the SQL Server Reporting Services 2000 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.
SQL 2000
Security Update for SQL Server 2005 Service Pack 2 (KB970895)
A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.
Security Update for SQL Server 2005 Service Pack 3 (KB970892)
A security issue has been identified in the SQL Server 2005 Service Pack 3 that could allow an attacker to compromise your system and gain control over it.
Security Update for SQL Server 2005 Service Pack 2 (KB970896)
A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.
Security Update for SQL Server Reporting Services 2000 Service Pack 2 (KB970899)
A security issue has been identified in the SQL Server Reporting Services 2000 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.
Security Update for SQL Server 2005 Service Pack 3 (KB970894)
A security issue has been identified in the SQL Server 2005 Service Pack 3 that could allow an attacker to compromise your system and gain control over it.
SQL Server Compact 3.5 SP2 Beta 2 for Windows Desktop
SQL Server Compact 3.5 SP2 Beta 2 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 Beta 2 on Windows desktop.
SQL 2005
How to protect SAP with DPM 2007 sp1
This whitepaper discusses why and how to protect SAP environments running on Microsoft SQL Server with Microsoft System Center Data Protection Manager 2007 sp1
Security Update for SQL Server 2005 Service Pack 2 (KB970895)
A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.
Security Update for SQL Server 2005 Service Pack 3 (KB970892)
A security issue has been identified in the SQL Server 2005 Service Pack 3 that could allow an attacker to compromise your system and gain control over it.
Security Update for SQL Server 2005 Service Pack 2 (KB970896)
A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.
Security Update for SQL Server Reporting Services 2000 Service Pack 2 (KB970899)
A security issue has been identified in the SQL Server Reporting Services 2000 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.
Security Update for SQL Server 2005 Service Pack 3 (KB970894)
A security issue has been identified in the SQL Server 2005 Service Pack 3 that could allow an attacker to compromise your system and gain control over it.
SQL Server Reporting Services Add-in for SharePoint Technologies
The Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.
SQL Server Reporting Services Add-in for SharePoint Technologies
The Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.
SQL Server Compact 3.5 SP2 Beta 2 for Windows Desktop
SQL Server Compact 3.5 SP2 Beta 2 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 Beta 2 on Windows desktop.
SQL 2008
How to protect SAP with DPM 2007 sp1
This whitepaper discusses why and how to protect SAP environments running on Microsoft SQL Server with Microsoft System Center Data Protection Manager 2007 sp1
Communications Server 2007 R2 Site Resiliency White Paper
This white paper provides guidelines and best practices for Microsoft Office Communications Server 2007 R2 site resiliency.
Events/Webcasts
Momentum Webcast: Emerge Stronger with Microsoft Business Intelligence (Level 100)
Monday, November 09, 2009 11:00 AM Pacific Time (US & Canada)
Discover how a Microsoft total business intelligence solution can help your organization emerge stronger from the economic downturn. In this presentation, we discuss how to use your existing technologies to identify cost-cutting opportunities, streamline operations, and strengthen and grow your customer base in today's marketplace.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032429506&culture=en-US
Momentum Webcast: Emerge Stronger with Microsoft BI: Operational Improvement (Level 100)
Tuesday, November 17, 2009 11:00 AM Pacific Time (US & Canada)
Join us for part three of our four-part Emerge Stronger series on how the total Microsoft Business Intelligence solution can enable you to maximize your technology during the economic downturn. This presentation builds on the overview in the first webcast by providing a detailed look into how you can free cash from operations while keeping and growing your operational strength.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032428087&culture=en-US
New KB's
SQL 2000
SQL Svr 2000 Reporting Svcs EN: MS09-062: Description of the security update for GDI+ for SQL Server 2000 Reporting Services Service Pack 2: October 13, 2009
https://support.microsoft.com/kb/970899/EN-US
SQL 2005
Report Viewer Redistrib 2005 SP1: MS09-062: Description of the security update for Microsoft Report Viewer 2005 Service Pack 1 Redistributable Package: October 13, 2009
https://support.microsoft.com/kb/971117/EN-US
SQL Server 2005 Service Pack 2: MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009
https://support.microsoft.com/kb/970895/EN-US
SQL Server 2005 Service Pack 2: MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009
https://support.microsoft.com/kb/970896/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: You cannot process an object when you change or delete another unrelated object at the same time in the same database in SQL Server 2005 Analysis Services
https://support.microsoft.com/kb/975748/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: You receive an incorrect result when you run an MDX query against a dimension that has a parent/child relationship, and uses the unary operator after you install Cumulative Update 3 for SQL Server 2005 Analysis Services SP3 (Updated)
https://support.microsoft.com/kb/975783/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: Error message after you perform a Process Update on a dimension used on a cube that contains a writeback partition: "Errors in the high-level relational engine. The data source view does not contain a definition for the <tablename> table or view"
https://support.microsoft.com/kb/976030/EN-US
SQL Svr 2005 SP3 AL: MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009
https://support.microsoft.com/kb/970892/EN-US
SQL Svr 2005 SP3 AL: MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009
https://support.microsoft.com/kb/970894/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to shrink the tempdb database in SQL Server (Updated)
https://support.microsoft.com/kb/307487/EN-US
SQL Svr Standard Edtn 2005 EN: How to monitor blocking in SQL Server 2005 and in SQL Server 2000 (Updated)
https://support.microsoft.com/kb/271509/EN-US
SQL Svr Standard Edtn 2005 EN: SQL Server Agent jobs may fail after you change the SQL Server Agent service startup account by using the Windows Service Control Manager (Updated)
https://support.microsoft.com/kb/911305/EN-US
SQL Svr Standard Edtn 2005 EN: Tuning options for SQL Server 2005 and SQL Server 2008 when running in high performance workloads (Updated)
https://support.microsoft.com/kb/920093/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message in the database mail log when you try to use the sp_send_dbmail stored procedure to send an e-mail in SQL Server 2005: "Invalid XML message format received on the ExternalMailQueue" (Updated)
https://support.microsoft.com/kb/928789/EN-US
SQL Svr Standard Edtn 2005 EN: On a computer that has a multicore processor, if the ratio of logical processors to physical sockets is not a power of 2, you cannot install SQL Server 2005 (Updated)
https://support.microsoft.com/kb/954835/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The connection to a Microsoft SQL Server 2005 Reporting Services catalog database encounters an error, and the connection is not reset
https://support.microsoft.com/kb/972926/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You use the COUNT function on a column that is returned by a subquery that returns no rows in SQL Server 2005, and an incorrect result is returned
https://support.microsoft.com/kb/974067/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A memory leak may occur if you use a linked server query to retrieve a sql_variant column from a remote server in SQL Server 2005
https://support.microsoft.com/kb/974130/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message in the SQL Server 2005 Errorlog file after the SQL Server service stops responding: “Timeout occurred while waiting for latch”
https://support.microsoft.com/kb/974205/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A deadlock occurs when you perform an operation that cleans up the security cache in SQL Server 2005
https://support.microsoft.com/kb/974296/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you use database mirroring in SQL Server 2005, and an assertion failure occurs intermittently: "SQL Server Assertion: File: <loglock.cpp>, line=823 Failed Assertion = 'result == LCK_OK'."
https://support.microsoft.com/kb/974319/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Database restore operation may fail during the recovery phase when the database uses query notification in SQL Server 2005
https://support.microsoft.com/kb/974777/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: An API cursor plan that is created by a plan guide is not reused when the cursor is active
https://support.microsoft.com/kb/974785/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A "DBCC CHECKDB" statement or a "DBCC CHECKTABLE" statement reports errors after you rebuild an XML index in SQL Server 2005
https://support.microsoft.com/kb/974985/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The restore operation takes a long time when you restore a database that has query notification enabled in SQL Server 2005
https://support.microsoft.com/kb/975089/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Deadlocks may occur when multiple concurrent query notification subscriptions are fired on same objects in SQL Server 2005
https://support.microsoft.com/kb/975090/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Capitalization and accent changes on a column of user-defined data type are not propagated in SQL Server 2005 merge replication
https://support.microsoft.com/kb/975134/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: For SQL Server Compact Edition (CE) Subscribers, only schema without data is replicated for newly added articles to an existing Merge Publication using “ExchangeType.Upload” (Updated)
https://support.microsoft.com/kb/975159/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You receive an incorrect result when you run a query that uses a ranking function on a partitioned table in SQL Server 2005
https://support.microsoft.com/kb/975230/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A SELECT statement returns an incorrect result set if a linked server is being used in SQL Server 2005
https://support.microsoft.com/kb/975417/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The database mirroring session is suspended when you add more than one log transaction file to a folder on the principle server that does not exist on the mirror server
https://support.microsoft.com/kb/975681/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You receive an incorrect result when you run a query that uses a parallel execution plan in SQL Server 2005
https://support.microsoft.com/kb/976041/EN-US
SQL 2008
Report Viewer Redistrib 2008: MS09-062: Description of the security update for Microsoft Report Viewer 2008 Redistributable Package: October 13, 2009
https://support.microsoft.com/kb/971118/EN-US
Report Viewer Redistrib 2008: MS09-062: Description of the security update for Microsoft Report Viewer 2008 Service Pack 1 Redistributable Package: October 13, 2009
https://support.microsoft.com/kb/971119/EN-US
SQL Svr Enterprise 2008 EN: Error messages may be logged in the SQL Server error log after you run a DBCC command in SQL Server (Updated)
https://support.microsoft.com/kb/926070/EN-US
SQL Svr Enterprise 2008 EN: List of known issues when you install SQL Server on Windows 7 or on Windows Server 2008 R2 (Updated)
https://support.microsoft.com/kb/955725/EN-US
SQL Svr Standard 2008 EN: Updates to Microsoft SQL server 2008 will fail after an edition upgrade (Updated)
https://support.microsoft.com/kb/970608/EN-US
SQL Svr Standard 2008 EN: FIX: The performance decreases when you open the Report Builder (RB) ClickOnce application after you install SQL Server 2008 Service Pack 1
https://support.microsoft.com/kb/974371/EN-US
SQL Svr Standard 2008 EN: FIX: The row count is incorrect after you run a "BULK INSERT" statement by using SQL Server JDBC driver 2.0 to insert data into a table
https://support.microsoft.com/kb/975565/EN-US
SQL Svr Standard 2008 EN: The SQL Server 2008 Books Online shortcuts and the SQL Server 2008 Books Online folder disappear from Start menu after you install the May 2009 version of SQL Server 2008 Books Online