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.
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.