PostgreSQL: Query Optimization and Understanding Index Operations https://sudonull.com/postgresql-query-optimization-and-understanding-index-operations
Figure out why PostgreSQL ignores indexes. Detailed analysis of EXPLAIN ANALYZE, selectivity, correlation, and advanced index types to improve database performance.
Power Query from Excel: migration to BI and R7 https://sudonull.com/power-query-from-excel-migration-to-bi-and-r7
Learn how to extract M-code and dependencies from Excel for quick migration to BI or R7-Office. Automate audit and logic transfer without rewriting. Reduce analysis time by 6 times.
How to Write a SQL Query: Tutorial with Examples https://sudonull.com/how-to-write-a-sql-query-tutorial-with-examples
Learn how to write a SQL query with practical examples. Master SELECT, WHERE, JOIN, GROUP BY, and best practices for readable, efficient SQL. Start now.
Search intent: how to determine and measure https://sudonull.com/search-intent-how-to-determine-and-measure
Learn how to analyze query intent through SERP, bounce rate metrics, and AI. Optimize content for top positions in Yandex and Google. Tools and action plan.
CPU 80% Diagnostics in ClickHouse https://sudonull.com/cpu-80-diagnostics-in-clickhouse
Tools for finding problematic queries in ClickHouse: system.processes, query_log, EXPLAIN. Diagnostics steps, SQL examples, checklist. Optimize load without downtime.