Hero Image
An Overview of SQL Data Types

I have been asked to do more posts on databases, so I’m returning to the world of relational databases this week. I posted an introduction to databases a few months back that you can take a look at for a 10,000-foot view. The next logical step seems to be to take a look at the types of data available across the SQL standard and the more common relational database systems out there.

Tuesday, November 22, 2022 | 7 minutes Read
Hero Image
An Introduction To Databases

Something a little different this time around. Lately, both at work and in my personal projects and learnings, I’ve been dealing with a wide variety of databases. Databases in general are a core component in application infrastructure. Despite that, they get far less focus in the blogosphere than other topics like UI, UX, APIs, and the like. I get it. Databases aren’t sexy. They aren’t cool. They’re just the core that supports the entire application. Nothing important.

Tuesday, August 30, 2022 | 6 minutes Read
Hero Image
Deploy Database Updates With FluentMigrator and VSTS

One extremely handy open source library for .NET developers is FluentMigrator. This package allows you to script out your database changes as C# classes. The concept is similar to the code first migrations of EntityFramework, but allows you a bit more fine tuned control over deployments and doesn’t tie you to any specific ORM or other database interaction model. For example, it’s easy to control which environments the updates go to with tagging. This can help prevent accidental database updates to production and has already saved me from database restores on a couple of occasions.

Thursday, November 30, 2017 | 7 minutes Read