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
Wait Statistics
From I/O Waits to Inside the Batch Window: Tuning SQL Server on Amazon RDS
A banking system runs a nightly end-of-day batch : interest accruals, balance u…
Read more
Replication
RF 3 vs RF 5 in CockroachDB: What Really Happens When a Node or Region Fails
Consider a CockroachDB stretch cluster across two clouds… Anyone designing a …
Read 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.