Let’s talk
INSIGHTS / KNOWLEDGE, SHARED

Ideas for
your next move.

Practical thinking for teams building software, securing systems and operating modern infrastructure. Explore our engineering field notes.

500 insights · Page 6 of 42

SQL Server AG Backups: Make Preference Drive Real Jobs — conceptual 3D-style vector showing Backup policy, Replica preference, Agent jobs, Backup artifacts, AG topology.ENGINEERING JOURNAL ↗
Database Operations

SQL Server AG Backups: Make Preference Drive Real Jobs

Review Always On backup placement through SQL Server version support, replica health, job logic, shared history, and recovery-artifact access.

Read field note ↗
SQL Server Log Growth: Follow the Reuse Wait Reason — conceptual 3D-style vector showing Transactions, Reuse wait, Log file, Reusable space, Backup or replica.ENGINEERING JOURNAL ↗
Database Operations

SQL Server Log Growth: Follow the Reuse Wait Reason

Investigate SQL Server transaction-log growth through occupied space, recovery model, and the reported reuse wait before considering file operations.

Read field note ↗
SQL Server tempdb: Identify Space and Wait Consumers — conceptual 3D-style vector showing Workload, tempdb consumers, Data files, Capacity review, Version storage.ENGINEERING JOURNAL ↗
Database Operations

SQL Server tempdb: Identify Space and Wait Consumers

Diagnose SQL Server tempdb pressure by separating user objects, internal work, version storage, and allocation waits before changing file layout.

Read field note ↗
Redis TLS: Verify Every Client and Replication Path — conceptual 3D-style vector showing Application, TLS listener, Redis node, Replica link, Trust bundle.ENGINEERING JOURNAL ↗
Database Operations

Redis TLS: Verify Every Client and Replication Path

Plan Redis TLS changes across application connections, replicas, Sentinel or Cluster links, certificate identity, and the runtime trust configuration.

Read field note ↗
Redis ACLs: Test Commands and Key Patterns Together — conceptual 3D-style vector showing Application user, Command rule, Key pattern, Allowed operation, Negative test.ENGINEERING JOURNAL ↗
Database Operations

Redis ACLs: Test Commands and Key Patterns Together

Review Redis ACL access through the actual command, key, channel, and selector rules, then test expected permissions without executing business writes.

Read field note ↗
Redis Latency: Separate Command Time from Client Delay — conceptual 3D-style vector showing Client timing, Server command, Slow log, Request result, Latency events.ENGINEERING JOURNAL ↗
Database Operations

Redis Latency: Separate Command Time from Client Delay

Investigate Redis latency with bounded slow-log samples, event monitoring, application timings, and host evidence that refer to the same interval.

Read field note ↗
Redis Cluster: Decode MOVED, ASK and CROSSSLOT Errors — conceptual 3D-style vector showing Cluster client, Slot map, Owning node, Key placement, Migration redirect.ENGINEERING JOURNAL ↗
Database Operations

Redis Cluster: Decode MOVED, ASK and CROSSSLOT Errors

Follow Redis Cluster errors through client slot routing, migration redirections, advertised endpoint reachability, and multi-key placement rules.

Read field note ↗
Redis Replication: Diagnose Backlog and Full Resyncs — conceptual 3D-style vector showing Primary stream, Replication backlog, Reconnect, Replica, History identity.ENGINEERING JOURNAL ↗
Database Operations

Redis Replication: Diagnose Backlog and Full Resyncs

Investigate repeated Redis full resynchronization by comparing replication history, offsets, disconnection patterns, and backlog capacity.

Read field note ↗
Redis Persistence: Test the AOF and RDB Recovery Contract — conceptual 3D-style vector showing Writes, Persistence policy, AOF files, Recovered state, RDB snapshot.ENGINEERING JOURNAL ↗
Database Operations

Redis Persistence: Test the AOF and RDB Recovery Contract

Choose Redis AOF and RDB behavior from the data-loss requirement, inspect persistence health, and test recovery from the complete saved artifact.

Read field note ↗
MongoDB Restore: Check Versions, Namespaces and Replay Scope — conceptual 3D-style vector showing Dump artifact, Compatibility, Restore target, Validation, Oplog scope.ENGINEERING JOURNAL ↗
Database Operations

MongoDB Restore: Check Versions, Namespaces and Replay Scope

Prepare a mongorestore run by matching tool and server compatibility, isolating the destination, and choosing namespace or oplog replay scope deliberately.

Read field note ↗
MongoDB Oplog Windows: Plan for Outage and Catch-Up — conceptual 3D-style vector showing Write activity, Oplog history, Disconnected member, Catch-up, Recovery choice.ENGINEERING JOURNAL ↗
Database Operations

MongoDB Oplog Windows: Plan for Outage and Catch-Up

Assess MongoDB oplog history using observed write activity, maintenance duration, and secondary catch-up time before assuming a fixed outage allowance.

Read field note ↗
MongoDB TTL: Separate Expiration from Deletion Timing — conceptual 3D-style vector showing Document date, TTL index, Background delete, Collection, Application validity.ENGINEERING JOURNAL ↗
Database Operations

MongoDB TTL: Separate Expiration from Deletion Timing

Investigate MongoDB TTL behavior through date types, index configuration, primary-side deletion, and background progress rather than exact-time assumptions.

Read field note ↗