SQLBits 2015

Think Inside the Box! Understanding the Query Life Cycle

In this session we'll take two queries, a read and a write one, and look at the whole trip from the client through the server and back to the client. On this journey we'll try to identify where things might go wrong.
For developers, the database is like a mythical land where data (un)happily lives on green pastures. For DBA's, the applications are annoying things that make their finely tuned servers loose breath. Because they are both involved in the development, and to achieve harmony, we must learn about the whole request/query life cycle. In this session we'll take two queries, a read and a write one, and look at the whole trip from the client  through the server and back to the client. On this journey we'll try to identify where things might go wrong,  thus helping to bring friendship between developers and DBA's back.