July 2010 - Technical Rollup Mail - SQL Server
News
SQL 2008 R2
SYSPREP in SQL Server 2008 R2
SQL Server 2008 R2 Offers Enhancements, New Management Capabilities
With the late April release of its SQL Server 2008 R2, Microsoft has extended its popular database server product with core platform enhancements, new management capabilities and a raft of features focused on enabling self-service business intelligence scenarios.
Seven Reasons To Care About SQL Server 2008 R2
https://news.yahoo.com/s/infoworld/20100609/tc_infoworld/126631
"With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database."
Other
https://blogs.technet.com/trm/default.aspx
Downloads
SQL 2008
BizTalk Server 2010 Beta
BizTalk Server 2010 Beta is an integration server that provides connectivity, Business Process Management (BPM), and SOA/ESB capabilities. It also includes Business to Business (B2B) integration capabilities, Adapters, Accelerators, and an RFID platform.
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 2008 R2
SQL Server 2008 R2 Best Practices Analyzer
Events/Webcasts
TechNet Webcast: SQL Server 2008 R2: Upgrading SQL Server Business Intelligence Components (Level 300)
Thursday, July 15, 2010 8:00 AM Pacific Time (US & Canada)
Unless you are dealing with a totally new Microsoft SQL Server installation, the upgrade process is clearly an important part of the installation story. In this webcast, we explain what you need to consider when upgrading to Microsoft SQL Server 2008 R2 with a focus on the business intelligence components, Reporting Services and Integration Services. Topics we cover include:
Using automated tools and using manual processes for the upgrade.
Upgrading Reporting Services to SQL Server 2008 R2 and moving report servers.
Moving legacy SQL Server ETL packages.
Automating much of the upgrade with SQL Server Integration Services (SSIS) packages.
Upgrading from the earlier Data Transformation Services (DTS).
Verifying upgrade attempts.
Presenter: Andrew Fryer, IT Pro Evangelist, Microsoft Corporation
View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032455446&culture=en-US
New KB's
2005
SQL Server 2005 Service Pack 3 Cumulative Update 10 Released
https://support.microsoft.com/kb/983329.
2008 R2
Cumulative Update package 2 for SQL Server 2008 R2