Announcing two free online tech sessions: building a low-cost data warehouse with Azure and a beginner's guide to database indexing.
An introductory guide to data engineering, explaining its role, key concepts, and how it differs from data science in the modern data ecosystem.
Explains how Apache Iceberg brings ACID transaction guarantees to data lakes, enabling reliable data operations on open storage.
Explains the evolution from ETL to ELT in data engineering, clarifying the role of modern tools like dbt in the transformation process.
A curated list of essential resources for data engineering, including articles, newsletters, podcasts, and tools.
A guide explaining key data engineering terms like data warehouses, data lakes, data mesh, and data pipelines, with definitions and comparisons.
Explains Azure SQL Data Warehouse's Result Set Caching feature, its benefits for data warehousing, and how to enable it.
RSiteCatalyst 1.4.10 adds QueueDatawarehouse, new Get* methods, and bug fixes for the Adobe Analytics R package.
A technical guide on loading detailed AWS billing data into a SQL Server data warehouse for advanced cost analysis.
Analysis of HP's marketing claims against Oracle Exadata, focusing on technical FUD and balanced system design for data warehousing.
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.
Explains Oracle Business Intelligence Applications (OBIA) and its relationship to OBIEE, addressing common confusion in the Oracle BI toolset.
