Tag Archives: software development

Building a SQL Saturday Archive

Posted on December 28, 2020 by way0utwest

Some time ago I started gathering the SQL Saturday XML files. I started to parse and work with these, but the data is a mess and it never was that important. I regret that now. In any case, with the … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

The Challenges of Splitting a Table

Posted on September 15, 2020 by way0utwest

I ran across a discussion on Reddit about splitting a table. In this case, the original post had to do with a vertical partition of data, which is a technique that can help you better manage data in your database. … Continue reading →

Posted in Editorial | Tagged | 2 Comments

The Challenges of Resetting Databases

Posted on August 31, 2020 by way0utwest

I was working on a demo recently where we had a database in version control and a development database. This was a team environment, with a few of us making changes and syncing them across our dev systems using git. … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Challenges of Resetting Databases

Microservices

Posted on August 27, 2020 by way0utwest

Recently I wrote about software trends from 2019 and how applicable they might be today. One of those was microservices, which I don’t see implemented that often with relational databases. I do see developers wanting to use them, but I … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Microservices