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
How do your favorite LLMs like ChatGPT work, and where is the future for LLMs heading?
AI/ML
January 2026 1 min read

How do your favorite LLMs like ChatGPT work, and where is the future for LLMs heading?

How neural networks use embeddings to conquer NLP and tabular data.

NLP LLM ChatGPT
AI/ML
William Golovlev arrow_forward
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
arrow_back Previous
3 of 4
Next arrow_forward