February 2010 – Technical Rollup Mail – SQL
News Microsoft SQL Server 2008 R2 Launch Set For MayMicrosoft this week announced an official delivery date for Microsoft SQL Server 2008 R2 Dave Campbell on SQL Server 2008, Cloud Services, and More What he thinks about the latest SQL Server release, Kilimanjaro, Madison, and Azure. Reduce IT Spending While Still Upgrading to SQL Server 2008 The latest features and functionality included out-of-the-box with SQL Server 2008 will allow IT managers to save a tremendous amount of money and at the same time reduce management costs, hence it is worth the investment and you should upgrade to SQL Server 2008. The big stories in the database arena in 2008 included cloud databases, the release of SQL Server 2008 and acquisitions,... Microsoft hires noted database researcher to help scale SQL Server DeWitt to head research lab at UW-Madison, hopes to see results make their way into products. Test Center review: Deep dive into SQL Server 2008 Microsoft unveils a road map for SQL Server "Kilimanjaro," which will contain new BI capabilities. Have Microsoft's new tools made you the part-time DBA? SQL Server 2008 isn't revolutionary by any stretch, but it includes a slew of new features that probably make this a no-brainer upgrade for most developers who rely on previous versions of SQL Server. Microsoft Professional Developers Conference 2008 Virtual Pressroom Check out the highlights from PDC 2008! Microsoft Focuses on BI for SQL Server Kilimanjaro Microsoft unveils a road map for SQL Server "Kilimanjaro," which will contain new BI capabilities. Microsoft Empowers Enterprises to Think Bigger About Business Intelligence Microsoft Corp. today kicked off its second annual Microsoft Business Intelligence (BI) Conference 2008 by announcing groundbreaking new technologies that will enable enterprises to bring the power of BI to information workers organization wide. New “managed self-service” business intelligence technologies and enhanced enterprise-class data warehousing capabilities usher in an era of truly pervasive BI. Other Technical RollUp https://blogs.technet.com/trm/default.aspx Documents SQL Server documentation forum https://social.technet.microsoft.com/forums/en-US/sqldocumentation/threads/ Downloads SQL 2008 SQL Server Migration Assistant for Oracle SQL Server Migration Assistant (SSMA) 2008 for Oracle is a complete suite of tools that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2008. Microsoft Assessment and Planning Toolkit for SQL Server 2008 Migration Accelerate your planning for migration to SQL Server 2008 with the free Microsoft Assessment and Planning Toolkit. Automate the discovery of existing SQL instances in preparation for upgrades in just a few hours. https://technet.microsoft.com/en-gb/library/bb977556.aspx Events/Webcasts Cloud Computing Webcast Series - 'Connecting the Deskless Worker for the Healthcare Industry' Monday, February 01, 2010 2:00 PM Eastern Time (US & Canada) Join us for a live webcast to discuss 'Connecting the Deskless Worker for the Healthcare Industry'! https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032435077&culture=en-US TechNet Webcast: Deploying Kronos Workforce Management Solutions Using SQL Server 2008 (Level 200) Wednesday, February 03, 2010 8:00 AM Pacific Time (US & Canada) Kronos Workforce Central is one of the most widely deployed solutions used for employee management in nearly every industry. Using Microsoft SQL Server 2008 database software to power Workforce Central lets you take full advantage of the capabilities of Workforce Central, and you can use the built-in data mining capabilities and reporting features in SQL Server 2008 to gain insights into your labor force that were previously hidden. In this webcast, we discuss why SQL Server 2008 should be your choice for deploying Kronos, and we talk about some of the technical considerations for deploying Workforce Central using SQL Server 2008. Presenters: Allan Hirt, SQL Server MVP, Megahirtz and Anu Chawla, Director, Microsoft Corporation Allan Hirt has been using Microsoft SQL Server since 1992, while on a college internship at Sybase, and he has worked with all of the Windows versions of SQL Server since Microsoft SQL Server 4.21a. He has also worked with other relational database management systems over the years, including Oracle, Sybase, and Informix, and he can relate to non-SQL Server database administrators. For the past ten years, Allan has traveled throughout the world, working with customers and delivering training. He is currently based in the Boston, Massachusetts, area. Allan has authored or contributed to whitepapers, webcasts, training courses, and books, and is also a frequent speaker at conferences like Microsoft TechEd and the Professional Association for SQL Server (PASS) Community Summit. Allan's most recent book is Pro SQL Server 2008 Failover Clustering (Apress, 2009), and his most recent whitepaper on consolidation was published in October, 2009. Anu Chawla joined Microsoft in 2003 as a technical evangelist in the Developer and Platform Organization. In his current role as a Business Development Manager he works with strategic Global ISV partners. Prior to Microsoft he worked at Siebel Systems for 4 years as a Principal Consultant and Technical Account Manager. At Siebel he helped several large companies such as Philips Medical, Nike and T-Mobile integrate their Siebel CRM Systems with SAP ERP. Anu has an MS in Computer Science and MBA. 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=1032439725&culture=en-US TechNet Webcast: Deploying PTC Windchill Using Microsoft SQL Server (Level 200) Tuesday, February 09, 2010 8:00 AM Pacific Time (US & Canada) In a competitive manufacturing environment, it can be difficult to gain an edge on competitors by delivering products that go to market faster while also addressing other business concerns such as minimizing costs, adhering to regulations, and maintaining a global supply chain. PTC Windchill is an industry-leading solution that helps manufacturers meet these challenges. Attend this webcast to learn why you should deploy PTC Windchill using Microsoft SQL Server database software and to hear some of the most important technical considerations for deploying Workforce Central using SQL Server. Presenters: Allan Hirt, SQL Server MVP, Megahirtz and Anu Chawla, Director, Microsoft Corporation Allan Hirt has been using Microsoft SQL Server since 1992, while on a college internship at Sybase, and he has worked with all of the Windows versions of SQL Server since Microsoft SQL Server 4.21a. He has also worked with other relational database management systems over the years, including Oracle, Sybase, and Informix, and he can relate to non-SQL Server database administrators. For the past ten years, Allan has traveled throughout the world, working with customers and delivering training. He is currently based in the Boston, Massachusetts, area. Allan has authored or contributed to whitepapers, webcasts, training courses, and books, and is also a frequent speaker at conferences like Microsoft TechEd and the Professional Association for SQL Server (PASS) Community Summit. Allan's most recent book is Pro SQL Server 2008 Failover Clustering (Apress, 2009), and his most recent whitepaper on consolidation was published in October, 2009. Anu Chawla joined Microsoft in 2003 as a technical evangelist in the Developer and Platform Organization. In his current role as a Business Development Manager he works with strategic Global ISV partners. Prior to Microsoft he worked at Siebel Systems for 4 years as a Principal Consultant and Technical Account Manager. At Siebel he helped several large companies such as Philips Medical, Nike and T-Mobile integrate their Siebel CRM Systems with SAP ERP. Anu has an MS in Computer Science and MBA. 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=1032439727&culture=en-US TechNet Webcast: Best Practices for Running Temenos T24 on SQL Server 2008 (Level 300) Wednesday, February 24, 2010 8:00 AM Pacific Time (US & Canada) In this webcast, we share the best practices for deploying the Temenos T24 core banking applications on Microsoft SQL Server 2008 database software. We talk in detail about performance, high availability, and scaling T24 applications on the Windows Server 2008 R2 operating system and SQL Server 2008 with the help of practical customer deployments. We also discuss the new agreement Microsoft and Temenos recently signed to collaborate more closely and commit technical, marketing, and sales resources to bring to market a flexible, high-performance, and reliable core banking solution that fully optimizes the use of the Microsoft platform with T24. Join us to learn about technical benefits this close relationship offers customers who are deploying T24 on a Microsoft platform. Presenters: Roger Toren, Principal MCS Consultant on SQL Server, Microsoft Corporation and Anu Chawla, Director, Microsoft Corporation Anu Chawla joined Microsoft in 2003 as a technical evangelist in the Developer and Platform Organization. In his current role as a business development manager, he works with strategic Global ISV partners. Prior to Microsoft, Anu worked as a principal consultant and technical account manager at Siebel Systems for four years. At Siebel, he helped several large companies, including Philips Medical, Nike, and T-Mobile, integrate their Siebel CRM Systems with SAP enterprise resource planning (ERP) software. Anu has a master's degree in computer science and a Master of Business Administration (MBA). 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=1032440414&culture=en-US TechNet Webcast: Deploying Siemens PLM Teamcenter Using SQL Server 2008 (Level 200) Wednesday, February 17, 2010 8:00 AM Pacific Time (US & Canada) Siemens PLM Teamcenter is one of the most popular product life-cycle management software products on the market. Teamcenter takes advantage of various Microsoft technologies, including Windows Server 2008 and SQL Server 2008, to deliver an end-to-end solution that reduces cost while increasing collaboration and efficiency. Come learn how deploying Teamcenter using SQL Server 2008 for the database can benefit your organization, and hear some of the technical considerations for deploying Teamcenter using Microsoft technologies. Presenters: Allan Hirt, SQL Server MVP, Megahirtz and Anu Chawla, Director, Microsoft Corporation Allan Hirt has been using Microsoft SQL Server since 1992, while on a college internship at Sybase, and he has worked with all of the Windows versions of SQL Server since Microsoft SQL Server 4.21a. He has also worked with other relational database management systems over the years, including Oracle, Sybase, and Informix, and he can relate to non-SQL Server database administrators. For the past ten years, Allan has traveled throughout the world, working with customers and delivering training. He is currently based in the Boston, Massachusetts, area. Allan has authored or contributed to whitepapers, webcasts, training courses, and books, and is also a frequent speaker at conferences like Microsoft TechEd and the Professional Association for SQL Server (PASS) Community Summit. Allan's most recent book is Pro SQL Server 2008 Failover Clustering (Apress, 2009), and his most recent whitepaper on consolidation was published in October, 2009. Anu Chawla joined Microsoft in 2003 as a technical evangelist in the Developer and Platform Organization. In his current role as a Business Development Manager he works with strategic Global ISV partners. Prior to Microsoft he worked at Siebel Systems for 4 years as a Principal Consultant and Technical Account Manager. At Siebel he helped several large companies such as Philips Medical, Nike and T-Mobile integrate their Siebel CRM Systems with SAP ERP. Anu has an MS in Computer Science and MBA. 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=1032439852&culture=en-US TechNet Webcast: Deploying Dassault Systèmes ENOVIA Using SQL Server 2008 (Level 200) Thursday, February 25, 2010 8:00 AM Pacific Time (US & Canada) Dassault Systèmes ENOVIA delivers a proven service-oriented architecture to help manage a product's life cycle for any size company, whether a small business or a large enterprise. ENOVIA v6 is Dassault's most powerful version to date, and using Microsoft SQL Server 2008 as the database for Enovia and running the solution on a Microsoft platform lets you take full advantage of Enovia's power. In this session, we explain why SQL Server 2008 is the best choice for ENOVIA deployments, and we cover some of the more important technical considerations for deploying ENOVIA using a Microsoft software stack. Presenters: Allan Hirt, SQL Server MVP, Megahirtz and Anu Chawla, Director, Microsoft Corporation Allan Hirt has been using Microsoft SQL Server since 1992, while on a college internship at Sybase, and he has worked with all of the Windows versions of SQL Server since Microsoft SQL Server 4.21a. He has also worked with other relational database management systems over the years, including Oracle, Sybase, and Informix, and he can relate to non-SQL Server database administrators. For the past ten years, Allan has traveled throughout the world, working with customers and delivering training. He is currently based in the Boston, Massachusetts, area. Allan has authored or contributed to whitepapers, webcasts, training courses, and books, and is also a frequent speaker at conferences like Microsoft TechEd and the Professional Association for SQL Server (PASS) Community Summit. Allan's most recent book is Pro SQL Server 2008 Failover Clustering (Apress, 2009), and his most recent whitepaper on consolidation was published in October, 2009. Anu Chawla joined Microsoft in 2003 as a technical evangelist in the Developer and Platform Organization. In his current role as a Business Development Manager he works with strategic Global ISV partners. Prior to Microsoft he worked at Siebel Systems for 4 years as a Principal Consultant and Technical Account Manager. At Siebel he helped several large companies such as Philips Medical, Nike and T-Mobile integrate their Siebel CRM Systems with SAP ERP. Anu has an MS in Computer Science and MBA. 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=1032440111&culture=en-US New KB's SQL 2005 SQL Svr Developer Edtn 2005 EN: How to troubleshoot the "Cannot generate SSPI context" error message (Updated) https://support.microsoft.com/kb/811889/EN-US SQL Svr Developer Edtn 2005 EN: How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008 (Updated) https://support.microsoft.com/kb/945934/EN-US SQL Svr Enterprise Edtn 2005 EN: A SQL Server cluster resource goes to a "failed" state when you try to bring the resource online in SQL Server (Updated) https://support.microsoft.com/kb/883732/EN-US SQL Svr Standard Edtn 2005 EN: SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS) (Updated) https://support.microsoft.com/kb/919023/EN-US SQL Svr Standard Edtn 2005 EN: FIX: Membership is not scripted in the predefined database roles after you script a database and enable the "Script object-level permissions" option in SQL Server 2005 (Updated) https://support.microsoft.com/kb/973785/EN-US SQL Svr Standard Edtn 2005 EN: FIX: An insert operation for a temporary table that has a foreign key constraint fails when the execution plan for the INSERT statement contains a merge join operation in SQL Server 2005 (Updated) https://support.microsoft.com/kb/977100/EN-US SQL Svr Standard Edtn 2005 EN: FIX: Assertion failures occur in SQL Server 2005 when a Distributed Transaction Coordinator (DTC) transaction is rolled back while that transaction is being commited by the DTC (Updated) https://support.microsoft.com/kb/977350/EN-US SQL 2008 SQL Svr Standard 2008 EN: Error message when you try to generate a Report Builder model from a data source in SharePoint Server 2007 or in Windows SharePoint Services 3.0: "Server was unable to process request. ---> The operation has timed out" (Updated) |