I know SQL Server 2008 isn't out until next year, but I stumbled across this free training.
It's an online course, but you can download and install an offline player, which lets you run it all offline.
Title: Clinic 7045: What's New in Microsoft® SQL Server™ 2008
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 2 Hours
Description: In this clinic, you will learn about the new and enhanced features included in SQL Server 2008. You will explore the new data types and the data management features. Additionally, you will learn about the enhanced Integration Services, Analysis Services, and Reporting Services included in SQL Server 2008. This online clinic is composed of a rich multimedia experience.
Firstly, let me apologise for not posting for a while. I do have a good excuse - I've been on holiday (seven days in Sardinia - hot & sunny - makes a change from the rain)! I got back last last Tuesday and was delivering this months Longhorn Academy on Wednesday. Thursday I got on a plane again and I'm now in Seattle (Microsoft has has me working ever since).
The last Longhorn Academy covered Security and Policy Enforcement and in particular network Access Protection (NAP). One of the questions that came up (that we didn't have a good answer for) was what would happen to a NAP enabled laptop entering another customers NAP enabled network (would the network admin have the ability to update the guest laptop).
This is the answer (from the documentation):
· Verifying the health state of visiting laptops
Organizations frequently need to allow consultants, business partners, and guests to connect to their private networks. The laptops that these visitors bring might not meet system health requirements and can present health risks. By using NAP, administrators can determine that the visiting laptops are not compliant and limit their access to a restricted network. Typically, administrators would not require or provide any updates or configuration changes to the visiting laptops. The administrator could configure Internet access for visiting laptops, but not for other organization computers whose access is limited.
One last thing, the step-by-step guides I mentioned can be found here. They are very good, so if you have time (probably half a day for each) - play away.