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
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 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.
