A place where we write words Ignition Blog

Welcome to the Ignition Development blog, where we talk about a wide range of technical and non-technical topics.

SQL

Posts related to Microsoft's SQL Server.

ASP.NET, Azure, Database, EntityFramework Performance Pointers

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...

This blog entry was posted @ Thursday, August 13, 2015 11:36 AM | Feedback (0) | Filed under SQL · Technical