Yet Another Blog About Oracle
SQL migrations are underestimated until they aren’t. A few dozen queries can usually be handled manually. A few thousand across multiple applications, written by multiple teams, targeting a database engine…
A practical harness for generating high-volume data, querying JSON, and comparing index strategies in Oracle. Modern applications increasingly store semi-structured data alongside relational data. One of the strengths of Oracle…
Modern developers take branching for granted. We branch code, test ideas safely, roll back mistakes, and merge changes deliberately. Git made this workflow so natural that it’s hard to imagine…
As database administrators, we’re constantly balancing feature enablement with resource management. Oracle’s Heat Map and Information Lifecycle Management (ILM) features provide powerful capabilities for automated data optimization, but like any…
Overview Apple recently announced a macOS specific container implementation and I wanted to explore it further. The exciting part is that Apple’s container system can run any Open Container Initiative…
Oracle Database includes a powerful feature called Heat Map, which tracks how segments are accessed and helps guide Information Lifecycle Management (ILM) decisions. This post walks through a practical SQL…
MongoDB is set to deprecate support for server-side JavaScript functions, a change already noted in the 8.0 compatibility release notes and community discussions. While not yet a migration blocker, this change is worth paying…
Overview This runbook describes how use the self-signed certificate Oracle REST Data Services (ORDS) generates for usage with the Oracle Database API for MongoDB. It enables TLS communication for development…
This document provides ‘quick-start’ instructions for installing and configuring Oracle REST Data Services (ORDS) to enable the Oracle Database API for MongoDB on an Oracle Database running on Oracle Exadata Cloud Service (ExaCS) or any supported…
When planning a database migration, understanding what needs to move is only half the battle. The real challenge often lies in understanding how much effort it will take to remediate…
I’m Matt and I do Oracle things.