Jan’s magic performance improvement wand is legendary among the Ignition team and among some of our customers. However, behind the magic lurks common sense combined with years of experience at performance tuning. Over on his personal blog, he’s written a post that focuses on some common database related performance optimisations for applications hosted on Azure. Shifting an app to Windows Azure is a great way to expose database related performance issues. Quite simply, SQL Azure has some fundamental differences to a traditional “on site database”, such as limitations on DTUs (database throughput units) and the need to handle transient failures...