TechEd-Developers Hands-on-Labs (HOL) Schedule

Today I received my Hands-on-Lab (HOL) and Ask-the Expert (ATE) schedule and will be assisting delegates with the SQL Server 2005 HOL's and working on the SQL Server 2005 Ask-the-Expert booth.

Ronald has done an excellent job this year and managed to work my schedule around the MS Influencer Community Camp, Speaker Idol waves and all the sessions I want to attend. This is shaping up to be an awesome event.

Ask-the-Experts Schedule

Tuesday 6th : 10:00 - 13:00

HOL Schedule

Monday 5th : 16:00 - 19:00
Tuesday 6th : 13:00 - 15:15
Wednesday 7th : 15:45 - 18:45
Friday 9th : 8:00 - 13:00

SQL Server 2005 HOL Labs

DAT01-HOL - Using Microsoft SQL Server 2005 for Data Warehousing: SQL Server 2005 provides a complete and integrated platform for Data Warehousing. SQL Server enables customers to build Data Warehouses faster, manage their growing volumes of data more effectively, and deliver insights to users for making informed decisions. This lab walks you through the partitioning capabilities in SQL Server and demonstrates how they can be used to build more manageable and scalable data warehouses.

DAT02-HOL - Microsoft SQL Server 2005: Database Mirroring: The goal of this lab is to provide an understanding of when to use one of the more advanced new features of SQL Server 2005: Database Mirroring.

DAT03-HOL - Microsoft SQL Server 2005: Service-Oriented Database Architecture: The goal of this lab is to provide an understanding of when to use one of the more advanced new features of SQL Server 2005: Support for the Service-Oriented Database Architecture.

DAT04-HOL - Learn How to Build Occasionally Connected Applications: Explore how you can build offline smart client applications in a RAD way that synchronizes backend database with a local Microsoft SQL Server Compact Edition store using the Microsoft Synchronization Services for ADO.NET. The lab walks you through the Microsoft Visual Studio Designer to help build a two-tier application and N-tier application that incrementally downloads data that can be cached on a SQL Server Compact Edition store. You can also explore how to perform bidirectional synchronization with conflict detection using these synchronization components.

DAT05-HOL - Understanding Command-Line Management Using SQLCMD: The exercises in this lab provide you with best practices and implementation details for SQL Server 2005 SQL CMD management tool. Learn to use SQLCMD with an initialization file, system environment variables, and parameters to create customized "master" scripts for automation and administration. Learn to use SQLCMD and SQL Server Management Studio with the Dedicated Admin Connection for troubleshooting. Finally, use SQL Server Management Studio to modify and execute SQLCMD mode scripts, and upgrade databases from SQL Server 2000 using a parameterized script running with SQLCMD.

DAT06-HOL - Understanding the ADO.NET Entity Framework: In this lab you will be introduced to the ADO.NET Entity Framework and learn to create a new Entity Data Model from an existing database and edit the default mapping to reflect the conceptual model that will be used for your application. Create a new Application and learn to use LINQ to Entities and/or Entity SQL to query data exposed through your new Entity Data Model.

DAT07-HOL - Microsoft SQL Server 2005: Table and Index Partitioning: In this lab, gain an understanding of when to use one of the more advanced new features of SQL Server 2005: able and Index Partitioning.

DAT08-HOL - SQL Server 2005 Online Operations: The goal of this lab is to understand, define, and manage the class of operations known as Online Operations. In this lab, the key Online Operations covered are:

• Online Index Creation/Move
• Online conversion to/from non-partitioned tables to partitioned tables
• Partial Database Availability
• Online Piecemeal Restore

DAT09-HOL - Effectively Using the Integrated Management Tools of Microsoft SQL Server 2005: The intent of these exercises is to provide you with best practices and implementation details for SQL Server 2005 Management Studio. Use Microsoft SQL Server Management Studio (SSMS) to reset the password and register all SQL Server instances. Create databases using the graphical tools as well as Transact-SQL (generated through SSMS). Generate Database Diagrams using SSMS. Use Object Explorer to view, filter, modify, and drill into a variety of different types of objects.

DAT10-HOL - Microsoft SQL Server 2005: Peer-to-Peer Replication: This series of exercises shows you how Peer-to-Peer Replication works and how to setup a Peer-to-Peer replication topology using the Replication Wizards.

DAT11-HOL - Query Tuning in Microsoft SQL Server 2005: This lab guides you through some common query performance tuning exercises including troubleshooting deadlocks, query plans, and using the Database Tuning Advisor. Learn how to use the various tools provided with SQL Server 2005 to effectively troubleshoot and tune queries in SQL Server. This lab requires prior experience with basic administration in SQL Server 2000, familiarity with T-SQL, and familiarity with SQL Server 2005 Workbench; or prior completion of the lab on SQL Server Workbench.

DAT12-HOL - Microsoft SQL Server 2005: Snapshot Isolation: The goal of this lab is to provide an understanding of when to use one of the more advanced new features of SQL Server 2005: Snapshot Isolation.

DAT13-HOL - SQL Server 2005 T-SQL Enhancements: Many enhancements have been made to T-SQL and this lab provides exercises to help you understand how these enhancement work and how you may leverage them in your environment. The lab exercises cover usage of new data types, recursive query expressions, triggers, exception handling and the new PIVOT/UNPIVOT operators. This lab requires prior basic working experience with SQL Server 2000, familiarity with T-SQL in SQL Server 2000, and familiarity with SQL Server 2005 Management Studio; or prior completion of the lab on SQL Server Management Studio

DAT15-HOL - How to Upgrade to Microsoft SQL Server 2005: Prescriptive Guidance and Practical Techniques: Are you interested in lowering the risks and costs of upgrading? By completing these six SQL Server 2005 Hands-on-Labs, you will gain valuable experience in performing upgrades involving both the relational database engine and business intelligence components. The primary purposes of these labs are to: 1) Learn new techniques on how to planning an upgrade from SQL Server 2000 or 7.0 to SQL Server 2005, 2) Increase your confidence and reduce upgrade risks by performing in-place and side-by-side upgrades SQL Server 2005, and 3) Learn about valuable SQL Server 2005 upgrade resources and diagnostic tools such as the Upgrade Advisor.

DAT16-HOL - Using Web Services with Microsoft SQL Server 2005: Learn how to create an XML Web service running inside SQL Server 2005. In this lab, use T-SQL to create a Web service via T-SQL, consume it via T-SQL and then use Microsoft Visual Studio 2005 to create a client that calls the Web service. This lab requires prior basic familiarity with SQL Server Management Studio and Visual Studio 2005.