Roger Hosto
Articles
Writing about databases, infrastructure, and whatever else comes up.
Oct 15, 2026 · Management
Critical thinking is essential in the age of AI
Critical thinking is essential in the age of AI. While AI generates large volumes of information, it does not assess truthfulness, quality, or relevance. Critical thinking enables individuals to evaluate …
Sep 30, 2026 · Databases Administration
The Silent Performance Killer: How Lazy Data Types Sabotage Your Database
We have all been there. You are scaffolding a new feature, the data model is in flux, and you need to store a fast status flag or an identifier. Instead …
Sep 14, 2026 · Data & AI
The AI Workflow Bottleneck
Over the weekend, I worked on a couple of personal projects and used AI to help.
Aug 31, 2026 · Data & AI
AI as a Thinking Partner
Embracing AI as a Thinking Partner fundamentally redefines how individuals and teams tackle complex challenges, generate innovative solutions, and shape long-term strategies in the realm of technology.
Aug 27, 2026 · Databases Administration
The IKEA method of Database Design
I recently re-encountered the IKEA concept and recognized its relevance to database design.
Aug 17, 2026 · Data & AI
Google AI Professional Certifications
I recently spent the weekend earning the Google AI Professional Cert
Jun 29, 2026 · Management
Prioritizing Projects Effectively
This document provides a comprehensive guide to project prioritization. It begins by reframing the challenge of deciding which projects to tackle first, emphasizing the importance of evaluating initiatives based on …
Jun 3, 2026 · Databases Administration
Back to Basics: ORM and Its Impact on Database and Data Architecture
TL;DR: Object-Relational Mapping (ORM) makes it easier for developers to work with databases by automatically translating between code and data. ORMs boost productivity and code maintainability but can introduce performance …
Jun 1, 2026 · Personal
After several years away from blogging
After several years away from blogging
Jan 5, 2018 · Databases Administration
MySQL Error: 1062 'Duplicate entry' Error
The all too common MySQL 'Duplicate entry' Error. mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: master-mysql.local Master_User: repl Master_Port: 3306 Connect_Retry: …