Data Architecture Preface

A couple of weeks before the December 2021 holidays, I attended a four day TOGAF training course. It was my introduction to Enterprise Architecture. The content was relatively interesting, and a very new perspective on things for me. I have always been involved in the nitty-gritty - creating reports, deploying dashboards, optimising code, implementing ETL. To think about the architecture rather than the actual construction was…refreshing. The actual Open Group framework we studied doesn’t sit that well with me....

January 15, 2022

A small foray into ASP.NET development

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....

October 16, 2021

TeamCity Stage One

Alright, now that Octopus kind of works, I want to get signed up for TeamCity and get that installed on my local machine. I’ve Googled “TeamCity” and ended up at https://www.jetbrains.com/teamcity/download/#section=on-premises where I downloaded TeamCity for on-prem I changed the installation directory to my secondary hard drive, but otherwise left all the settings on their default, including the port (8111) and the build agent properties (which popped up after the install) Run TeamCity Agent under the SYSYEM account and Start both services As it started it asked for the database type to store the build history....

September 15, 2021

Octopus Stage Two

Open the Octopus Manager and make sure the service has started, then naviate to the web portal (mine is at http://localhost/app#/) On the portal, Create your first environment and Add Environment, naming it Test, then Add Deployment Target (reading https://octopus.com/docs/infrastructure/deployment-targets) Select Windows for the type of target, then Listening Tentacle. Download the Tentacle (I chose 64 bit) Run the tentacle installer, installing in default location, and start the Tentacle Manager Select Get Started, then Listening Tentacle....

September 6, 2021

Another Quiet Week

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....

August 21, 2021