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
Curtis Seare (@DataCrunchPod) - Co-Host of Data Crunch Podcast discusses his journey & IoT Use cases
Data Podcast
21 minutes 24 seconds
8 years ago
Curtis Seare (@DataCrunchPod) - Co-Host of Data Crunch Podcast discusses his journey & IoT Use cases
Curtis Seare is a co-host of the Data Crunch podcast, a Tableau and Trifacta instructor, and the Director of Analytics at Shelfbucks, a retail analytics startup in Austin, Texas. He’s worked for almost a decade in the data-science field across multiple companies and industries. He’s solved problems spanning IoT, retail, marketing, sales, competitive intelligence, nonprofit donations, and product development, among others. Bringing organizational change and innovation in analytical processes has been the center of his work.
Interviewer: Rajib Bahar, Shabnam Khan
Agenda:
RB - Please give us a little background on Data Crunch podcast's history.
SB - We have listened to your Data Crunch episodes highlighting some really interesting applications of analytics such as preventing honey bee fallout, eradicating malaria in Zambia etc. Please enlighten us more on what you have discovered in your research.
RB - What are some top application of IoT that retailers find useful?
SB - One of the buzzword associated with IoT is streaming analytics. How is this different from standard analytics that we know or understand?
RB - In our lifetime, we may find ourselves in a situation where we over-analyze a problem leading to analysis-paralysis. Is there a methodology do you follow in keeping solutions simple with complex analytics project.
SB - How do we connect with you on Twitter or Social Media or blog?
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