Brent Ozar announces his upcoming sessions at the SQLBits conference, covering SQL Server performance tuning, indexing strategies, and cloud evolution.
Explains a SQL Server edge case where automatic statistics updates don't always invalidate cached execution plans, focusing on system-created stats.
Argues that YCSB and TPC benchmarks are flawed because they use closed-loop models, and advocates for open-loop benchmarks to better simulate real-world cloud database workloads.
A technical analysis comparing PostgreSQL JSON storage options, compression methods (pglz vs. lz4), and performance optimizations.
Compares PostgreSQL's pg_stat_wal metrics to Oracle's detailed redo logging instrumentation for database administrators.
A technical deep dive into how pgcat, a Postgres connection pooler, works by multiplexing client connections to improve performance and resource usage.
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
A developer shares techniques to improve database performance for large BLOB data retrieval in C#/.NET, including compression and chunking requests.
Compares Oracle and PostgreSQL wait analysis for database performance tuning, focusing on wait classes vs. event types.
A guide to troubleshooting and improving performance in slow SQL Server applications using structured techniques.
PostgreSQL 18 will introduce parallel CREATE INDEX for GIN indexes, significantly speeding up index builds on large tables.
Explores using Complex Types in Entity Framework Core 8 to reduce database tables, simplify data models, and improve performance.
Explains how PostgreSQL BRIN indexes can degrade performance despite high correlation and introduces the multi-minmax feature as a solution.
A guide to implementing in-memory caching in .NET using IMemoryCache to improve application performance and reduce database calls.
Explores new bulk operation methods ExecuteDelete and ExecuteUpdate in Entity Framework 7 for improved database performance.
Explores efficient database strategies for fetching large view counts on social platforms, avoiding costly SELECT COUNT(*) operations.
Learn how to use OpenTelemetry to monitor, identify, and fix common database performance issues in a .NET application.
Explores the 'IKEA Effect' cognitive bias in software development, where excessive attachment to one's own code can hinder progress and better solutions.
Explains Azure SQL Data Warehouse's Result Set Caching feature, its benefits for data warehousing, and how to enable it.
Explores the availability and configuration of Columnstore Indexes across various Azure SQL Database tiers, including General Purpose, Serverless, and Hyperscale.
