Most enterprises that run an application for many customers, stores, or business units end up in the same spot: one PDB per tenant, and a growing tax every time the application changes. Patches multiply. Reference data drifts. Cross-tenant reporting becomes…
Building a Practical Database Migration Delivery Framework Database modernization programs rarely fail because of technology alone. They fail because organizations underestimate the operational coordination required to successfully execute migrations across infrastructure teams, application owners, database administrators, developers, project managers, security…
Database migrations are among the most complex initiatives organizations undertake. They involve multiple teams, multiple technologies, competing priorities, operational risk, testing requirements, governance processes, and business-critical applications. Yet despite the complexity, one of the biggest challenges I repeatedly encounter during…
This is Part 2 of a series on madsql. Part 1 covered split-statements. This post covers infer-schema, recovering CREATE TABLE DDL from a SQL workload when your source schema is incomplete or missing. One of the most common situations on…
Planning, Preparation, Execution, and Validation In my previous blog post, “The Migration, Optimization, and Innovation Journey”, I discussed how modernization is not simply about moving workloads from one database platform to another. Modernization is a broader operational and strategic transformation…
Technology modernization is often viewed as a single event: Migrate the workload.Move the data.Cut over the application.Declare success. In reality, successful modernization initiatives are rarely that simple. Over the years, I’ve found that the organizations achieving the best long-term outcomes…
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…