The following article talks about using SQL for session:
However, in the "Optimize SQL Server Performance" section you'll see there is a note that mentions that the performance recommendations are not supported in Azure:
These performance enhancements move the session-state store to SQL Server tempDB which is the standard practice recommended by Microsoft. However, this is not supported on Windows Azure.
I would recommend Redis as well...you'll likely get the best performance out of it.