Itzik Ben-Gan describes nested window functions and how they could simplify some tedious query scenarios. He asks for your help voting for these to be included in SQL Server.
Tim Radney talks about some of the typical SQL Server mishaps he comes across out in the wild, and resources you can use to avoid them in your own environments.
