Drill to Detail Ep.31 'Dremel, Druid and Data Modeling on Google BigQuery' With Special Guest Dan McClary

Mark is joined by returning special guest Dan McClary to talk about data modeling and database design on distributed query engines such as Google BigQuery, the underlying Dremel technology and columnar storage format that enables this cloud distributed data warehouse-as-a-service platform to scale to petabyte-size tables spanning tens of thousands of servers, and techniques to optimize BigQuery table joins using nested fields, table partitioning and denormalization.

• Dremel: Interactive Analysis of Web-Scale Datasets
• BigQuery under the hood
• Inside Capacitor, BigQuery’s next-generation columnar storage format
• Drill To Detail Ep.2. 'Future Of SQL On Hadoop', With Special Guest Dan McClary
• Google BigQuery, Large Table Joins and How Nested, Repeated Values and the Capacitor Storage Format (and Looker) Saves the Day

Drill to Detail Ep.30 "AI, ML & Oracle's Adaptive Intelligence Applications" with Special Guest Jack Berkowitz

Oracle's Jack Berkowitz joins Mark Rittman to talk about a new category of continuously adapting, self-learning applications being built-out by Oracle that use machine learning together with enterprise and third-party data to create a new generation of intelligent HR, CX, SCM and ERP SaaS apps.

• "Adaptive Intelligence: What You Need to Know"
• Oracle's Adaptive Intelligence Apps product homepage

Drill to Detail Ep.29 'New-World BI Development using BigQuery, Looker, Kakfa and Streamsets' With Special Guest Stewart Bryson

Stewart Bryson returns to the show to join Mark Rittman to discuss new-world BI and data warehousing development using Google BigQuery and Amazon Athena, Apache Kafka and StreamSets, and talks about his experiences with Looker, the cloud-native BI tool that brings semantic modeling and modern development practices to the world of business intelligence.

Drill to Detail Ep.27 'Apache Kafka, Streaming Data Integration and Schema Registry' with Special Guest Gwen Shapira

Mark Rittman is joined by Gwen Shapira from Confluent to talk about Apache Kafka, streaming data integration and how it differs from batch-based, GUI-developed ETL development, the problem with architects, exactly-once processing and how data governance is coming to Kafka development with Confluent's new schema registry server.

Drill to Detail Ep.24 'Tom Sawyer Software, Graph + Spatial Analytics .... and why a Tweet goes Viral' With Special Guest Kevin Madden

Mark Rittman is joined by Kevin Madden and Josh Feingold to talk about graph + spatial analytics, Tom Sawyer Software ... and why a tweet about a certain WiFi kettle incident went viral last October.

• Visualizing When a Tweet Goes Viral
• How a Tweet Went Viral - BIWA Summit 2017
• English man spends 11 hours trying to make cup of tea with Wi-Fi kettle (The Guardian)
• The iKettle, the Eleven-Hour Struggle to Make a Cup of Tea, and Why It Was All About Data, Analytics and Connecting Things Together
• Tom Sawyer Software Perspectives

Drill to Detail Ep.22 'SnapLogic's Enterprise Integration Cloud' With Special Guest Craig Stewart

Mark Rittman is joined by Craig Stewart to talk about application and data integration, ODI and Sunopsis, SnapLogic's approach to hybrid on-premise/cloud integration and the rise of data preparation and dataflow-based cloud integration tools.

Drill to Detail Ep.21 'The Fall, and Rise, of Microsoft BI' With Special Guest Chris Webb

Mark Rittman is joined by Independent Consultant Chris Webb to talk about MDX & DAX, MSAS and SQL SQL Server and the fall ... and rise, of Microsoft BI

Drill to Detail Ep.20 'MapR Platform Differentation, Scaling Hadoop and Microservices' With Special Guest Tugdall Grall

Mark Rittman is joined in this episode by MapR's Tugdall Grall to talk about MapR's platform differentation and relationship with open-source Hadoop, scaling and streaming, microservices, and MapR's platform strategy around big data workloads in the cloud.

Drill to Detail Ep.19 'Elasticsearch, Elastic Stack & Elastic Cloud' With Special Guest Mark Walkom

Mark Rittman is joined by Elastic's Mark Walkom to talk about Elasticsearch, Kibana, Logstash and the Elastic Stack; business models built-around an open-source software core; and their move into cloud services with Elastic Cloud

Drill to Detail Ep.18 'Oracle's Cloud Analytics and Data Visualization Strategy' With Special Guest Vasu Murthy

Mark Rittman is joined by Vasu Murthy, Oracle's Senior Director for Product Management of Oracle Business Analytics to talk about what's new with OBIEE and Oracle Data Visualization and the recently released Oracle Analytics Cloud, a dive into the technical architecture of these new additions to Oracle's BI platform, and Oracle's vision for hybrid on-prem/cloud analytics.