While at SQL Saturday Dublin, Andy asks the experts: "Where does your area of expertise intersect with Data Science?"

There are some thought provoking answers.

*Live at #SqlSatDublin* Andy Asks: How Do Your Skills Intersect with Data Science

Do you know somebody who is apprehensive in getting into data science because they think it's too complex?

If you enjoyed this episode, check out show notes, resources, and more at https://www.superdatascience.com/102

The Super Data Science Podcast: Big Data | Analytics Careers | Mentors | Success

SDS 102: Intuition vs Mathematics in Data Science

Joe Sack is a Principal Program Manager in the Azure SQL Database and SQL Server product team at Microsoft, with a focus on the Query Processor. Joe is an author and speaker with over 20 years of experience in the industry, specializing in performance tuning, high availability and disaster recovery.

Interviewer: Rajib Bahar, Shabnam Khan

Agenda:

RB - Your team created Adaptive Query Processing or QP. It is new in SQL Server 2017 and SQL Azure. As we know, SQL Server uses query plan internally to run tsql statements. Sometimes the plan chosen by the query optimizer is not optimal for reasons such as incorrect cardinal estimate and various other issues. What are some other pain points Adaptive QP is meant to cure?

SB - Adapative QP's strength lies behind Batch mode memory grant feedback, Batch mode adaptive joins, Interleaved execution... How do they work internally? 

RB - What are steps to enabling QP and some best practices? Can you tell us what's in the pipe line for upcoming enhancement? 

SB - How do we connect with you on Social Media?

Music: www.freesfx.co.uk

rajib.bahar

Joe Sack (@JoeSackMSFT) - Adaptive Query Processing in SQL Server 2017 Engine

Our podcast includes both technical & non-technical discussions on BigData, DataScience, BI, AI, DW, Business Intelligence, TDWI, SqlServer, SQL, NoSql, AWS, Azure, R, Python.

Hosts: Rajib Bahar, Shabnam Khan

Joe Sack (@JoeSackMSFT) - Adaptive Query Processing in SQL Server 2017 Engine

Data Podcast

Related tracks