Recently at work we have been discussing how to write scalable applications with ASP.NET, and one of the issues raised was handling session state. We were aware of the ability to store a session in SQL Server, but none of us had enough practical experience to speak authoritatively.
And then an article on Understanding Session State drops into my Bloglines account.