A life-long learner and technologist with a passion for all things database. Deep knowledge with PostgreSQL, Oracle, SQL Server, GIS extensions, performance tuning, and design. 20+ years of experience with a variety of companies from government to aerospace to startups in technical operations, support, and technical sales.
Rob Mandeville's Sessions
Stop Indexing the QuerySQLBits 2023
Find out how to index for YOUR workload instead of adding an index for a problem query. I'll share my methodology with you to make you a better optimizer.
Should We Defragment Indexes?SQLBits 2023
You may want to stop or limit defragmenting your indexes when you encounter external fragmentation because it may be causing performance degradation. Join us as we take a deeper look at modern disk architecture and what's actually happening with I/O.