I'm still waiting for the day I actually need to write my own aggregate for SQL server in managed code. This article (requires free registration to read) made me better prepared for that day.