December 2009 – Technology Rollup Mail – SQL Server
Downloads
Other
Sync Framework Power Pack for SQL Azure
This release features the SQL Azure provider for Microsoft Sync Framework, a plug-in for Visual Studio 2008 Professional SP1 and the tool SQL Azure Data Sync Tool for SQL Server, all of which simplify using Sync Framework and SQL Azure together.
Microsoft® SQL Server® 2008 R2 November Community Technology Preview Feature Pack
The Microsoft SQL Server 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for SQL Server 2008 R2.
Microsoft® SQL Server® 2008 R2 November Community Technology Preview End User License Agreements
The Microsoft SQL Server 2008 R2 End User License Agreements provide the legal terms and conditions for using the SQL Server 2008 R2 November Community Technology Preview core software
Microsoft® SQL Server® 2008 R2 November CTP StreamInsight Refresh
Microsoft® SQL Server® StreamInsight is Microsoft’s new Complex Event Processing technology to help businesses derive better insights by correlating event streams from multiple sources with near-zero latency.
Sync Framework Power Pack for SQL Azure
This release features the SQL Azure provider for Microsoft Sync Framework, a plug-in for Visual Studio 2008 Professional SP1 and the tool SQL Azure Data Sync Tool for SQL Server, all of which simplify using Sync Framework and SQL Azure together.
SQL 2005
SQL Server 2008 R2 Books Online CTP November 2009
Download the a community technology preview (CTP) release version of the documentation and tutorials for Microsoft SQL Server 2008 R2.
SQL 2008
Microsoft SQL Server Protocol Documentation
The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in Microsoft SQL Server 2008.
SQL Server 2008 R2 Books Online CTP November 2009
Download the a community technology preview (CTP) release version of the documentation and tutorials for Microsoft SQL Server 2008 R2.
IT Compliance Management Series
The IT Compliance Management Series is intended for IT managers, professionals, and partners who must configure Microsoft products to address specific IT governance, risk, and compliance (GRC) requirements. Successful implementation of the recommendations in this series will allow organizations to shift the enforcement and management of IT GRC requirements onto underlying Microsoft technologies.
Microsoft SQL Server 2008 Books Online (July 2009)
Download the documentation and tutorials for Microsoft SQL Server 2008.
Events/Webcasts
MSDN Webcast: Overview of SQL Server StreamInsight (Level 200)
Wednesday, December 02, 2009 1:00 PM Pacific Time (US & Canada)
In this webcast, we explore how you can build event-driven applications to gain insight from high data rate event stream sources with very low latency. We provide an overview of the new Microsoft platform for complex event processing (CEP) called Microsoft SQL Server StreamInsight, and then we discuss the following scenarios: formulating declarative queries to express powerful analytics over event streams, programming against the object model of the CEP engine, and writing adapters for event stream data sources. Attendees learn how familiar development tools such as Microsoft Visual Studio 2008, Microsoft .NET, C#, and Language-Integrated Query (LINQ) can be used for developing their event-driven applications.
Presenter: Torsten Grabs, Senior Program Manager, Microsoft Corporation
View other sessions from: SQL Server 2008: Develop Strong Database Applications
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032432286&culture=en-US
Cloud Computing Webcast Series - 'Why Microsoft has the best cloud computing story.'
Wednesday, December 09, 2009 12:00 PM Eastern Time (US & Canada)
Join us for a live webcast to hear 'Why Microsoft has the best cloud computing story'!
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032433504&culture=en-US
TechNet Webcast: Thrive Live! SQL Server Locking and Blocking Made Simple (Level 200)
Monday, December 07, 2009 9:00 AM Pacific Time (US & Canada)
A good working knowledge of how Microsoft SQL Server makes use of locking and transaction isolation levels can help you greatly improve an application's performance. In this webcast, we explore the SQL Server locking methodology and share techniques for enhancing query response times.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032432983&culture=en-US
MSDN Webcast: SQL Server 2008 R2 Support for Up to 256 Logical Processors (Level 200)
Wednesday, December 09, 2009 1:00 PM Pacific Time (US & Canada)
Microsoft SQL Server 2008 R2 introduces support for greater than 64 logical processors, supporting up to 256 logical processors on the Windows Server 2008 R2 operating system. In this webcast, we discuss the importance of being able to scale to 256 logical processors, examine the methodology Microsoft employed to validate performance and scalability of SQL Server 2008 R2, and provide details on SQL Server scalability tests and the hardware platforms the tests ran on. We also discuss architectural innovations that made it possible for SQL Server 2008 R2 to scale beyond 64 logical processors and share SQL Server best practices.
Presenters: Madhan Arumugam, Program Manager, Microsoft Corporation and Fabricio Voznika, Senior Software Development Engineer, Microsoft Corporation
Madhan Arumugam is a program manager on the SQL Server Engine team at Microsoft in Redmond, Washington, where his responsibilities currently cover base diagnostic and execution infrastructure technologies like SQL Server Operating System (SQLOS). Before joining Microsoft, Madhan worked as a software engineer at Intel developing functional models for multi-core cache coherency protocols and other interconnects.
Fabricio Voznika is a developer on the Microsoft SQL Server team where he currently works with synchronization primitives, scheduling, and eventing infrastructure. Prior to Microsoft, he worked for Ericson, designing a network performance monitor in Berkeley, California, and he worked for Objective Solutions in Curitiba, Brazil. Fabricio holds a master's degree from the University of Washington and a bachelor's degree in computer science from Pontificia Universidad Católica de Puerto Rico (PUC-PR).
View other sessions from:
SQL Server 2008: Develop Strong Database Applications
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032433593&culture=en-US
Cloud Computing Webcast Series - 'The Business Value of Online Services'
Monday, December 14, 2009 12:00 PM Eastern Time (US & Canada)
Join us for a live webcast to discuss 'The Business Value of Online Services'!
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032433505&culture=en-US
New KB's
SQL 2000
SQL Svr Standard Edtn 2000 EN: An assertion or Msg 7987 may occur when an operation is performed on an instance of SQL Server (Updated)
https://support.microsoft.com/kb/828337/EN-US
SQL 2005
SQL Svr Compact Edtn 2005 EN: Description of the various build versions of SQL Server Compact Edition (Updated)
https://support.microsoft.com/kb/950550/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to change the network IP addresses of SQL Server failover cluster instances (Updated)
https://support.microsoft.com/kb/244980/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you try to open a file attachment in a message that is generated by the sp_send_dbmail procedure in SQL Server 2005: "This file is not in a recognizable format" (Updated)
https://support.microsoft.com/kb/924345/EN-US
SQL Svr Standard Edtn 2005 EN: You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server is 3179 or a later build (Updated)
https://support.microsoft.com/kb/943525/EN-US
SQL 2008
SQL Svr Enterprise 2008 EN: How to update or slipstream an installation of SQL Server 2008 (Updated)
https://support.microsoft.com/kb/955392/EN-US
SQL Svr Enterprise 2008 EN: Error message when you try to use SQL Server Analysis Services as a data source for a data-driven subscription in SQL Server 2008 Report Manager: "An error occurred while connecting to a data source, or the query is not valid for the data source" (Updated)
https://support.microsoft.com/kb/956094/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
https://support.microsoft.com/kb/976367/EN-US
SQL Svr Express Edition 2008 AL: FIX: Error message when you install SQL Server 2008 Express edition on a computer that is running the Chinese Traditional version of Windows Vista for Hongkong: “Performance counter registry hive consistency”
https://support.microsoft.com/kb/976231/EN-US
SQL Svr Standard 2008 EN: FIX: Setup of SQL Server 2008 fails when the setup binary files are located in a folder whose path is in the 8.3 compatible format
https://support.microsoft.com/kb/973357/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you run a SQL Server 2008 Integration Services package that uses a configuration table in SQL Server Business Intelligence Development Studio: “The connection "<Connection Name>" is not found” (Updated)
https://support.microsoft.com/kb/974559/EN-US
SQL Svr Standard 2008 EN: FIX: The mean and median lines are not shown when you view a report that contains a Boxplot chart in SQL Server 2008 Reporting Services
https://support.microsoft.com/kb/975284/EN-US
SQL Svr Standard 2008 EN: FIX: An assertion failure may occur when you run a query that joins columns on a table with compression enabled in SQL Server 2008
https://support.microsoft.com/kb/975719/EN-US
SQL Svr Standard 2008 EN: FIX: Toggled items display incorrectly when you print or export a SQL Server 2008 Reporting Services report
https://support.microsoft.com/kb/975756/EN-US
SQL Svr Standard 2008 EN: FIX: An access violation occurs intermittently during message processing for service broker, and the session may be disconnected in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/975772/EN-US
SQL Svr Standard 2008 EN: FIX: The DBCC CHECKFILEGROUP statement does not check a partitioned object if one of the partitions is not presented in the filegroup being checked in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/975991/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you export a report that uses the Code39(1:3) font to a .pdf file in SQL Server 2008 Reporting Services: “There was an error processing a page. There was a problem reading this document(135)”
https://support.microsoft.com/kb/976359/EN-US
SQL Svr Standard 2008 EN: FIX: A MDX query that involves multiple calculated measures may return an incorrect result in SQL Server 2008 Analysis Services
https://support.microsoft.com/kb/976391/EN-US
SQL Svr Standard 2008 EN: FIX: Error message in SQL Server 2008 when you try to transfer data by using a Transfer object that has the WithDependencies property enabled: "Object reference not set to an instance of an object."
https://support.microsoft.com/kb/976413/EN-US
SQL Svr Standard 2008 EN: FIX: Full-text search functionality does not work in SQL Server 2008 Express Edition even after you installed SQL Server 2008 CU2
https://support.microsoft.com/kb/976414/EN-US
SQL Svr Standard 2008 EN: FIX: Different results may be returned when you concurrently run the same query with the RECOMPILE option in SQL Server 2008
https://support.microsoft.com/kb/976603/EN-US
SQL Svr Standard 2008 EN: FIX: The SQL Server 2008 agent does not automatically resume running after you upgrade to SQL Server 2008 CU7 or SQL Server 2008 SP1 CU3/CU4 in a stand-alone environment
https://support.microsoft.com/kb/976953/EN-US
SQL Svr Standard 2008 EN: How to apply a hotfix for SQL Server 2005 or SQL Server 2008 in a transactional replication and database mirroring topology
https://support.microsoft.com/kb/977051/EN-US
SQL Svr Standard 2008 EN: FIX: Cascading parameters have incorrect values after you customize the schedule for a new subscription on a SharePoint site of SQL Server 2008 Reporting Services
https://support.microsoft.com/kb/977058/EN-US
SQL Svr Standard 2008 EN: FIX: After you run the merge agent during the initialization of the subscription in SQL Server 2008, the ident_current() function returns a value that is larger than expected