Analyzes the current state and future of SQL Server's In-Memory OLTP technology, highlighting new features in SQL Server 2019 and persistent limitations.
Explores SQL Server's Memory-Optimized TempDB Metadata feature, which reduces contention by moving system tables into memory, with a performance test demonstration.
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
Explains how to implement server-side projections in MongoDB.Driver for C# to improve performance by fetching only required document fields.
Explores the preview feature of ordered Clustered Columnstore Indexes in Azure SQL Data Warehouse, testing syntax and performance benefits.
Explains the index INCLUDE clause in SQL databases, covering its purpose, how it works with B-tree indexes, and when to use it for performance.
A guide to optimizing Django dashboard performance using SQL grouping sets for advanced aggregation, including a cautionary note.
A proposal for a new "Optimize for Analytics" database configuration option in SQL Server and Azure SQL Database to enhance performance for data warehousing workloads.
Announcing a new YouTube channel focused on SQL Server Columnstore Indexes and Batch Execution Mode, featuring technical videos and interviews.
Explores Microsoft's new Columnstore compression estimation in SQL Server 2019, comparing it to a custom system stored procedure.
Announcing a full-day SQL workshop on optimizing data warehouses using Columnstore Indexes, from basics to advanced tuning, at SQLSaturday Madrid 2018.
A personal reflection on the author's 5-year journey writing a blog series about SQL Server Columnstore Indexes, from initial posts to becoming an expert.
Explores Microsoft's Resumable Online Index Creation feature in Azure SQL DB, detailing its benefits for managing large databases without downtime.
Introduces a custom stored procedure for estimating compression savings for SQL Server Columnstore Indexes, filling a gap in native tooling.
Explores the new online rebuild feature for Clustered Columnstore Indexes in SQL Server, detailing its significance and testing methodology.
Author shares excitement about being selected to speak at PASS Summit 2018 on SQL Server Columnstore index selection.
Explores how to speed up MongoDB's $facet aggregation stage using parallel processing for faster data analysis.
Explains performance issues with standard UUIDs in MySQL and presents an optimized solution using binary storage and bit-shifting.
A technical guide explaining how to use Django's prefetch_related to solve the N+1 query problem and optimize database performance.
Technical guide on optimizing Drupal performance by managing database indexes, queries, and removing unused modules.
