March 2010 – Technology Rollup Mail – SQL Server

News

TDWI is back!

https://blogs.technet.com/dataplatforminsider/archive/2010/02/24/tdwi-is-back.aspx

Exhibiting at TDWI AND Celebrating the completion of the first technology preview of SQL Server 2008 R2 Parallel Data Warehouse…What a great week!

https://blogs.technet.com/dataplatforminsider/archive/2010/02/22/exhibiting-at-tdwi-world-conference-and-celebrating-the-completion-of-the-first-technology-preview-of-sql-server-2008-r2-parallel-data-warehouse-what-a-great-week.aspx

You Ask, We deliver – Timelines for SQL Server Service Packs

https://blogs.technet.com/dataplatforminsider/archive/2010/02/12/you-ask-we-deliver-timelines-for-sql-server-service-packs.aspx

Other

Technical RollUp

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

Downloads

Get the SQL Server 2008 R2 November CTP and Self-Service BI Downloads

https://www.microsoft.com/sqlserver/2008/en/us/r2.aspx

Events/Webcasts

TechNet Webcast: How Microsoft IT Developed Best Practices in Offering PowerPivot as a Service (Level 300)

Tuesday, March 16, 2010 9:30 AM Pacific Time (US & Canada)

Attend this webcast to learn how Microsoft IT is deploying PowerPivot as a service for Microsoft in collaboration with the Microsoft SQL Server Customer Advisory Team (SQLCAT) team. We share best practices for technical architecture, configurations, on boarding, training, and evangelizing across the enterprise. We also provide some in-depth technical details on providing PowerPivot as an online service for various business groups and details on PowerPivot high availability and scalability.

 

Presenter: Sanjay Soni, Microsoft IT Technology Evangelist, Microsoft Corporation

Sanjay Soni is a business intelligence (BI) platforms evangelist in Microsoft IT BI Engineering group. Sanjay is an MCDBA and MCTS, and he specializes in business intelligence using Microsoft technologies, including Microsoft SQL Server Analysis Services, SharePoint, ProClarity, and Microsoft Office PerformancePoint Server. Sanjay has authored and presented a variety of papers at various BI conferences, including The Data Warehousing Institute (TDWI) Conference, Microsoft Business Intelligence Conference, PASS Summit, SQL Connections, SharePoint Conference, and TechEd. Many of these papers were published in SQL Server Magazine and on various Web sites, including Microsoft.com and TechNet.

View other sessions from Microsoft IT Showcase: How Microsoft Does IT

 

If you have questions or feedback, contact us

https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032441803&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 (Updated)

https://support.microsoft.com/kb/970899/EN-US

SQL 2005

SQL Svr Developer Edtn 2005 EN: Cumulative update package 8 for SQL Server 2005 Service Pack 3

https://support.microsoft.com/kb/978915/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)

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

SQL Svr Standard Edtn 2005 EN: FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name used in the query" (Updated)

https://support.microsoft.com/kb/936223/EN-US

SQL Svr Standard Edtn 2005 EN: Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a "No SQL Server 2005 components were found" error message when you perform operations in SQL Server 2005 Surface Area Configuration (Updated)

https://support.microsoft.com/kb/941823/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error message in SQL Server 2005 when you run an update statement on a database whose compatibility level is 6"Msg 4104, Level 16, State 1, Line 1 The multi-part identifier <Alias Name>.<Column Name> could not be bound"

https://support.microsoft.com/kb/978518/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: The principal database is not recovered if the database has a large number of virtual log files in SQL Server 2005 (Updated)

https://support.microsoft.com/kb/979042/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Data is corrupted when you update data that is in an LOB column in a SQL Server 2005 transactional replication

https://support.microsoft.com/kb/979549/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: You experience some problems when you perform a grouping members operation on an Excel pivot table whose data source is an SSAS 2005 cube

https://support.microsoft.com/kb/979777/EN-US

SQL 2008

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: FIX: Error message when you open Replication Monitor for a transactional or merge publication in an instance of SQL Server 2008 that is an upgrade from SQL Server 2000: "Cannot insert the value NULL into column 'isagentrunningnow'" (Updated)

https://support.microsoft.com/kb/970150/EN-US

SQL Svr Standard 2008 EN: FIX: The data collector is disabled after you install an update for an instance of SQL Server 2008 (Updated)

https://support.microsoft.com/kb/970160/EN-US

SQL Svr Standard 2008 EN: FIX: A performance issue occurs when you perform a partition merge operation to move data between partitions in SQL Server 2008 (Updated)

https://support.microsoft.com/kb/976379/EN-US