Gavin Payne
Gavin Payne is a specialist at helping businesses of all sizes grow faster by evolving their analytics, data and cloud capabilities.
SQLBits 2018
An introduction to SQL Server for data scientists
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster. Whether you use SQL Server as a data source or as a R or Python query processing platform, knowing how it processes queries, manages memory and reads from disk is key to making it work harder and faster.
This session introduces and demonstrates how SQL Server:
It then introduces some query tuning techniques to help heavyweight analytics queries run faster.
The session uses Gavin Payne’s 20 years’ experience of working with SQL Server – mostly making it run faster, stay secure and remain available.
This session introduces and demonstrates how SQL Server:
- operates internally
- performs select queries
- uses indexes to make queries run faster
- executes machine learning code to make operational predictions
It then introduces some query tuning techniques to help heavyweight analytics queries run faster.
The session uses Gavin Payne’s 20 years’ experience of working with SQL Server – mostly making it run faster, stay secure and remain available.