Indexing doesn’t have to be hard, but you need to have the right level of understanding to get the most out of it. Knowing what’s going on with different types of indexes, and how your index choices affect various components of the SQL engine can cause you to look at indexing in a new way. This demo-heavy session will take you on a journey from the basics of indexing through to advanced concepts that become simple when viewed correctly, using practical examples to explain the theory.


Rob Farley, Owner/Principal LobsterPot Solutions

Rob Farley runs LobsterPot Solutions in Australia, where he’s a consultant in the Microsoft Data Platform and Analytics space. He’s been an MVP since 2006, probably because of his blogging, his presentations around the world, and his dedication to the Adelaide Data & Analytics User Group which he has led since before the release of SQL Server 2005. He’s on Twitter at @rob_farley, but you can always email him using