Here at Youi in our database administration/data platforms/data foundations (we have a few names, depending on who you speak to) we have an intranet site built way back when that we use to maintain our ETL processes. It’s simply a front end for more easily adding records to some admin tables we have, tables which drive the procs that run, the other procs they are dependent on, and mapping of columns from source system to SQL table, among other things....
Not too much exciting going on, hence the lack of update last week. I’m continuing to work on the finance project to move from Excel to SQL - thankfully, that is nearly done. I’ve also continued on our security audit to review users and what access they actually need. Plus, the usual work on adding steps to our nightly ETL process and keeping the warehouse as healthy as we can....
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....
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....
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....