GIS & Spatial How-tos for SQL Server 2008

So how do you get started incorporating spatial data in SQL Server 2008? Here's some samples, tutorials, and how-tos for using GIS support.