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
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
VACUUM
PostgreSQL Bloat and VACUUM, Measured: Same 1 Million Rows, 4× the Size
A table with one million rows. We update every row three times. The row co…
Read more
- Tamilselvan Perumal
- Oracle ACE Apprentice 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.
