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
All content for Data Podcast is the property of Rajib Bahar, Shabnam Khan and is served directly from their servers
with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.
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
Frank La Vigne (@TableTeer) - Microsoft Data Science Certification & Data Driven podcast
Data Podcast
30 minutes 48 seconds
8 years ago
Frank La Vigne (@TableTeer) - Microsoft Data Science Certification & Data Driven podcast
Frank La Vigne leads the Data & Analytics practice at Wintellect and co-hosts the DataDriven podcast. He blogs regularly at FranksWorld.com and you can watch him on his YouTube channel, “Frank’s World TV” (FranksWorld.TV).
Interviewer: Rajib Bahar, Shabnam Khan
Agenda:
RB - You have recently gone through Microsoft's Professional Certification for Data Scientists. Also, you are training others in this area. What are the 4 units of this Data Science certification program, and where does the units of modules also overlap with Microsoft's Big Data certifiation program?
SB - Can you tell us a little bit about the Cortana Intelligence Capstone project in Data Science certification? What sort of time committment and technical knowledge required?
RB - We often see questionable studies stating something like coffee is unhealthy followed by a counter study contradicting it? Does statistics or overfitting a data model play a role in it?
SB - One of the cool thing you do is co-hosting the "Data Driven" podcast with Andy Leonard. He was our guest in the past. In your facebook page for "Data Driven" podcast, your listeners also get to become your viewer and see live videos from Data Science, SQL Server, & other Technology related conferences. What are some insights from recent big conferences.
RB - How do we connect with you in Twitter or Blogs or Social Media in general?
Music: www.freesfx.co.uk
Data Podcast
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
