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
Varun Bhartia (@VBhartia) - BeeHyve.IO, A learning platform for Computer Scientists
Data Podcast
20 minutes 7 seconds
8 years ago
Varun Bhartia (@VBhartia) - BeeHyve.IO, A learning platform for Computer Scientists
Varun Bhartia is the cofounder of BeeHyve.io an online learning platform for computer science students around the world - helping students connect with each other and with the best career opportunities. He has spend his entire career working in technology NASA, Microsoft, Facebook, and Uber. He has an undergraduate degree from the university of arizona and an mba from Harvard.
Interviewer: Rajib Bahar, Shabnam Khan
Agenda:
RB - You have served some of the most interesting and awesome organizations... As a product manager, what is the most valuable lesson you have learned?
SB - Recently, you left Uber to launch a startup venture called Beehyve so that college students can utilize it as a portal to find exams and homework from prior years... I can see why students would love it... If they can predict the questions on the next test, it'll definitely add value in their academic career. On the other hand, Don't you think professor would hate this idea if they had to do additional homework on coming up with unique test each year? Won't that add risk to your venture? How did you go about critically analyzing all the risk and benefits? What's your vision behind it?
RB - I understand you are working on a Data Vertical. How do you plan to achieve it? Is Cloud computing or Big Data involved in any way?
SB - Lately, IoT is getting similar kind of positive attention Data Science, Cloud Computing, and Big Data part of the world are receiving? Weren't you involved in an IoT competition in Minnesota? Can you tell us your thoughts on it?
RB - How do we connect with you in Twitter, LinkedIn 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