Brent Ozar announces his upcoming sessions at the SQLBits conference, covering SQL Server performance tuning, indexing strategies, and cloud evolution.
Explores creative PostgreSQL optimization techniques beyond standard indexing and query rewriting, focusing on constraint exclusion and function-based indexes.
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 how to use Azure AI Search's integrated vectorization for automatic query and field vectorization, with portal and indexer examples.
A tutorial on building a basic document database in Go with Lucene-like filters and indexes, inspired by Elasticsearch.
A technical exploration of multiple ways to access a single element from a 1x1 array in Julia, including performance benchmarks.
A former Application DBA shares advanced SQL and database optimization techniques for developers, focusing on performance and efficiency.
Extending a SQL database in Go to support indexes, focusing on PRIMARY KEY constraints and SELECT optimizations using tree structures.
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.
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.
