The JusDB Database Engineering Blog

Migrate Oracle workloads to SQL Server — data type mapping, PL/SQL conversion, SSMA tooling, and validation strategies

Use SQL Server Query Store to catch bad execution plans, force stable plans, and automate query performance regression alerts

Configure SQL Server Always On AG — listener routing, synchronous vs asynchronous commit, failover policy, and monitoring

Compare Pinot, ClickHouse, and Druid for real-time analytics — ingestion latency, query patterns, and operational cost

Understand Apache Pinot internals — segment lifecycle, StarTree indexes, broker routing, and controller operations

Compare SeaTunnel, Debezium, and Apache Flink CDC — connector coverage, fault tolerance, latency, and operational complexity

Use Apache SeaTunnel for CDC and batch ingestion — Zeta engine, 100+ connectors, exactly-once semantics, and Kubernetes deployment

Tune Valkey for production — memory policies, AOF/RDB persistence, cluster rebalancing, and latency monitoring

Design schemas for LLM apps — conversation history, embedding metadata, prompt versioning, and feedback loops

Store model metrics, feature stores, and inference logs with TimescaleDB, InfluxDB, and QuestDB

Use Neo4j and graph databases for AI knowledge graphs — entity extraction, relationship storage, and RAG augmentation

Monitor pgvector query performance — index hit rates, slow similarity searches, HNSW vs IVFFlat trade-offs