SQL 2005 Webcasts and Virtual Labs
SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage. Choose from a wide range of live and on-demand webcasts. Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities.
SQL Server 2005 Webcasts
TechNet Webcast: Prepare Yourself for Windows Server 2008 (Part 1 of 8): Product Workload Scenarios (Level 300) – Monday, December 03, 2007 9:30 AM Pacific Time (US & Canada)
In this first session of our series, we discuss how Windows Server 2008 addresses key deployment scenarios for customers. We start with an overview of the key product workload scenarios for Windows Server 2008. We cover as many as 10 different scenarios, and we discuss how each scenario can be categorized into one of three different design pillars. While examining the scenarios, we take a closer look at the specific technologies used within the scenario, describe how they are used, and explain why they are needed. We show which technologies comprise each scenario and the value propositions they deliver. Finally, we see how the scenario adds value to Windows Server 2008 and, in some cases, we provide real-world examples of usages for the scenario.
TechNet Webcast: Prepare Yourself for Windows Server 2008 (Part 1 of 8): Product Workload Scenarios (Level 300)
MSDN Webcast: New T-SQL Programmability Features in SQL Server 2008 (Level 300) – Tuesday, December 04, 2007 1:00 PM Pacific Time (US & Canada)
Join this webcast on new T-SQL programmability features in Microsoft SQL Server 2008, an extension from last year's presentation on top Microsoft SQL Server 2005 T-SQL features. We cover exciting new features such as:
New data types (i.e. date/time, filestream, HierarchyID, large UDT, sparse columns)
Dependency management for database objects
Procedure programming (i.e. table value parameter)
Data warehousing enhancements (i.e. Merge data manipulation language (DML) statement, grouping set, filtered indexing)
Supportability (i.e. Data Definition Language (DDL) trigger)
MSDN Webcast: New T-SQL Programmability Features in SQL Server 2008 (Level 300)
Momentum Webcast: Migrating from Access to SQL Server (Level 100) – Wednesday, December 05, 2007 11:00 AM Pacific Time (US & Canada)
Technical audiences currently using Microsoft Office Access will benefit from this tutorial on how to easily migrate databases from Microsoft Office Access 97 through Microsoft Office Access 2003 to Microsoft SQL Server 2005 using Microsoft SQL Server Migration Assistant (SSMA). In this webcast, Dmitry Balin, director of SQL Server marketing, explains different methods of upsizing Access applications to SQL Server (linked tables, Access projects , rewriting to the Microsoft .NET Framework) and shows how SQL Server Migration Assistant automates, streamlines, and simplifies this process. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server. Dmitry also shares experiences from other customers who have benefited from using SSMA and SQL Server to improve their business processes.
Momentum Webcast: Migrating from Access to SQL Server (Level 100)
TechNet Webcast: Using the New Policy-Based Management Framework in SQL Server 2008 (Level 300) – Thursday, December 06, 2007 11:30 AM Pacific Time (US & Canada)
Microsoft SQL Server 2008 introduces a new policy-based framework for database administrators, which can significantly improve administrative productivity and reliability. Database administrators declare their administrative intent through policies that are then applied by the system. This approach reduces the potential for administrative error and enables the framework to monitor or enforce the policies in an automated fashion. Not only can policies be applied to individual databases or tables on a single server, but they can also seamlessly be scaled to include large collections of objects spanning many server instances.
TechNet Webcast: Using the New Policy-Based Management Framework in SQL Server 2008 (Level 300)
Momentum Webcast: SQL Server 2008 (Part 2 of 3): Expanding Business Intelligence Capabilities (Level 100) – Thursday, December 06, 2007 1:00 PM Pacific Time (US & Canada)
Join us for this second webcast in our three-part series on Microsoft SQL Server 2008 to learn all about its new features. SQL Server 2008 builds on the strong momentum in the business intelligence (BI) market by providing a scalable infrastructure that enables IT to drive BI throughout your organization and deliver intelligence where users want it. SQL Server 2008 makes great strides in data warehousing, providing a comprehensive and scalable platform that lets organizations integrate data into the data warehouse faster and to scale and manage that data while delivering insight to all users. With the more scalable BI infrastructure provided by SQL Server 2008, you can easily manage reports and analysis of any size or complexity, and at the same time, empower users through the deeper integration with Microsoft Office programs. SQL Server 2008 also delivers improved performance in many areas, including data warehousing, reporting, and analytics. Join us to learn how you can use SQL Server 2008 to get the right information to the right people in the right format on the right device.
Momentum Webcast: SQL Server 2008 (Part 2 of 3): Expanding Business Intelligence Capabilities (Level 100)
MCP Live Meeting: SQL Server 2008 and Your Microsoft Certifications (Session 1) – Wednesday, December 12, 2007 7:30 AM Pacific Time (US & Canada)
Join the Microsoft Certification team for guidance on your certification path for SQL Server. In this meeting, we will introduce our plans for SQL Server 2008 training and certification, review the SQL Server 2005 certifications, and answer your individual questions about the path that is right for you, in Business Intelligence, Database Development, or Database Administration.
MCP Live Meeting: SQL Server 2008 and Your Microsoft Certifications (Session 1)
Momentum Webcast: SQL Server 2008 (Part 3 of 3): Reducing Hardware and Maintenance Costs with Server Consolidation (Level 100) – Wednesday, December 12, 2007 11:00 AM Pacific Time (US & Canada)
Join us for this final webcast in our three-part series on Microsoft SQL Server 2008 to learn all about its new features. SQL Server 2008 can help reduce hardware and maintenance costs by providing a flexible server consolidation solution. Organizations can centralize data services on fewer servers through server virtualization and support for multiple service instances on a single physical server, along with the tools and functionality to migrate distributed data to a consolidated data center. By providing a centralized data services management interface and declarative, policy-based configuration management, SQL Server can make it easy for organizations with multiple data stores to reduce management overhead. Finally, the enhanced performance in SQL Server 2008 and the ability to explicitly control how your server resources are used enable you to consolidate your data services while providing the scalability and performance your applications need. Join us to learn how you can use SQL Server 2008 to get the right information to the right people in the right format on the right device.
Momentum Webcast: SQL Server 2008 (Part 3 of 3): Reducing Hardware and Maintenance Costs with Server Consolidation (Level 100)
TechNet Webcast: Microsoft SQL Server and FileMaker Pro 9 Interoperability (Level 200) – Wednesday, December 12, 2007 1:00 PM Pacific Time (US & Canada)
Microsoft SQL Server works seamlessly with FileMaker Pro version 9. FileMaker is more than database software; it is a rapid-application development environment that anyone can use to quickly create solutions for collecting, managing, and reporting data. Join this webcast to understand how developers can benefit from connecting FileMaker Pro 9 and Microsoft SQL Server. We also show a technology demonstration of FileMaker Pro 9 connecting with Microsoft SQL Server.
TechNet Webcast: Microsoft SQL Server and FileMaker Pro 9 Interoperability (Level 200)
MCP Live Meeting: SQL Server 2008 and Your Microsoft Certifications (Session 2) – Wednesday, December 12, 2007 5:00 PM Pacific Time (US & Canada)
Join the Microsoft Certification team for guidance on your certification path for SQL Server. In this meeting, we will introduce our plans for SQL Server 2008 training and certification, review the SQL Server 2005 certifications, and answer your individual questions about the path that is right for you, in Business Intelligence, Database Development, or Database Administration.
MCP Live Meeting: SQL Server 2008 and Your Microsoft Certifications (Session 2)
Further on-demand webcasts are available here: http://www.microsoft.com/events/series/technetsqlserver2005.mspx