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
- How Intelligent is the SQL Analysis Report in Oracle 23c?
UKOUG:23 Conference, Reading, 15 November 2023
POUG 2023 Conference, Warsaw, 17 November 2023
DOAG Konferenz 2023, Nuremberg, 21 November 2023 - Make Your Oracle Data Warehouse Fast: Comparing Performance Features
ODTUG Kscope23 Conference, Aurora/Colorado, 27 June 2023
HrOUG Annual Conference 2023, Rovinj/Croatia, 18 October 2023
UKOUG:23 Conference, Reading/United Kingdom, 15 November 2023 - One Goal – Different Approaches: Performance Tuning in Practice
(presentation together with Martin Berger)
POUG 2022 Conference, Wroclaw, 10 September 2022
DOAG Konferenz 2022, Nuremberg, 21 September 2022
Trivadis Performance Days 2022, Zurich, 28 September 2022 - 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
ConTech by RoOUG 2022, Bucharest, 6 October 2022
UKOUG Breakthrough’22, Birmingham, 1 December 2022
IT-Tage 2022 (online), 14 December 2022
ODTUG Kscope23 Conference, Aurora/Colorado, 26 June 2023
HrOUG Annual Conference 2023, Rovinj/Croatia, 19 October 2023 - BrewTracker: Behind the Scenes of a Brewery App
(presentation together with Andrea Kennel)
ODTUG Kscope22 Conference, Grapevine/Texas, 22 June 2022
ConTech by RoOUG 2022, Bucharest, 7 October 2022 - To Laugh or to Cry? Code Review of a PL/SQL Procedure
APEX connect [online] 2021, 5 May 2021
POUG 2021 Conference, Warsaw, 11 September 2021
ODTUG Kscope22 Conference, Grapevine/Texas, 22 June 2022 - Autonomous, Automatic, Adaptive: Are we running out of work?
Trivadis Performance Days 2021 (online), 28 October 2021
DOAG Konferenz 2021 (online), 18 November 2021
UKOUG Breakthrough’22, Birmingham, 2 December 2022
IT-Tage 2022 (online), 14 December 2022
ODTUG Kscope23 Conference, Aurora/Colorado, 27 June 2023 - 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 2018, 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
- Nach den Sternen greifen – Herausforderungen im Star Schema
DDVUG Herbsttagung, Basel, 9 November 2023
DOAG Konferenz 2023, Nürnberg, 23 November 2023 - Constraints: Der praktische Werkzeugkasten
APEX connect 2023, Berlin, 4 May 2023 - Technisch muss nicht trocken sein – Leitfaden für kurzweilige Präsentationen
DOAG Konferenz 2022, Nürnberg, 21 September 2022
SOUG Day 2023, Winterthur, 4 April 2023
Meetup SOUG Regio Bodensee, St. Gallen, 31 October 2023 - DWH-Performancemassnahmen im Vergleich
DOAG Konferenz 2021 (online), 16 November 2021 - 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 