For some reason they trusted me to do the first one. It went very well: Ranking and Windowing Functions in SQL Server 2005. After editing, you can view it here: http://www.groktalk.net/blog/
Page rendered at Friday, March 19, 2010 9:02:35 AM (Eastern Daylight Time, UTC-04:00)
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.