Oracle Machine Learning: SQL-Native ML in the Database
What Oracle Machine Learning actually is, the three flavors (SQL, Python, R), where it's the right tool, and where it isn't.
Read post →
All posts
Oracle APEX, Database, OCI, SQL & PL/SQL, performance, and analytics — hands-on and reproducible.
All Oracle APEX Oracle Database Oracle Cloud Infrastructure SQL & PL/SQL Performance & Tuning Analytics & BI
Oracle APEX Page Designer: A Mental Model
How to think about Page Designer's panes, panels, and properties as a single coherent system — and the practical habits that make APEX development less frustrating.
Read post →
Understanding Oracle's Cost-Based Optimizer
How Oracle's CBO chooses execution plans, why it sometimes gets it wrong, and the practical levers — statistics, histograms, hints, baselines — for fixing bad plans.
Read post →
SQL Window Functions: The Patterns Worth Knowing in Oracle
The seven window-function patterns I actually use in production Oracle SQL — running totals, ranking, top-N-per-group, period comparisons, and more.
Read post →
Oracle Database Editions: Standard, Enterprise, and Express Explained
A practical guide to the four Oracle Database editions — what each gives you, when to pick which, and the common mistakes that cost real money.
Read post →
Oracle Integration Cloud: The Developer's View
What Oracle Integration Cloud (OIC) actually does, the patterns it handles well, and where it stops being the right tool.
Read post →
Oracle GoldenGate: When You Need It (and When You Don't)
A practical view of GoldenGate — what it does, where it earns its license, and the simpler alternatives that often do the job.
Read post →
Oracle Analytics Cloud: A Practical Look
What Oracle Analytics Cloud is good at, where it lags Power BI and Tableau, and the specific situations in which OAC is the right BI choice.
Read post →
Oracle Exadata: What Makes It Actually Fast
A practical look at the engineering behind Exadata — Smart Scan, Hybrid Columnar Compression, Smart Flash Cache, RDMA — and the workloads where it earns its price.
Read post →
Oracle Autonomous Database: When It's Worth It (and When It Isn't)
A developer-focused take on what Oracle Autonomous Database actually does, where it earns its price, and where you'll be paying for features you don't need.
Read post →
PL/SQL Patterns That Pay Off in Real Projects
Eight practical PL/SQL patterns that consistently make production code faster, safer, and easier to maintain — with examples.
Read post →
Oracle Database 23ai: What Actually Changed and What Matters
A developer-focused tour of Oracle Database 23ai — vector search, JSON-relational duality, the DX wins that matter, and what the version bump doesn't change.
Read post →
Oracle APEX in 2026: What It Actually Is (and What It Isn't)
A clear, opinionated take on what Oracle APEX really is, what it's good at, and the misconceptions that keep developers from giving it a fair look.
Read post →