Teamcity, Octopus, and SQL Change Automation

Figure out how to get virtual machines running on my Windows 10 Home PC Stand up two virtual machines and install SQL server on both - one to simulate a test environment, and one to simulate a production environment. My local server will be development. Get a (hopefully) free acount for TeamCity and Octopus Install Redgate’s Flyway product for SQL change automation and deployment - we use SQL Change Automation at Youi, but that is expensive....

July 17, 2021

Learning SQL DBA

I’ve been working at an insurance company for nigh-on six years at this point, and I’ve been writing SQL the entire time. As a member of the Business Intelligence team, most of my work has been creating reports with SQL and Microsoft SSRS, analysing data with Excel, and building dashboards in Tableau. Recently I’ve taken on a new role as a Data Foundations Analyst, which is to say more DBA-type work....

March 1, 2020

Genesys Adversaries

Genesys Adversaries is an easily searchable database of adversaries for Fantasy Flight Games’ Genesys Roleplaying Game. I’ve been playing FFG’s Star Wars and Genesys RPGs for a few years now, and I was super impressed by this searchable database and wanted to do something for Genesys. I knew I didn’t have the Javascript skills, but thankfull the repo is public. I made my fork of the Star Wars Adversaries repo, made a few tweaks to the colour scheme and symbols, then spent a fair bit of time going through the data entry part....

February 28, 2020

Learning Cello

When I was a young teenager, I dabbled in learning the piano by reading a book I’d borrowed and trying to play along with the piano we had at home. It didn’t last long. With no access to YouTube for me back then, and no teachers, I quickly gave up. The desire to learn an instrument stayed with me, though. For years I thought I would pick something that was easily carried....

October 25, 2019

Learning Japanese

I hated language classes at school; they were the only subjects that I received C grades for. It seemed pointless and impractical, full of random vocab and not at all interested. However, in December of 2010 I travelled to Nagoya, Japan for a one month mission trip with Campus Crusade for Christ Australia (now called Cru). I fell in love with the culture - the food, the courtesy, the scenery (though it didn’t hurt that my future wife was also on the trip)....

June 1, 2011