Category Archives: Database

Database

Redis in Production Part 2: ElastiCache, MemoryDB, and the Self-Hosted Question

By | April 23, 2026

Prerequisites You should read Part 1: Redis in Production — Persistence, Replication, and HA first, or already understand RDB vs AOF, Redis Sentinel, and Redis Cluster mode. Basic AWS familiarity (VPCs, security groups, EC2 instance families) is expected. You don’t need prior hands-on experience with MemoryDB or ElastiCache Serverless. The Problem: “Just Use ElastiCache” Is… Read More »

Redis in Production: Architecture, Persistence, and High Availability

By | April 23, 2026

TL;DR: Redis is simple to start but tricky to run correctly at scale. This guide covers the production deployment decisions that matter: RDB vs AOF vs hybrid persistence, Sentinel vs Cluster topologies, memory eviction policies that won’t kill your app, and the self-hosted vs ElastiCache trade-off. Written for platform engineers who need Redis to stay… Read More »

Monolith database to Microservice database using expand contract pattern

By | March 25, 2023

Splitting a monolithic database into microservice databases using the Expand-Contract pattern involves breaking down the monolith into smaller, more focused databases that are better suited to the individual microservices they support. This can help to reduce coupling between services, improve scalability, and simplify maintenance and updates. The Expand-Contract pattern involves the following steps: Identify the… Read More »

SQL Server Password

By | October 9, 2015

Introduction How to reset SQL Server password. This post is all about helping users to unlock, or have a backdoor access to SQL Server database when they are locked out. The post will help in resetting SA password or adding a new user with SysAdmin privileges. You can always trim down user role later but this… Read More »