Andrew Deally·Jun 23THE DYNASTY THAT NEVER WAS?My View on How the Mustache‑Wearing Oakland A’s Lost a 1970s decade long Empire — And the Dynasty That Should Have Followed
Andrew Deally·Apr 17Recovering from a Bad update in CockroachDB with AS OF SYSTEM TIMEOne of the most useful features in CockroachDB for operational recovery is AS OF SYSTEM TIME. If a bad write just happened and the old MVCC…
Andrew Deally·Jul 12, 2025Comparing Multi-Statement vs. Single-Statement Transactions for Account Transfers in SQLSingle-statement SQL consistently outperforms traditional step-by-step transactions…A response icon2A response icon2
Andrew Deally·Jun 13, 2025How to Limit the Number of Rows Read or Written per Transaction in CockroachDB — With Role-Based…CockroachDB has a powerful feature that lets you limit the number of rows read or written within a single transaction. This capability is…
Andrew Deally·May 1, 2023Reads During Network PartitionsCockroach introduced Follower reads in 2018 and Bounded staleness in 2020 which service reads from a local or follower replicas. A great…
Andrew Deally·Mar 20, 2023Tenant Isolation with CockroachDB: Part 2Tenant node Isolation through database partition and sharding
Andrew Deally·Jan 31, 2023Using AWR metrics for Workload ClassificationPart 1A response icon2A response icon2
Andrew Deally·Jan 19, 2023Tracing Application Interactions with CockroachDBPart 2 — Node CPU Profiles