Chris has been a SQL Server professional fro over fifteen years and has worked in roles varying from DBA to developer to architect and has spoken at the last four SQL Bits as well as multiple SQL Saturday events around Europe. Chris's overriding passion is take workloads, scale them, push the engine to its limits and find out where its edges are and what its doing under the covers, how it is utilising the CPU at a deep level and often using tools such as windows performance toolkit in order to dig right down to call stack level . Currently, Chris works for Pure Storage as its EMEA SQL Server solutions architect.
Sessions
An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques.
A deep dive into batch mode scalability with column store index and SQL 2014.
This session is a primer on column store indexes and SQL Server batch mode, it delves into the background behind the performance gains achieved by batch mode and includes demos on things that can be done to further enhance batch mode performance.
This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server such that all available hardware resources are utilised as fully as possible.
An advanced look into how memory works in modern servers, on modern processors and how to leverage it with SQL Server.
You are hitting performance and scalability issues with the database engine, conventional wisdom and tools and getting you nowhere, where do you go ?, windows performance toolkit has the answers.
The storage industry is at one of the greatest inflection points in its history. Learn the basics of flash storage and how conventional wisdom needs to change and how best to leverage what is fast becoming the main stream storage technology.