January 2010 – Technical Rollup Mail – SQL
News
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.
Microsoft Releases SQL Server 2008 Service Pack 1
Microsoft has released SQL Server 2008 Service Pack 1 with enhancements meant to ease deployment but no brand new features.
SQL Server to Get Real-Time Boost
The next release of Microsoft's SQL Server database, code-named "Kilimanjaro," will offer master data management (MDM) and support real-time data feeds for business intelligence (BI), reporting and analytics, the company revealed today.
Microsoft Announces SQL Server Fast Track Data Warehouse
New reference architectures from Bull, Dell and HP make it faster, easier, and more affordable for companies to deploy enterprise-class data warehousing projects.
Microsoft announces Microsoft SQL Server 2008, Windows Server 2008 Certification for SAP Business Suite 7, and new enterprise support and services.
Downloads
SQL 2000
Fix: Not All Memory is Available When AWE is Enabled on a Computer Running 32-bit Version of SQL Server 2000 SP4 (899761)
Microsoft has found an issue with the final build of SQL 2000 SP4 that impacts customers who run SQL Server with AWE support enabled.
SQL 2008
Microsoft SQL Server 2008 Express Edition SP1
SQL Server 2008 Express is a free edition of SQL Server that is ideal for learning and building desktop and small server applications, and for redistribution by ISVs.
Events/Webcasts
Cloud Computing Webcast Series - 'Microsoft Online Services:The Better Choice'
Monday, January 11, 2010 12:00 PM Eastern Time (US & Canada)
Join us for a live webcast to discuss Microsoft Online Services: The Better Choice'!
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032433507&culture=en-US
Cloud Computing Webcast Series - 'Connecting the Deskless Worker for the Manufacturing Industry'
Monday, January 18, 2010 12:00 PM Eastern Time (US & Canada)
Join us for a live webcast to discuss 'Connecting the Deskless Worker for the Manufacturing Industry'!
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032433508&culture=en-US
Cloud Computing Webcast Series - 'Connecting the Deskless Worker for the Retail Industry'
Monday, January 25, 2010 12:00 PM Eastern Time (US & Canada)
Join us for a live webcast to discuss 'Connecting the Deskless Worker for the Retail Industry'!
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032433506&culture=en-US
Momentum Webcast: Emerge Stronger with Microsoft BI: Sales and Marketing (Level 100)
Tuesday, January 26, 2010 11:00 AM Pacific Time (US & Canada)
Join us for part four 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 strengthen your customer base while also finding new sources of revenue.
Presenter: Dana Straw, Senior Product Manager, Microsoft Corporation
View other sessions from Momentum: Drive Your Midsize Business Forward
If you have questions or feedback, contact us.
In addition to Momentum webcasts, Microsoft offers a complimentary e-newsletter with real-world examples of how to align IT with your business strategy. You get tips and techniques on using Microsoft technologies and straight talk about solutions that work for mid-sized businesses. If you would like to receive the Business Insights newsletter, click here.
Regardless of any contact preferences you might have previously made on this Microsoft site or on other Microsoft sites or services, by registering for this webcast or virtual lab, you consent and agree to allow Microsoft or one of its third-party agents to contact you no more than three (3) instances for the purpose of soliciting feedback on the webcast or virtual lab or to supply you with special discounts and offers related to products and services presented in the webcast or virtual lab. Any other use of the personal information in your Microsoft Passport profile is subject to the Microsoft Privacy Statement. You can learn more about the privacy and security of Microsoft Passport Network at www.Passport.net
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032428257&culture=en-US
New KB's
SQL 2000
SQL Svr 2000 Reporting Svcs EN: You may receive the "System.OutOfMemoryException" error message when you use SQL Server Reporting Services (Updated)
https://support.microsoft.com/kb/909678/EN-US
SQL 2005
SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you run an MDX query against a database in SQL Server 2005 Service Pack 2: “An unexpected exception occured” (Updated)
https://support.microsoft.com/kb/937829/EN-US
SQL Svr 2005 Notification Svc EN: DST time zone update for SQL Server 2005 Notification Services and for SQL Server 2000 Notification Services (Updated)
https://support.microsoft.com/kb/974412/EN-US
SQL Svr 2005 Reporting Svcs EN: Error message when you try to print a SQL Server 2005 Reporting Services report on a client computer: "Unable to load client print control" (Updated)
https://support.microsoft.com/kb/967511/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released (Updated)
https://support.microsoft.com/kb/937137/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections (Updated)
https://support.microsoft.com/kb/937745/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released (Updated)
https://support.microsoft.com/kb/960598/EN-US
SQL Svr Standard Edtn 2005 EN: Mere Query timeout can lead to fullscale SQLCLR AppDomain unload in some conditions. (Updated)
https://support.microsoft.com/kb/960922/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you restore a SQL Server 2000 database by using SQL Server 2005 Management Studio or SQL Server 2008 Management Studio: "Cannot show requested dialog. Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)" (Updated)
https://support.microsoft.com/kb/972687/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You experience high latency for all the Peer-To-Peer transactional distribution agents when you insert lots of rows in a batch to multiple publications in a SQL Server 2005 Peer-To-Peer transactional replication (Updated)
https://support.microsoft.com/kb/974290/EN-US
SQL Svr Standard Edtn 2005 EN: Some drivers no longer function after you install SQL Server 2005
https://support.microsoft.com/kb/978026/EN-US
SQL 2008
SQL Svr Enterprise 2008 EN: The SQL Server 2008 builds that were released after SQL Server 2008 was released (Updated)
https://support.microsoft.com/kb/956909/EN-US
SQL Svr Enterprise 2008 EN: FIX: The Date data type may be corrupted when you use the SAP BI Destination component of Microsoft Connector 1.0 for SAP BI in a SQL Server 2008 Integration Services package (Updated)
https://support.microsoft.com/kb/976367/EN-US
SQL Svr Express Edition 2008 AL: SQL Server 2008 Express supports .NET Framework 4 Beta 2 after you install Cumulative Update 5 for SQL Server 2008 Service Pack 1
https://support.microsoft.com/kb/972893/EN-US
SQL Svr Standard 2008 EN: How to determine proper SQL Server configuration settings (Updated)
https://support.microsoft.com/kb/319942/EN-US
SQL Svr Standard 2008 EN: How to configure SQL Server 2008 Analysis Services and SQL Server 2005 Analysis Services to use Kerberos authentication (Updated)
https://support.microsoft.com/kb/917409/EN-US
SQL Svr Standard 2008 EN: Error message when you install SQL Server 2008 on a Windows Server 2008-based cluster: "The cluster either has not been verified or there are errors or failures in the verification report. Refer to KB953748 or SQL server books online" (Updated)
https://support.microsoft.com/kb/953748/EN-US
SQL Svr Standard 2008 EN: FIX: Error message is logged in the SQL Server 2008 Errorlog file when you perform operations on some temporary tables in SQL Server 2008: "Time out occurred while waiting for buffer latch" (Updated)
https://support.microsoft.com/kb/968543/EN-US
SQL Svr Standard 2008 EN: FIX: The CPU usage of the resource monitor is very high when the virtual memory is running low in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/968722/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you run a SQL Server 2008 Integration Services package that contains an Execute SQL Task that runs a stored procedure: "The type of the value being assigned to variable "<Variable>" differs from the current variable type" (Updated)
https://support.microsoft.com/kb/969050/EN-US
SQL Svr Standard 2008 EN: Stop error message when you install SQL Server 2005 SP3, SQL Server 2005 Express SP3, or SQL Server 2008 on a Windows XP-based computer that is earlier than Windows XP SP3: "CRITICAL_OBJECT_TERMINATION" (Updated)
https://support.microsoft.com/kb/969936/EN-US
SQL Svr Standard 2008 EN: You may receive "Error 1316.A network error occurred while attempting to read from the file Path\SSCERuntime-ENU.msi" error message when you repair an instance SQL Server 2008 (Updated)
https://support.microsoft.com/kb/970876/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you create a SharePoint subscription on a SQL Server 2008 Reporting Services report that uses cascading parameters: "This report requires a default or user-defined value for the report parameter '<Parameter>'" (Updated)
https://support.microsoft.com/kb/971068/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you synchronize a database or manually run sp_replcmds after you perform partial updates on a varbinary(max) column in SQL Server 2008: "The rowset does not contain any column with offset -1." (Updated)
https://support.microsoft.com/kb/971136/EN-US
SQL Svr Standard 2008 EN: FIX: A Drillthrough action inside table groups passes incorrect parameter values in SQL Server 2008 Reporting Services (Updated)
https://support.microsoft.com/kb/971985/EN-US
SQL Svr Standard 2008 EN: FIX: Some files are not rolled back to the original file versions after you uninstall a SQL Server 2008 Service Pack 1 hotfix that is applied when you use a slipstream installation (Updated)
https://support.microsoft.com/kb/974231/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you run a parallel query in SQL Server 2008: "Trying to use the transaction while there are 1 parallel nested xacts outstanding" (Updated)
https://support.microsoft.com/kb/974766/EN-US
SQL Svr Standard 2008 EN: Cumulative Update Package 5 for SQL Server 2008 Service Pack 1 (Updated)
https://support.microsoft.com/kb/975977/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]" (Updated)