An introduction to SQL Server for data scientists - Gavin Payne
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:
- 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.
Speaker Bio:
Gavin is both a technology focused management consultant and solution architect who enjoys helping businesses implement new capabilities and solve existing problems. He does this by using his understanding of strategy and transformation to advise leadership teams on what they should do and his knowledge of Microsoft’s data, analytics, and productivity technologies.
Pizza and drinks will be provided by our hosts Just Eat!
P.S. We're always keen to hear from people who may be interested in doing a talk. If you or someone you know would like to present to our friendly audiences, we welcome those looking to gain experience of speaking as well as seasoned pro's. We can discuss/support co-presenting for speakers who prefer to share the limelight, and are happy to run through ideas and draft presentations. Please get in touch at: [masked]