Finding order where there seem to be None
Finding the logical order for a data migration with foreign keys, system views, and a recursive SQL query.
Everything is and can be connected, it is up to us to find the pattern.
Exploring ideas through data, code, and curiosity. A collection of projects, experiments, and lessons along the way.
Blog
Ideas, code, and things I learned.
Practical examples and observations from working with data and databases.
Six months with PostgreSQL, after years of SQL Server
Looking beyond the familiar database stack, and a short video on how PostgreSQL feels alongside SQL Server.
Asterisk Risk ✨: Avoid using '*' in your SQL code
How SELECT * can hide a schema change in a SQL Server view, and how explicit columns and schema binding help.
Side projects
Other things I make.
Data is the main thread, but not every useful or interesting idea begins with a dataset. This is room for the small tools, web experiments, and odd ideas I pursue on the side.
Quod Libet plugin
Trash Current Track
A Quod Libet plugin that confirms before moving the current track to the trash and removing it from the library. Works with paused tracks; ignores streams and never permanently deletes files.
Quod Libet plugin
Playlist Shortcuts
Add the current Quod Libet track to playlists with global keyboard shortcuts. Tracks can belong to multiple playlists; repeated presses never duplicate or remove them.
Desktop app
Grabgram
Save Telegram videos, audio, photos, and documents with a desktop app that remembers your downloads.
About & contact
A little context.
I work with analysis and business intelligence. Most of the interesting parts happen before a chart is finished: understanding the question, checking what the data can support, and deciding what should remain uncertain.
This site is where I keep examples and notes from that process. It also leaves room for side projects that come from a different kind of curiosity. None of them are final answers—just records of what I tried, what worked, and what I would reconsider.
- Often using
- SQL · Python · statistics
- Working with
- Star schemas · DAX · ETL
- Thinking about
- Power BI · dashboards · explanation
- Still learning
- Requirements · documentation · communication