Announcing a workshop on optimizing ETL processes for SQL Server and Azure SQL at the SQLBits 2019 conference.
A case study on using Elasticsearch as the primary data store for a large e-commerce platform's search ETL pipeline, replacing legacy Oracle systems.
A technical guide on fixing timestamp corruption in CSV data using pandas and uploading the corrected data to OmniSci using pymapd.
A technical guide on using R and PostgreSQL to load and manage large-scale Adobe Analytics Clickstream Data Feed into a relational database.
A tutorial on building data pipelines using Microsoft Azure Data Factory, covering ingestion, transformation, and orchestration.
A technical guide on loading detailed AWS billing data into a SQL Server data warehouse for advanced cost analysis.
Argues against using Oracle's automatic optimizer statistics collection in data warehouses, advocating for manual stats management as part of ETL processes.
SQL queries to analyze and identify performance bottlenecks in Oracle Data Integrator (ODI) batch jobs with many tasks.
Oracle's performance recommendations for OBIA 7.9.6, focusing on ETL improvements and hardware sizing.
A developer shares initial frustrations and technical details while upgrading Oracle BI Applications from version 7.9.5 to 7.9.6.
Explains Oracle Business Intelligence Applications (OBIA) and its relationship to OBIEE, addressing common confusion in the Oracle BI toolset.
A technical walkthrough of configuring and troubleshooting Mark Rittman's OBIEE repository for querying DAC metadata, including RPD modifications and connection issues.
