Database projects

Script SQL Server 2008 Diagrams to a file
Generate a text/sql file representing your database diagrams - to store in version control, backup with other schema script or transfer to another copy of the database.
Script SQL Server 2005 Diagrams to a file
Generate a text/sql file representing your database diagrams - to store in version control, backup with other schema script or transfer to another copy of the database.
Battleship 2008 - GEOMETRY datatype in SQL Server
Sample game using the GEOMETRY datatype, Well-Known-Text and spatial functions new in SQL Server 2008.
Geoquery2008
Visualize spatial (geometry and geography) queries using SQL Server 2008's new features (also at Geoquery2008.com).

Useful links

MSDN
As always, the Microsoft sites are a good place to start...

ScriptDiagram2008
Go straight to the diagram-scripting-SQL

Geoquery2008.com
Go straight to Geoquery 2008.