Volume XIV • Technical Archive

Articles

A curated collection of technical explorations, architectural insights, and research findings from my exploration and work with new technologies.

search
Introducing the Model Context Protocol (MCP) - Your Universal AI Plug
AI/ML
September 2025 1 min read

Introducing the Model Context Protocol (MCP) - Your Universal AI Plug

A beginner's guide to MCP, the open standard connecting AI to the world.

AI Tools MCP Model Context Protocol
AI/ML
William Golovlev arrow_forward
SQL CTE - Power up your queries!
Data Engineering
September 2025 3 min read

SQL CTE - Power up your queries!

SQL Common Table Expressions (CTEs) - Your Guide to Cleaner, More Powerful Queries

SQL Database CTE
Data Engineering
William Golovlev arrow_forward
SQL Window Functions - A Beginner to Intermediate Guide
Data Engineering
September 2025 4 min read

SQL Window Functions - A Beginner to Intermediate Guide

A SQL tutorial to learn about window functions.

SQL Database Data Analysis
Data Engineering
William Golovlev arrow_forward
What is Retrieval-Augmented Generation (RAG)?
AI/ML
September 2025 1 min read

What is Retrieval-Augmented Generation (RAG)?

An introduction to RAG, the AI technique that enhances large language models with external knowledge.

AI/ML RAG Retrieval-Augmented Generation
AI/ML
William Golovlev arrow_forward
Opinion - The Double-Edged Sword of Vibe Coding 🎧
AI Ethics
September 2025 1 min read

Opinion - The Double-Edged Sword of Vibe Coding 🎧

Coming from someone who uses AI both professionally and as a hobby...

AI Ethics Software Development Opinion
AI Ethics
William Golovlev arrow_forward
Choosing the Right Tool - Vector vs. Graph Databases for RAG
Data Engineering
September 2025 2 min read

Choosing the Right Tool - Vector vs. Graph Databases for RAG

Comparing to trending tools in the AI space.

AI/ML Databases Vector Databases
Data Engineering
William Golovlev arrow_forward
arrow_back Previous
3 of 4
Next arrow_forward