Blog
SQL, data, and practical AI — plain English. Filter by topic or search.
All articles
Deduping without destroying history
Duplicates are identity problems, not a delete button. Learn natural versus surrogate keys, soft deletes, merge lineage, and validation checks so you collapse false twins without shredding history,…
When Work beats Chat (and when it does not)
Part 4 closes the ChatGPT Work tutorial. Use a decision table for when Work beats Chat, when Chat is enough, and which wrong doors to avoid. Then continue…
Plugins, connectors, and tools
Part 7 of Claude Code tutorial. Map built-in tools, MCP connectors, and plugins that bundle skills, subagents, hooks, and settings. Climb the ladder from a plain task to…
Profile before you polish
Cleaning before you look is how silent bias sneaks into dashboards. Learn a lightweight profile of counts, nulls, ranges, and weird categories with SQL and Python so every…
Multi-step jobs and checking results
Part 3 of the ChatGPT Work tutorial. Run multi-step jobs as a goal-plan-act-checkpoint loop: review the plan, steer mid-run, check usage, and finish with a result checklist that…
