A comprehensive reference of 100 practical T-SQL commands for SQL Server 2016-2022 DBAs, organized into ten categories covering instance basics, space management, session analysis, locking, performance tuning, indexes, Always On, backup/recovery, permissions, and daily health checks.
StarRocks adopts Apache Paimon's C++ implementation (paimon-cpp) to replace JNI calls for primary-key merges and delete-vector handling, cutting cross-language overhead and reusing StarRocks' cache, memory management, and Query Profile; benchmarks show 1.4–3.4× speedups on primary-key counts and wide-table aggregations.
This article provides a practical decision framework for choosing between Apache Doris and StarRocks for real-time OLAP workloads, comparing their architectural origins, licensing, optimal use cases, and guiding teams through self-hosted versus managed deployment decisions based on organizational capacity and query profiles.
Booking.com benchmarked OpenSearch and Weaviate with 100M embeddings across pure KNN, filtered search, and mixed read/write workloads, finding Weaviate's integrated storage-engine design delivered stable low latency at high concurrency and writes, cutting compute costs by 40%.
The article explains why OFFSET/LIMIT pagination causes full table scans and linear performance degradation with large offsets, demonstrates a 100k-row benchmark where cursor-based pagination using primary keys runs in 0.01s versus 12.80s for OFFSET, and recommends keyset pagination for scalable systems while noting limitations for tables without unique sequential columns.
Helix Foundry connects Postgres, Stripe, WorkOS, and PostHog into a unified ontology graph on your laptop, runs analytical queries via DuckDB, and answers questions with a local LLM — all without accounts, deployment, or cloud dependencies.
The article analyzes why Elasticsearch underperforms on Chinese ARM-based CPUs — citing weak single-core performance, complex NUMA topologies, JDK selection pitfalls, version compatibility gaps, and unfair benchmarking — and evaluates Easysearch as a supported alternative with vendor-backed compatibility across major domestic chips and OSes.
MySQL 9.0 introduces a native VECTOR data type for storing embeddings, while MySQL AI (enterprise) and HeatWave GenAI (cloud) add in-database semantic search, RAG with citations, and AutoML for classification—all accessible via SQL, enabling AI workloads without moving data out of the database.
This article explains how database indexes accelerate queries by leveraging sorted data structures and binary search, detailing disk I/O mechanics, clustered vs. non-clustered indexes, index trade-offs on write performance, and common SQL optimization pitfalls like OR conditions and leading wildcards that cause index invalidation.
This article explains MySQL full-text search using inverted indexes as an alternative to LIKE % queries, covering index creation, natural language, boolean, and query expansion modes with syntax examples and performance considerations.
This article explains Lance's Stable Row ID feature, which assigns persistent logical identifiers to rows so they survive compaction and updates, reducing index maintenance costs at the expense of extra mapping storage and lookup overhead.
A MongoDB Community Champion reports from MongoDB.local NYC, analyzing how the sudden CEO change contrasts with the cohesive launch of MongoDB 9.0, Atlas Infinite, and Atlas Agent Engine as a unified AI data platform strategy.
PostgreSQL 18.6 introduces async I/O with io_uring support, skip scan for composite indexes, time-ordered UUIDv7, virtual generated columns, OAuth authentication, RETURNING old/new values, and critical security fixes for logical decoding and pgcrypto.
A step-by-step MySQL query optimization case study showing how indexing, join rewriting, composite indexes, and covering indexes reduced execution time from 30,248 seconds to 0.001 seconds with execution plan analysis.
The article explains why unified equipment codes still cause report errors due to missing temporal equipment-workstation relationships, and outlines a three-layer diagnostic (identity alignment, historical relationships, query semantics) advocating reuse of existing master data and history tables, complemented by ontology for shared semantics, with regression testing to verify fixes.
This article compares five major Chinese domestic databases across three technical generations—traditional centralized (Dameng, Kingbase), open-source modified (openGauss), and self-developed distributed (OceanBase, TiDB)—detailing their kernel origins, compatibility targets, strengths, weaknesses, and a decision framework based on compliance requirements, existing workload, scale, and operational readiness.
This article provides a comprehensive visual guide to Redis architecture, covering single-instance deployment, high-availability setups with Sentinel, Redis Cluster sharding with hash slots, replication mechanics using replication IDs and offsets, and persistence models including RDB snapshots, AOF logging, and the fork/copy-on-write mechanism.
This comprehensive guide lists 100 essential Dameng DM8 database administration commands covering instance management, user permissions, tablespace operations, performance tuning, backup/recovery, logical import/export, and high-availability monitoring for daily DBA operations and troubleshooting.
MySQL 9.7 LTS introduces writable JSON Duality Views and the Hypergraph optimizer in the community edition, enhances replication observability and high‑availability automation, adds audit log rotation and stronger password hashing, but warns that the new optimizer requires regression testing due to mixed performance impact.
This article details seven common pitfalls in Redis distributed locking, covering atomic acquisition, ownership verification, lease expiration, watchdog limitations, replication risks, Redlock assumptions, and the need for fencing tokens, with code examples and comparisons to ZooKeeper and etcd.
