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 talk on leveraging PostgreSQL's advanced features within Django web framework for more powerful database-driven applications.
A technical guide on using the jOOQ library to fetch and generate sequence values from various SQL databases.
A talk summary on leveraging PostgreSQL's advanced features within Django projects, presented at PyCon Sri Lanka 2022.
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.
A talk on leveraging PostgreSQL's advanced features within Django projects, presented at Pyjamas Conf 2021.
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.
A talk on leveraging PostgreSQL's advanced features within Django projects, presented at EuroPython 2021.
A talk from DjangoCon Europe 2021 on leveraging PostgreSQL's advanced features within Django projects for enhanced database capabilities.
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.
A guide to using SQL for efficient data analysis, comparing performance with pandas and demonstrating advanced SQL techniques.
