Changed the cache from Runtime to AzureRedis
Changed the connection string to SQL Azure
Disabled the Session State
Elmah now reports using SqlErrorLog
Api XML document now resides in App_Data
Removed the SELECT INOT as SQL Azure does not supports. Replaced with traditional INSERT INTO using TABLE variables