Tag Archives: database design

Database Design for Tracking Solar Production

We had a solar system installed at our house this year. I’m excited to see how this performs, as our estimates and research shows this ought to be a good financial decision for us over time. While the hardware that … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Eyes Wide Open

Not many of us work in startup environments, but many of us do work with new databases that are created for new applications. These might be carefully designed, thrown together, or your database might be constructed by an ORM. In … Continue reading

Posted in Editorial | Tagged , | Comments Off on Eyes Wide Open

A Beginning Project

One of the ways in which developers become better at their craft is by building software. They tackle a personal project or maybe modify someone else’s code. They may work through exercises, solving problems like the Advent of Code. As … Continue reading

Posted in Editorial | Tagged | 1 Comment

Understanding Your Database

I ran across a neat post from Michael Swart recently. In doing some spring cleaning, he was looking to remove unused, or maybe unnecessary, tables from his database. He published a script that looks through the plan cache to determine … Continue reading

Posted in Editorial | Tagged | Comments Off on Understanding Your Database