Explores common concurrency challenges in software development, using a URL shortener example to demonstrate solutions with minimal locking.
Explores various data fetching methods in jOOQ, including iterable, single-record, and resourceful fetching techniques.
A former Heroku PM shares the story and vision behind Heroku Postgres, reflecting on its development and future possibilities.
A beginner-friendly 2022 introduction to SQL, covering its basics, use cases, and hands-on practice with SQLite3.
Benchmark comparison of SQLite in Go using the cgo-based mattn/go-sqlite3 package versus the pure-Go modernc.org/sqlite translation.
Explores whether setting JDBC Statement.setFetchSize(1) for single-row queries improves performance, with benchmark results across databases.
Explains how to use SQL's NATURAL FULL JOIN to concatenate data from unrelated tables, like actor, customer, and staff, into a single result set.
A guide to quickly install ClickHouse on macOS using a one-line shell command and demonstrates its use for converting CSV data to Parquet.
Explains performance issues with OFFSET in database pagination and introduces keyset pagination as a more efficient alternative.
Explains jOOQ's API for managing nested transactions, comparing it to JDBC defaults and Spring's @Transactional behavior.
A technical guide on using the jOOQ library to fetch and generate sequence values from various SQL databases.
Author previews their upcoming SQL Managed Instance presentations at the SQLBits 2022 conference, highlighting new features and demos.
A tutorial on using the $group stage in MongoDB's aggregation pipeline, covering distinct grouping, multiple fields, and accumulator functions with practical examples.
A Microsoft engineer reviews their 2021 professional year, highlighting blogging and presentations on Azure SQL Managed Instance and tech conferences.
A guide to using the $project stage in MongoDB's aggregation pipeline, covering field inclusion, exclusion, and array operations.
Microsoft PM announces a series of public presentations on Azure SQL Managed Instance, covering new features, HA/DR, performance, and monitoring.
An appreciation of PostgreSQL's power, reliability, comprehensive documentation, and disciplined engineering team after 25+ years of development.
Diagnosing and fixing Azure App Service backup failures due to a 10GB size limit, with a solution to exclude the database.
A deep dive into DynamoDB partitions, explaining their role in data modeling and performance for the NoSQL database.
Announcing the free release of 'Practical MongoDB Aggregations', a book with tips and examples for developers and data professionals.
