Author offers 12 free hours of expert consultation on Columnstore Indexes and Batch Execution Mode in SQL Server throughout 2019.
A preview of the top talks at PostgresOpen 2018, covering topics like debugging the Postgres planner, indexes, extensions, and connection pooling.
Explains performance issues with standard UUIDs in MySQL and presents an optimized solution using binary storage and bit-shifting.
Announcement of the Spanish translation of 'SQL Performance Explained' with updates for latest database releases and a refreshed SQL indexing quiz.
A developer's personal appreciation letter to PostgreSQL, reflecting on its evolution, robust features, and adaptability over the years.
A preview of the 2017 Postgres Open Silicon Valley conference lineup, highlighting key talks on PostgreSQL indexing, scaling, and concurrency.
Debunks the myth that complex software like Google Search is easy to build, explaining why it requires vast engineering resources.
A summary of recent blog posts and presentations by Guido van Rossum, the creator of Python, covering topics like 0-based indexing and Python 3.
Analyzing MongoDB query performance using $exists operator and the impact of indexes on large datasets.
Explains how to use PostgreSQL expression and functional indexes to optimize queries using built-in functions or custom JavaScript functions.
A guide for developers on monitoring and improving PostgreSQL database performance, covering cache hit rates and index usage.
A detailed exploration of advanced PostgreSQL features like concurrent indexing, transactional DDL, and foreign data wrappers.
MongoDB 1.8.0 Release Candidate introduces key features like write-ahead journaling for durability, sparse indexes, and enhanced Map/Reduce.
A technical guide on optimizing SQL queries with wildcard-prefixed LIKE conditions using indexed computed columns for better performance.
How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.
Explains how to optimize SQL query performance by avoiding functions in WHERE clauses, using date filtering as a key example.
Zend Framework 1.7 now includes native OpenXML indexing support for Lucene, simplifying document search integration.
Guide to configuring search and indexing in MOSS 2007, including content sources, search scopes, and Search Center customization.
