Making a Start on Virtual Servers with SQL and Octopus Deploy

My plan was to create two virtual machines that would mostly lay dormant, and install SQL Server Express on both of them. One of them would be my test environment, and one would be my live environment, with my local machine acting as development. I started googling “virtual machine windows 10” and following the Hyper-V application notes (Microsoft Documentation). First, I needed to create an .iso file: Microsoft Documentation I didn’t need a USB, but I simply ran the tool and selected “Create an ....

August 9, 2021

A Lack of Focus

Unfortunately we had to go into lockdown again this week, missing out on a few social events. Well, I’m thankful that it’s not too bad, though the constant construction going on outside my window is getting on my nerves a little. This was my first week trying Microsoft’s suggestion for “Focus Time” where it automatically blocks out sections of your calendar to be undisturbed. I failed at following the suggestion, but it is nice to have scheduled do-not-disturb time....

August 7, 2021

A Quiet Week

Sometimes, trying to get stuff done is hard It wasn’t a short week. I had a lot of time to focus on some important projects, but my focus this week was a little lacklustre. I have been heading into the office a few days a week, but the rest of my team is working from home, so it feels a little lonely when the others groups have multiple people from their teams....

July 31, 2021

Short Week

I had my birthday to celebrate on the weekend and so it was only a four-day week. Not too much exciting going on at work: Nightly ETL errors to fix Some code to disable nightly jobs built by other people if they fail too often without being fixed Trying to put the rest of our databases under git change automation Check our remaining databases to see who I missed for removing db_owner privileges Going through and remove all instances of individual users being create This seems to happen when someone who connects to the database through a group (an Active Directory group), that group has no default schema, and then the user creates an object without specifying a schema....

July 24, 2021

Back to Normal

Goodbye part-time hours, it was nice knowing you Well, I enjoyed my two weeks of working half-days and going for long walks, but it’s back to regular hours. Interestingly, I was probably more than 50% productive with only 50% of the hours. It’s easier to focus for a shorter day, I think. I’m sure there is some optimal point in that curve. So, this week’s work was mostly a continuation of all the things I had started on during the previous fortnight....

July 17, 2021