This is Part 1 of a series on madsql, a deterministic CLI tool for SQL dialect migration. The series covers split-statements, infer-schema, and convert in the order you’d reach for them on a real migration project. The instinct on a…
Hidden in plain sight inside Oracle Database is an often-unused, sometimes-undiscovered feature: Cross-PDB Query. With Oracle Multitenant, the CONTAINERS clause allows a properly configured common user to query data across multiple Pluggable Databases from the Container Database root. That can…
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 with different quoting rules, pagination syntax, and type semantics, that’s…
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 Database 26ai is the ability to natively store JSON in…
Why modern product organizations, from Chief Product Officers to Product Managers and Software Development Managers, must rethink decision velocity, governance, and strategic optionality. Modern product organizations are operating under unprecedented pressure. Markets expect continuous innovation. Customers expect rapid feature delivery.…
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 software development without it. What’s far less common, but arguably…
Exporting data from Oracle databases is a common task that every DBA and developer faces. Whether you’re migrating data, creating backups, or generating reports, having the right export strategy can save you time and headaches. In this post, I’ll walk…
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 monitoring feature, they consume storage space. The question every DBA…
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 (OCI) image directly on Apple Silicon Macs. Announced at WWDC…
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 script I use to enable Heat Map, capture access data,…