Explores SQL Server 2016's In-Memory OLTP enhancements, including new constraints, encryption, and operational analytics capabilities.
Technical guide on optimizing Drupal performance by managing database indexes, queries, and removing unused modules.
Introduction to Drupal performance tuning, focusing on database optimization, query analysis, and monitoring tools for better web application speed.
A guide on replacing Drupal's resource-intensive database logging with the Syslog module for better performance.
Explains how to use PostgreSQL expression and functional indexes to optimize queries using built-in functions or custom JavaScript functions.
A guide to using MiniProfiler for performance profiling and identifying bottlenecks in ASP.NET MVC applications, focusing on database queries and server-side timing.
A technical guide on reducing SQL database size by normalizing repeated data like IPs and User Agents into separate relational tables.
Explains the ambiguous GATHER AUTO option in Oracle's DBMS_STATS for gathering database statistics, clarifying its behavior compared to STALE and EMPTY.
Argues against using Oracle's automatic optimizer statistics collection in data warehouses, advocating for manual stats management as part of ETL processes.
A technical guide on safely converting a SQL Server primary key index from nonclustered to clustered (or vice versa) using a temporary unique constraint.
A developer details optimizing a Django view to analyze chat log data, reducing execution time and database queries.
Technical analysis of optimizing an Identity Mapper in Django, focusing on query reduction and in-process caching strategies.
Explains how to create an efficient timeline view in Django by merging multiple sorted querysets to minimize database queries.
