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
Security
An AI Agent With Tools, Not SQL: MySQL REST Service for a Bank Support Agent, Measured
Tested on: MySQL Enterprise Server 26.7.0, MySQL Router 26.7.0 with MySQL RES…
Read more
Security
Can Your AI Agent See the Card Number? MySQL Dynamic Data Masking for a Bank Support Agent, Measured
Tested on: MySQL Enterprise Server 26.7.0 (Commercial), Oracle Linux 9 on OCI…
Read more
Wait Statistics
Slow INSERTs on Azure SQL Hyperscale: Fixing PAGELATCH_EX Last-Page Contention with a 32-Bucket Key
The average INSERT took under 5 ms . The database had CPU to spare and the l…
Read more
Runbook
MongoDB Replica Set Deployment Runbook: 3 Nodes, Secured and Failover-Tested (MongoDB 8.0 on RHEL 9)
My first MongoDB replica set build worked, eventually. Along the way it re…
Read more
- Tamilselvan Perumal
- Oracle ACE Associate and Oracle Certified Professional (19c) with 12+ years as a Senior DBA running Oracle, PostgreSQL, SQL Server, MongoDB, CockroachDB and YugabyteDB for Tier-1 global banks. On TechStarAdmin I share production-tested guides on performance tuning, high availability, database security and migrations. Every script is tested before it is published.