Turns out it has been moved.  To open the new Activity Monitor you either right click a database and select 'Activity Monitor', or you click the icon that looks like a chart on the far right of SSMS.

Great introduction to the DATE data type (different from DATETIME)...

http://www.sqlteam.com/article/using-the-date-data-type-in-sql-server-2008

http://geekswithblogs.net/darrengosbell/archive/2006/04/26/76418.aspx

Step 1: Add the SSAS server as a linked server.

Step 2: Use OpenQuery clause in SELECT statement to write MDX query that will be the data source within a data transfer task in SSIS.

http://www.sqlservercentral.com/articles/Integration+Services/64133/

great introduction to Data Profile Viewer in SQL 2008.... the gist of it is that you use an SSIS task to create an xml profile that can be loaded into the "Data Profile Viewer" to analyze the metadata.

Basics of change data capture (CDC) in SQL 2008: http://msdn.microsoft.com/en-us/library/cc645937.aspx

This is a great introduction to the CDC capabilities of SQL 2008.  It's part of the larger CDC topic covered in BOL: http://msdn.microsoft.com/en-us/library/bb522489.aspx

I passed the 70-431 exam today and I now have my MCTS (certified technology specialist) title!  :)

here's more info on the exam: http://www.microsoft.com/learning/en/us/exams/70-431.aspx