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.
Oracle Notebook
Practical notes on Oracle — APEX, Database, OCI, SQL & PL/SQL.
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.
A tour of the five OCI AI Services — Language, Vision, Speech, Document Understanding, Forecasting — and the situations in which each is the right tool.
Oracle's managed-LLM offering on OCI — the models available, how it compares to Azure OpenAI and AWS Bedrock, and the RAG pattern that ties it to Oracle Database vector search.
What Oracle Select AI actually is, how to set it up, the four actions you can run, and the honest limitations for production use.
What Oracle Machine Learning actually is, the three flavors (SQL, Python, R), where it's the right tool, and where it isn't.
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.
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.
The seven window-function patterns I actually use in production Oracle SQL — running totals, ranking, top-N-per-group, period comparisons, and more.
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.
What Oracle Integration Cloud (OIC) actually does, the patterns it handles well, and where it stops being the right tool.
A practical view of GoldenGate — what it does, where it earns its license, and the simpler alternatives that often do the job.
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.
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.
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.
Eight practical PL/SQL patterns that consistently make production code faster, safer, and easier to maintain — with examples.
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.