Chris is a freelance SQL DBA / developer who has been using SQL Server since 2000, his passion is for scaling SQL Server and understanding how the engine behaves at depth when pushed to its limits.
Chris Adkin has submitted 4 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions
This session will delve into how modern CPUs work, how batch mode leverages CPU caches and where the pressure points on the CPU are. As a teaser it will demonstrate how a larger column store can out perform a smaller one.
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 covers how modern CPU architectures work, how SQL Server leverages memory in depth and demonstrate via CPU level profiling how the batch engine utilises different CPU resources.
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 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.