A former Application DBA shares advanced SQL and database optimization techniques for developers, focusing on performance and efficiency.
Explains why LINQ Join is faster than nested loops or Select for merging data in C#, focusing on performance with large datasets.
Tips for using Google BigQuery's public datasets while managing and minimizing query costs, including using the free tier and setting budgets.
A guide to common SQL mistakes and optimization opportunities for developers and data professionals, covering integer division, UNION vs UNION ALL, and query performance.
A technical deep-dive into diagnosing and solving severe performance issues caused by an 'Export to Excel' feature in a Django system.
A detailed overview of the new Database Scoped Configuration options introduced for SQL Server and Azure SQL Database in 2018, leading into 2019.
A technical deep dive into solving PostgreSQL disk space issues by optimizing a deduplication query, focusing on reducing sort key size.
Explores limitations of Batch Execution Mode on Rowstore Indexes in SQL Server, including heuristics and missing operators.
Explores the heuristics and conditions under which SQL Server's Query Optimizer decides to use Batch Mode execution for query processing.
Explores SQL Server 2019's new Batch Execution Mode for Rowstore indexes, covering basics, enabling it, and analyzing performance.
Explains a performance pitfall with Common Table Expressions (CTEs) in PostgreSQL versions 11 and earlier, showing how they can disable query optimization.
A preview of the top talks at PostgresOpen 2018, covering topics like debugging the Postgres planner, indexes, extensions, and connection pooling.
A technical talk on optimizing Elasticsearch query performance using caching strategies, presented at an Elastic User Group meetup.
Practical tips for optimizing Django database interactions, covering aggregation filters, namedtuples, and custom functions.
Analyzing and solving a performance issue in Django Admin's date hierarchy filter with large datasets and PostgreSQL.
A guide to using the new 'Compare ShowPlan' feature in SQL Server Management Studio 2017 to analyze and contrast SQL execution plans.
Explores the various uses of the DISTINCT keyword in PostgreSQL, including DISTINCT ON, with practical SQL examples.
Explores optimizing Django ORM queries to avoid the N+1 problem when dealing with Postgres joins and complex model relationships in APIs.
A guide to effectively testing Java repository layers, focusing on database setup, using H2 and PostgreSQL, and ensuring production-like environments.
Tips and best practices for writing clean, readable, and maintainable SQL code, including formatting, CTEs, and commenting.
