DBA Expert Insights
Articles and Analysis

Insights

Deep dives into Oracle database technology, cloud migrations, data architecture, and the evolving landscape of enterprise AI. Written by practitioners, for practitioners.

Oracle Database Appliance Handbook
New Book Coming May 2026

Oracle Database Appliance Handbook

The complete guide to the ODA X11. Architecture, deployment, patching, virtualization, cloud backup, and monitoring. By Charles Kim, Dean Elzey, and Mark Shore.

All Articles

ODA

Deploying a Windows Server 2022 Application KVM on an ODA

Step-by-step walkthrough of deploying Windows Server 2022 as an application VM on Oracle Database Appliance using KVM and ODACLI. Provisioning the VM, loading the Oracle VirtIO storage drivers that Windows Setup needs, and installing Windows Server through to the desktop with screenshots at every stage.

10 min read
Security

Deploying SQL Firewall into Production

Part 02 of a security series on Oracle AI Database 26ai. Catching SQL injection attempts, reviewing the violation log, refining the allow list as applications evolve, log maintenance, moving the firewall tables out of SYSTEM, excluding scheduler jobs, and bringing the firewall up and down cleanly.

6 min read
Security

SQL Firewall in Oracle AI Database 26ai

Hackers are using AI to attack databases. SQL Firewall protects your most valuable asset at the kernel level. Setup, workload capture, allow list enforcement, and violation analysis with code examples against a real 26ai schema.

12 min read
MCP

MCP for Database Administration

Part 04 of a series on wiring Oracle AI Database 26ai to Claude Code. Surveying the database, creating tablespaces, moving schemas online, auditing archive logs, and generating health check and RMAN backup scripts from a single English prompt.

5 min read
MCP

MCP for Data Architecture

Part 03 of a series on wiring Oracle AI Database 26ai to Claude Code. Extending a schema, documenting it, auditing the design through MCP, indexing the foreign keys it flags, and pulling the full ER diagram back in one prompt.

5 min read
MCP

MCP in Practice for Oracle Professionals

Part 02 of a series on wiring Oracle AI Database 26ai to Claude Code. Builds a consultant utilization report and dashboard entirely inside Claude Code with the SQLcl MCP server as the only thing touching the database.

7 min read
MCP

Leveraging MCP to Connect to Oracle AI Database 26ai

Part 01 of a series on wiring Oracle AI Database 26ai to Claude Code. Wallet-backed credentials, a project-scoped MCP server, and a first working query from a chat window.

6 min read

Want to learn more?

We share what we learn. Reach out to discuss any of these topics or explore how they apply to your environment.

Get in Touch →