Guide on connecting Oracle Database to Dremio Cloud for federated analytics without data movement, covering setup, optimization, and AI integration.
Compares how Oracle and PostgreSQL uniquely identify SQL queries and execution plans, focusing on SQL_ID vs query_id and PLAN_HASH_VALUE vs query_hash.
Compares PostgreSQL's pg_stat_wal metrics to Oracle's detailed redo logging instrumentation for database administrators.
A data professional shares her schedule and projects for PASS Data Community Summit, including keynotes, sessions, and a fun AI-powered PowerShell script.
A Java developer answers community questions about working on Oracle's Java Platform Group, the Inside Java Newscast, and team collaboration.
Compares PostgreSQL's tuple-based MVCC and append-only updates with Oracle's in-place row updates and undo-based MVCC for database concurrency.
Compares Oracle and PostgreSQL wait analysis for database performance tuning, focusing on wait classes vs. event types.
A guide for Oracle DBAs on PostgreSQL transaction control, locking mechanisms, and performance monitoring basics.
A technical comparison of PostgreSQL and Oracle physical storage, memory architecture, and processes for database administrators transitioning between the two systems.
Explains how to emulate SQL's FILTER clause for JSON aggregate functions in Oracle, addressing NULL value handling in JSON arrays and objects.
Explains Oracle-specific SQL techniques for retrieving the top 1 row per group, covering KEEP syntax, ANY_VALUE(), and object/JSON workarounds.
jOOQ 3.18.0 release adds enhanced SQL diagnostics, SQL/JSON support, Oracle/PostgreSQL array features, and R2DBC 1.0 integration.
Oracle 19c Docker containers timeout with JDBC driver versions 19.3.0.0+, causing a 'Got minus one from read call' error. The fix is to set oracle.net.disableOob=true.
A report on the virtual DOAG 2021 conference, covering talks about running WebLogic on Azure and the future of Jakarta EE.
Summary of the Jakarta EE community's turmoil over the javax package name and trademark issues after Oracle's transfer of Java EE.
Overview of methods and tools for streaming data changes from Oracle databases into Apache Kafka, including CDC options.
Author's 2017 speaking schedule for tech conferences and meetups, focusing on Apache Kafka and real-time data streaming.
Resolving a Kafka Connect JDBC error with Oracle due to case-sensitive table names in connector configuration.
Explores undocumented REST web services in OBIEE 12c for downloading RPD files, detailing commands and diagnostic methods.
Introducing NHInsights, a custom NHibernate driver for Oracle that integrates with Application Insights to track database query dependencies.
