Videos
- “Make it Faster”: Myths about SQL Performance (47:24)
APEX connect [online] 2020, 5 May 2020 - Query Rewrite: The Supreme League of Materialized Views (1:08:21)
ACEs@home Virtual Conference ITOUG, 1 April 2020 - Avoid “Horror Queries”: Keep Your SQL Simple and Fast (1:00:37)
AskTOM Office Hours, 19 March 2020 - Oracle Developers 2 Minute Tech Tip: Keep Your SQL Statements Simple But Fast! (1:34)
- How to Create a Data Vault Model (6:04)
English Presentations
- Function Calls in SQL – Black Box for the Optimizer?
APEX connect 2022, Phantasialand Brühl, 4 May 2022
AIOUG Virtual Online Series, 25 May 2022 - Autonomous, Automatic, Adaptive: Are we running out of work?
Trivadis Performance Days 2021 (online), 28 October 2020
DOAG Konferenz 2021 (online), 18 November 2021 - Generic Data Models: Unlimited Flexibility?
ODTUG Kscope21 Virtual Conference, 25 June 2021 - Craft Beer in the Cloud: A Data Warehouse Case Study
(presentation together with Andrea Kennel)
ODTUG Analytics Webinar, 30 July 2020 - 007 Myths about SQL Performance
APEX connect [online] 2020, 5 May 2020
Oracle Groundbreakers EMEA Virtual Tour, 9 October 2020
AIOUG Webinar Series, 28 April 2021
ODTUG Kscope21 Virtual Conference, 1 July 2021
Oracle Groundbreakers EMEA Virtual Tour, 19 October 2021
UKOUG Together 2021, London (virtual), 29 November 2021
IT-Tage 2021 (online), 7 December 2021 - Query Rewrite: The Supreme League of Materialized Views
ACEs@home Virtual Conference ITOUG, 1 April 2020
Trivadis Performance Days 2020 (online), 28 October 2020
UKOUG Conference 2020 (online), 8 December 2020
AIOUG Webinar Series, 16 June 2021 - The Night is Too Short: 10 Tips to Improve ETL Performance
UKOUG Techfest19, Brighton, 4 December 2019 - Avoid “Horror Queries”: Keep Your SQL Simple and Fast
BGOUG Spring Conference, Borovets, 7 June 2019
ODTUG Kscope19 Conference, Seattle, 24 June 2019
POUG 2019 Conference, Wroclaw, 6 September 2019
Trivadis Performance Days 2019, Zurich, 26 September 2019
UKOUG Techfest19, Brighton, 4 December 2019
ITOUG TechDays 2020, Milan, 29 January 2020
ITOUG TechDays 2020, Rome 31 January 2020
AskTOM Office Hours, 19 March 2020
AIOUG Oracle Groundbreakers Yatra 2020, 9 July 2020 - How Autonomous is the Oracle Data Warehouse?
(presentation together with Christian Antognini)
SOUG Day, Baden-Dättwil, 18 September 2018
Trivadis Performance Days, Zurich, 20 September 2018
DOAG Konferenz 2018, Nuremberg, 20 November 2018
UKOUG Tech18 Conference, Liverpool, 3 December 2018
ODTUG Kscope19 Conference, Seattle, 26 June 2019 - Incremental Statistics: From a Nightmare to a Fast Solution
SOUG Day, Baden-Dättwil, 18 April 2018
POUG 2018 Conference, Sopot, 7 September 2018
AOUG Anwenderkonferenz 2019, Vienna, 15 May 2019
BGOUG Spring Conference, Borovets, 8 June 2019
ITOUG TechDays 2020, Rome 31 January 2020 - Pitfalls & Surprises with DBMS_STATS: How to Solve Them
DOAG Datenbank, 2018, Düsseldorf, 14 May 2018
ODTUG Kscope18 Conference, Orlando, 13 June 2018
UKOUG Tech18 Conference, Liverpool, 5 December 2018
IT-Tage 2018, Frankfurt, 11 December 2018 - Oracle Database In-Memory & Data Warehouse: The Perfect Combination?
UKOUG Tech17 Conference, Birmingham, 6 December 2017 - Data Vault Partitioning Strategies
DOAG Conference 2017, Nuremberg, 23 November 2017 - Analytic Views: Use Cases in Data Warehouse
DOAG Conference 2017, Nuremberg, 21 November 2017 - Data Warehousing and Bitmap Indexes – More Than Just Some Bits…
Oracle Open World 2011, San Francisco, 2 October 2011 - Partitioning Your Oracle Data Warehouse – Just a Simple Task?
Oracle Open World 2009, San Francisco, 15 October 2009
German Presentations
- DWH-Performancemassnahmen im Vergleich
DOAG Konferenz 2021 (online), 16 November 2020 - Multi-Version Load: Laden von historischen Daten in Data Vault
(presentation together with Daniel Zimmermann)
DDVUG Herbsttagung, Nürnberg, 30 September 2021 - Interessante SQL-Erweiterungen in Oracle 20c
DOAG Konferenz 2020 (online), 18 November 2020 - Homeoffice: Temporäre Notlösung oder Chance für die Zukunft?
DOAG Konferenz 2020 (online), 17 November 2020 - Generische Datenmodelle: Grenzenlose Flexibilität?
DOAG Konferenz 2019, Nürnberg, 21 November 2019 - Query Rewrite: Die Königsdisziplin von Materialized Views
DOAG Konferenz 2019, Nürnberg, 20 November 2019 - Vom Data Vault in Star Schema: Rezepte für Ladekonzepte
(presentation together with Andrea Kennel)
DOAG Konferenz 2019, Nürnberg, 20 November 2019
TDWI Roundtable Basel, 25 August 2020
Data Modeling Meetup Munich, 24 November 2020 - Die Nacht ist zu kurz: 10 ETL Performance Tipps
DOAG Konferenz 2018, Nürnberg, 21 November 2018
SOUG Day 2020 (online), 29 October 2020
IT-Tage 2020 (online), 8 December 2020 - Elegant und effizient: Stilstudien in SQL
DOAG Konferenz 2018, Nürnberg, 21 November 2018
SOUG Day, Olten, 22 May 2019
DOAG Regio, Stuttgart, 17 October 2019
IT-Tage 2019, Frankfurt, 11 December 2019 - Datenmodellierung mit Data Vault: Herausforderungen in der Praxis
TDWI Schweiz 2018, Zürich, 6 November 2018 - Partitionierungsstrategien in Data Vault
DOAG Konferenz 2017, Nürnberg, 23 November 2017 - Analytic Views: Einsatzgebiete im Data Warehouse
DOAG Konferenz 2017, Nürnberg, 21 November 2017 - Optimale Performance durch Constraints im Data Warehouse
DOAG Konferenz 2016, Nürnberg, 17 November 2016 - Oracle In-Memory & Data Warehouse: Die perfekte Kombination?
DOAG Konferenz 2016, Nürnberg, 16 November 2016 - Laden von Data Marts – auch mal komplex
DOAG BI 2016, Bonn, 9 June 2016 - Nützliche Oracle 12c Features für Data Warehousing
DOAG BI 2016, Bonn, 8 June 2016 - Effiziente Abfragen im Star Schema mit der Oracle 12c In-Memory Option
Oracle DWH Konferenz 2016, Mainz, 16 March 2016 - Modellierung agiler Data Warehouses mit Data Vault
DOAG Konferenz 2015, Nürnberg, 19 November 2015 - Das Ende von OWB – was nun? Migrationspfade für OWB-Projekte
DOAG Konferenz 2015, Nürnberg, 17 November 2015 - Oracle Data Warehouse Integration Builder – Ein Selbstversuch
DOAG Konferenz 2013, Nürnberg, 21 November 2013 - Wie modelliere ich mein Core DWH?
DOAG Konferenz 2013, Nürnberg, 19 November 2013 - Wie sicher sind Database Links?
DOAG BI Konferenz 2013, München, 17 April 2013 - Partitionierung im DWH: Erkenntnisse aus der Praxis
Oracle DWH Konferenz, Kassel, 19 March 2013 - Haben Sie die Zeit im Griff? Designtipps zur Zeitdimension
DOAG Konferenz 2012, Nürnberg, 22 November 2012 - Brücken bauen im dimensionalen Modell
DOAG Konferenz 2012, Nürnberg, 22 November 2012 - Fehlertolerante Ladeprozesse in Oracle gegen schlaflose Nächte
DOAG BI Konferenz 2012, München, 18 April 2012 - Indexierungsstrategie im Data Warehouse – Zwischen Albtraum und optimaler Performance
DOAG Konferenz 2011, Nürnberg, 15 November 2011 - Performanceaspekte im Oracle Data Warehouse
Oracle DWH Konferenz 2011, Mainz, 30 March 2011 - Die generierte Zeitmaschine – Historisierung auf Knopfdruck
DOAG Konferenz 2010, Nürnberg, 17 November 2010 - Analytische Funktionen – erfolgreich eingesetzt
DOAG Konferenz 2004, Mannheim, 10 November 2004
Data Warehousing with Oracle 