Posts

Second week of part-time work Even though I was not on task-allocation duty this week, my second week of working 4 hour days seemed to have just as much admin work as last week. Still, I made progress on a few a important things. We’ve worked to reduce our nightly error list again, and I loaded some more tickets for bad data in the source system causing import errors. I was finally able to alter the necessary tables to change one of our column types to BIGINT in production, and then copy the Change Automation data from the test server so that our Octopus deploy wouldn’t lock the tables for hours again - the migration scripts were already flagged as done....

First week of part-time work So, I’ve now spent a week only working 4 hours a day instead of 8. It’s been pretty nice to not wake up to an alarm, start late, and finish my work on 2 PM. It’s given me more time for exercising, baking, and Warhammer painting, to name a few. I don’t know if I’m actually sleeping better, or my stomach feels any better, but it’s a much nicer state, mentally....

Time for a change I have been struggling for a long time with gut issues and bad sleep. Part of it may be due to stress, part is genetics, and part is my lifestyle, I’m sure. After many doctors and tests over the past seven years, I’m trying a few more different things. For one, cutting out almost all gluten from my diet for six months on the advice of the GP....

Some more cleaning up whilst waiting for projects to start More cleanup at work this week. I’ve been going through all of the SQL databases on the servers we manage, listing all of the users that have db_owner permission, and trying to work out if they actually need that permission by asking the person actually responsible for the database. I’ve moved quite a few users from db_owner to data reader, data writer, ddl admin, and a custom role to allow execution of stored procedures....

A bit of a slow, distracted week Working from home is difficult when your work is not that engaging. I admit, a fair bit of time at home spent playing Metroid:Zero Mission and Don’t Starve Together. Both games have very interesting puzzles. As for my actual work, well a lot of dealing with standard tickets again. We failed over our SQL Data Warehouse on the weekend to help with some hardware issues....