Optimizing a slow CockroachDB query listing users with SELECT DISTINCT, investigating performance issues.
Investigating and fixing a slow CockroachDB pagination query that reads millions of rows but only returns 100.
A technical deep dive into optimizing a slow SQL logout query in CockroachDB, reducing retries and improving performance.
Optimizing a slow password reset query in CockroachDB, reducing row reads from 700k to 10.
A developer shares how AI tools helped reverse-engineer and optimize a slow API endpoint, moving from a complex transaction script to a domain model.
Explores the 'IKEA Effect' cognitive bias in software development, where excessive attachment to one's own code can hinder progress and better solutions.
Explores the availability and configuration of Columnstore Indexes across various Azure SQL Database tiers, including General Purpose, Serverless, and Hyperscale.
A guide for developers on common database mistakes beginners make, including storing images, using limit/offset for pagination, and relying on integer primary keys.
Explores issues with DBMS_STATS.COPY_TABLE_STATS in Oracle, focusing on incorrect high/low value propagation for partitioned table statistics.
