Practical, production-ready guides on databases, cloud and automation – PostgreSQL, Oracle, SQL Server, MongoDB, CockroachDB, Kubernetes, Azure and AWS.
PostgreSQL
Master PostgreSQL Administration, Performance Tuning, Replication, Backup & Recovery, and High Availability.
Oracle Database
Oracle RAC, ASM, Data Guard, RMAN, Performance Tuning, Migration and Enterprise Database Administration.
SQL Server
SQL Server Performance Tuning, Query Store, Always On, Deadlocks, Indexing and Enterprise Administration.
MongoDB
MongoDB Replica Sets, Sharding, Atlas, Backup, Monitoring and Performance Optimization.
Recent posts
Show more
Performance
Priority Transactions in Oracle AI Database 26ai: When a Batch Blocks a Payment, Measured
Tested on: Oracle AI Database 26ai (23.26.4.1.0) on Oracle Autonomous AI Data…
Read more
Security
Blockchain Tables in Oracle AI Database 26ai: A Bank Ledger Even the DBA Cannot Change, Measured
Tested on: Oracle AI Database 26ai (23.26.4.1.0) on Oracle Autonomous AI Data…
Read more.png)
Oracle ACE
Semantic Search on Bank Support Tickets Inside Oracle AI Database 26ai: In-Database AI, Measured
Tested on: Oracle AI Database 26ai (23.26.4.1.0) on Oracle Autonomous AI Data…
Read more
Security
SQL Firewall in Oracle AI Database 26ai: Allow-Lists, Blocking and Overhead, Measured
Tested on: Oracle AI Database 26ai (23.26.4.1.0) on Oracle Autonomous AI Data…
Read more
Oracle ACE
JSON Duality Views in Oracle AI Database 26ai: Two Apps, One Account, No Lost Updates
Tested on: Oracle AI Database 26ai (23.26.3) on Oracle Autonomous AI Database…
Read more
Performance
AI Vector Search in Oracle AI Database 26ai From a DBA's Chair: Exact vs IVF vs HNSW, Measured
Tested on: Oracle AI Database 26ai (23.26.3) on Oracle Autonomous AI Database…
Read more
Performance
Lock-Free Reservations in Oracle AI Database 26ai: One Hot Account, 8 Sessions, Measured
Tested on: Oracle AI Database 26ai (23.26.3) on Oracle Autonomous AI Database |…
Read more
Performance
Slow Concurrent INSERTs in Oracle: Reverse Key Index vs Scalable Sequence, Measured on 19c
Tested on: Oracle Database 19c Enterprise Edition 19.27, 16 CPUs | Level: Inter…
Read more
- Tamilselvan Perumal
- I'm Tamilselvan Perumal, an Oracle ACE Apprentice and Senior DBA with 12+ years running Oracle, PostgreSQL, SQL Server, MongoDB and CockroachDB for Tier-1 global banks. On TechStarAdmin I share hands-on, production-tested guides on performance tuning, high availability, security and migrations.