4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

david_morrison.jpg

David Morrison

Dave Morrison is senior BI consultant for Itelligence. Having worked in the IT industry for around 15 years his main area of expertise is SQL Server, namely TSQL, query optimisation, indexing, performance tuning and internals etc.
http://tsqlninja.wordpress.com
David Morrison has submitted 4 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

In this session we will take an in depth look at how query plans work. We will go under the covers and see what happens when you run that query.
I often get asked "What's it like being a consultant?". So much so that I actually have an opening line to that conversation now! In this session we'll look at what life is like for a consultant and see if it's for you
In this session we will take an in depth look at how query plans work. We will go under the covers and see what happens when you run that query.
I often get asked "What's it like being a consultant?". So much so that I actually have an opening line to that conversation now! In this session we'll look at what life is like for a consultant and see if it's for you

Previous Sessions

This session will cover the "Dark Arts" of SQL Server namely performance tuning. Rather than a traditional look at query tuning it will focus on common misconceptions and a look a why sometimes you get query plans that do "odd" things
This session will take a look at query plan operators, what they are, what they each do, why they get chosen and also how to avoid using them when they perform badly. This will be held mainly in management studio with lots of examples
In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen. We'll also take a look into the ups and downs of each
In this session we'll take a look at some nice bits of TSQL coding to resolve troublesome coding problems. We'll also look into writing code to make use of some TSQL features that are under used in daily coding.