Provides slides and scripts for the 'Indexing for Dummies' presentation from the dataMinds Connect 2025 tech conference.
Provides slides and SQL scripts from a 'Indexing for Dummies' session, focusing on SQL Server database performance.
Announcing two free online tech sessions: building a low-cost data warehouse with Azure and a beginner's guide to database indexing.
Guide on integrating Microsoft 365 Copilot agents with Azure AI Search for enhanced knowledge retrieval using RAG, offering more control than basic options.
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.
Author offers 12 free hours of expert consultation on Columnstore Indexes and Batch Execution Mode in SQL Server throughout 2019.
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.
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.
How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.
Zend Framework 1.7 now includes native OpenXML indexing support for Lucene, simplifying document search integration.
