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.
Observability in Go: QueryTracer, metrics and OTel https://sudonull.com/observability-in-go-querytracer-metrics-and-otel
Comparing observability tools in Go: QueryTracer, metrics and OpenTelemetry. Learn when to use each and how to avoid implementation errors.
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.