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
Bill Inmon, Father of Datawarehouse discusses history & relevance of DW in age of Big Data
Data Podcast
22 minutes 1 second
8 years ago
Bill Inmon, Father of Datawarehouse discusses history & relevance of DW in age of Big Data
Bill Inmon – the “father of data warehouse” – has written 57 books published in nine languages. Bill’s latest adventure is the building of technology known as textual disambiguation – technology that reads raw text in a narrative format and allows the text to be placed in a conventional data base so that it can be analyzed by standard analytical technology, thereby creating unique business value for Big Data/unstructured data. Bill was named by ComputerWorld as one of the ten most influential people in the history of the computer profession. Bill lives in Castle Rock, Colorado. For more information about textual disambiguation refer to www.forestrimtech.com.
Interviewer: Rajib Bahar, Shabnam Khan
Agenda:
SB - In the 1970s, you have coined the term, "Datawarehouse". There are countless Data gurus referring to you as the father of "Datawarehousing". We are curious how did your journey start? What did you envision a "Datawarehouse" to be back then, and now?
RB - Who were the earliest adopter? What were some interesting discoveries back then? How has the industry evolved?
SB - In current state of the Data industry, do you think Datawarehousing is relevant in this hyped up age of Big Data and Data Science? Do these technologies simply compliment existing Data practices? What is your thought on it?
RB- One of your project in the data space is called Textual ETL... What is it about? Is it a theoretical concept? Are there any tool in the industry that meets the standard?
SB - Your recent publications are on Taxonomies, and Textual Analytics... Our knowledge on it is quite limited. Please enlighten us about the use case scenario for which it's relevant.
RB - How do we connect with you in Social media such as Twitter or Blog?
Music: http://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