Articles
Notes from practice on database architecture, automation, AI and cybersecurity.
- Database architecture
Cutting month-end and Power BI refresh time with PostgreSQL partitioning and indexing
Speed up month-end jobs and Power BI refreshes on PostgreSQL: measure first, partition by period, index real predicates and refresh incrementally.
- Automation
Automating production log tracing and reporting with Python
Replace manual grep work in production support with Python: stream large logs, group errors by signature, correlate systems and publish a daily report.
- AI
Putting an AI agent in front of an enterprise database, safely
Connecting LLM agents to Oracle or PostgreSQL safely: read-only roles, curated views, allow-listed tools, query limits, audit trails and human approval.
- Cybersecurity
Database security that survives an audit: SOX controls, audit logging and least privilege
The database controls auditors test: access reviews, segregation of duties, audit logging, change management and DR drills for Oracle and PostgreSQL.