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
Michael Ludwig - Graph Database, Apache Gremlin, & Tinkerpop
Data Podcast
20 minutes 37 seconds
8 years ago
Michael Ludwig - Graph Database, Apache Gremlin, & Tinkerpop
Michael Ludwig is a Data Solution Architect at Microsoft, where he works on Machine Learning, Big Data and Blockchain applications on the Azure platform. Prior to joining Microsoft, Michael worked at Silver Bay, designing and optimizing geographical and financial statistical analysis solutions (mostly regression analysis and clustering). Before that, he was a database architect and then the lead systems architect of a multi-tenant cloud-based Internet-of-Things application for LogicPD, in Minneapolis.
Interviewer: Rajib Bahar, Shabnam Khan
Agenda:
RB - What is the purpose of a graph database? Why do we use it?
SB - Does GoogleMap use graph databases in it's application?
RB - What are the major Graph Systems out there? How does Apache Gremlin fit into that?
SB - SQL Server 2017 has support for graph table.How do you implement it?
RB - How is this similar or dis-similar to graph computing solution implemented in vendor agnostic tools such as Apache Tinker pop?
SB- Who can be involved in coding community of TinkerPop?
RB - How do we connect with you professionally?
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
