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.
Blog
Ideas, code, and things I learned.
Ideas, practical examples, and lessons from working with data and code.
All blog posts
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.