Bryan Jenks Homelab Services Tour 2024 🖥️

Overview

I've wanted to make a homelab tour video for a long time, my homelab and what i've learned with it is a project near and dear to me. I have a lot of fun playing with services and automations and building my own apps and custom code, as well as just documenting things and wiring it all together. Home-labbing is FUN, and i love doing it and wanted to share with you what i've done so far in the lab :)

Timestamps

• 0:00:35 What is going on with this server rack
• 0:01:08 Network Topology Diagram
• 0:03:13 Current project impediments and the current plan
• 0:04:41 Topology Continued
• 0:06:32 TrueNAS Network Attached Storage
• 0:10:08 Proxmox Hypervisor
• 0:13:16 Postgres Debian VM
• 0:14:38 CARD health video when it drops
• 0:14:49 Portainer Debian VM Docker Host
• 0:16:24 Portainer Stacks For All Containers
• 0:19:29 Docker Hosted Services Tour
• 0:19:40 Organizer Dashboard
• 0:20:15 Linkwarden Bookmarks
• 0:20:34 Planka Kanban Boards
• 0:25:00 Network Grouping
• 0:25:33 Media Grouping
• 0:26:09 Overseer Media Requestor
• 0:27:11 Photoprism Photo Management
• 0:29:33 Kavita Reader
• 0:31:08 Ubiquiti Grouping
• 0:32:27 Container Management Grouping
• 0:32:35 Another Look At Portainer
• 0:33:38 Dozzle Docker Log Viewer
• 0:34:21 Data Grouping
• 0:35:11 Grafana Dashboards
• 0:36:12 NocoDB
• 0:36:33 Utilities Grouping
• 0:37:21 Prometheus
• 0:38:52 Healthchecks
• 0:40:04 Services Grouping
• 0:40:07 File Browser
• 0:41:56 Drawio Diagraming
• 0:42:16 Wikijs For Documentation
• 0:45:22 n8n Workflow Automation
• 0:51:39 Appsmith Custom Applications
• 0:51:57 The Period Tracking Service I Made For My Fiance
• 0:56:07 Sushi Data Application Idea
• 0:56:58 Home Management Grouping
• 0:57:09 Grocy Grocery Management
• 0:58:26 Wrapping Up
• 1:00:34 Outro

Introduction To SQL & Databases

SQL is an awesome language and has been around for decades. It is the defacto language for dealing with and manipulating data in Relational Databases.

I use SQL in my day job every day and it is a fantastic tool in your toolbox. It is not only very easy to learn the basics to start getting data and working with it, but certain variations of SQL are just a pleasure to work with.

My least favorite type of SQL is PL-SQL in Oracle databases, and my favorite is T-SQL in SQL Server.

This video takes you through the basics of T-SQL and begins to enter the more intermediary topics of triggers, stored procedures, user defined functions etc.

IF you're looking to get a start in SQL and databases this is a great starting place for you.

0:00:00 - Intro
0:00:33 - Support the Channel
0:00:54 - What is SQL?
0:01:20 - What Does A Database look like?
0:06:03 - Database objects 
0:29:38 - SQL Language Syntax
0:30:18 - USE Database
0:31:22 - Basic SELECT Statement
0:32:47 - DISTINCT Keyword
0:34:02 - The WHERE Clause
0:34:56 - Aggregation Functions
0:37:59 - Aliasing New Columns
0:39:00 - Date Range Operator BETWEEN
0:42:24 - The IN Operator
0:43:11 - GROUP BY
0:44:58 - The HAVING Clause
0:45:36 - Exclude NULL
0:48:44 - SQL JOINS
0:51:06 - Aliasing Tables
0:52:29 - INNER JOIN
0:53:45 - LEFT JOIN
0:55:02 - RIGHT JOIN
0:55:48 - FULL OUTER JOIN
0:58:05 - Date Functions
1:02:37 - Integer Functions
1:03:16 - CAST Data Types
1:04:33 - String Functions
1:07:08 - Variables
1:11:47 - CASE Statements
1:14:54 - IF Statements
1:17:51 - TRY CATCH Statements
1:19:59 - Database Objects
1:20:45 - User Defined Functions
1:26:54 - Triggers
1:33:59 - Common Table Expressions
1:36:50 - Temporary Tables
1:40:52 - Stored Procedures
1:44:32 - Jobs
1:45:27 - Closing
1:47:10 - THANK YOU PATRONS
1:47:23 - Outro

My Home-lab Server Rack Tour ( It’s Taller Than Me! ) 🖥️

This project all started from passing my CompTIA Network+ certification.

I found that i really liked the idea of networking and servers, running my own services, and monitoring the entire environment from the ground up.

Since posting this videos ive acquired even more resources, hardware, knowledge, and interest in my home-lab.

This is an introductory tour to what i currently have in the home-lab but as of this blog post it's only improved and grown from there.

I have big plans for the services and things i will be running on this server and the databases i'll have to collect and store my own personal data and i hope to document all of it via publicly acessible code, but also via youtube videos talking about the technology.

Interested in more of what im doing around this stuff? Check out my DevLog notes from the dropdown in the Banner at the top of the page!

00:00 INTRO
00:18 INTRO TALK
01:08 SUPPORT THE CHANNEL
01:28 SERVER
03:57 SERVER RACK
06:22 SERVER RACK DETAILS
09:22 SERVER RACK REVIEW
10:13 MULTI STAGE PLAN
13:07 REVIEW
17:45 CLOSING
18:56 OUTRO