100 Things I Hate About Views: Undeclared Data Types in Columns
Views let you do dumb things by accident in SQL Server. Then they make you have to think way too hard to fix them.
Read Moreon • 3 min read
Like anyone else, I easily get wrapped up in my own life: my family and friends, my work, my local community, my technical community. Facebook, Twitter, cat pictures. When I took time off from work recently, I got a glimpse outside of my normal, narrow world.

An old friend of mine, Steven Werlin, lives in Haiti and helps people climb out of poverty. He needed some help with his website.
Years ago, I helped Steven set up his website. This was back before Wordpress had largely taken over, before the real “rise of blogs” had happened. Wikis were particularly popular at that instant, so I set the site up with a free Wiki software. It ran on a server sitting in the basement of a house in Seattle, Washington.
Time passed. I moved away from Seattle. Steven kept writing, and the website grew to over 300 essays.
But eventually one of the hard drives in that old server in the basement stopped spinning so perfectly. We were lucky: very little data was lost. (There were 2 or 3 corrupt images, and the backups of the website databases were OK. Yes, I’d set up backups, but my younger and more foolish self hadn’t set up transfers of complete backups off that server. And thank you Rich for helping me recover everything!)
The new setup is cost effective and has a lot more redundancy. It should be a lot more reliable for Steven to write and for readers to access. It’s nothing too fancy, here’s what I configured:
Getting that all set up was fast. Moving in all the old post content and images took a lot longer, because all the posts were stored in Wiki format and the images were in a variety of subfolders. (The Add From Server plugin was a lifesaver in the migration process.)
But there was a perk to the work of migrating the content post by post: I learned a lot.
Steven works with programs that are part of Fonkoze. He helps identify people who can successfully work through the microfinance programs and transform their own lives. He writes about the way the programs run, the people they help. He writes about successes and struggles. When you read his writing, you get a glimpse into a world that is probably very different than your normal life.
When you have a few moments, visit ApprenticeshipInEducation.com and read for a while.
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.