Sysadmin theory

Winserver Azure - green-fox-academy/tibics@8526002 (github.com) gaboca1200/finalprojekt at master - green-fox-academy/gaboca1200 (github.com) Learning material 1. syllabus green-fox-academy/safely-syllabus: HSG 3.0 Zygomaticus - Sysadmin (github.com) shell/powershell teaching-materials/syllabus/infra-fundamentals/T5 at hsg-sysadmin-materials - green-fox-academy/teaching-materials (github.com) sql teaching-materials/syllabus/infra-fundamentals/T6 at hsg-sysadmin-materials - green-fox-academy/teaching-materials (github.com) networks teaching-materials/syllabus/infra-fundamentals/T3/T3_01_Network at hsg-sysadmin-materials - green-fox-academy/teaching-materials (github.com) IP Subnet Calculator containerization - docker [...]

By |2022-12-12T06:30:51+00:00December 11th, 2022|Uncategorized|0 Comments

PowerShell, Windows admin

https://github.com/green-fox-academy/safely-syllabus/tree/master/materialreview/scripts/powershell https://github.com/green-fox-academy/safely-syllabus/tree/master/materialreview/powershell-commands ##### MatRev ##### # This is a one line comment #Strings $aString = "Alma" [string]$bstring = "Korte" $aInt = 10 [int]$bint = 5 $aInt = $bInt $aInt += $bInt $aInt++ $aInt $aInt = 10 #Ballpoint numeric values $aFloat = 1.5 [float]$bFloat = 1.5 #$bFloat = $aFloat [...]

By |2022-12-11T20:56:23+00:00December 11th, 2022|Uncategorized|0 Comments

SQL

SQL wizard OFFSET - from row x to row y ORDER BY Continent ASC, Subregion DESC OFFSET 29 ROWS FETCH NEXT 50 ROWS ONLY; WITH TIES - dead even with last place SELECT TOP 10 PERCENT WITH TIES; COALESCE - 1. non NULL value SELECT COALESCE(NULL,NULL,2,5,NULL) COALESCE(PickedByPersonID,BackorderOrderID); WHERE - character substitutions WHERE StockItemName LIKE '%ham[^m]%' WHERE StockItemName LIKE [...]

By |2023-03-03T18:19:07+00:00December 11th, 2022|Uncategorized|0 Comments

Linux Admin

https://github.com/green-fox-academy/safely-syllabus/tree/master/materialreview/scripts/bash ##### 3. Exam Preparation linuxadmin part ##### Typical Admin TasksInstall the httpd packageCreate a user and the corresponding group for the web site administrator named webmasterThis is the SSH public key of the webmaster:ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDBaVwDbVfjWUudsIHLQFdfekvdm2S1eYBCw7tZx0U1+gaXOd5LX2cq3P2YEBImsoUl0c9R0wOlf7w6H1bKLYtaCeyKByiyYUBQyU/VmeFH9RUOw1uJzIuuHaOMVx1GuONzymGhTpiPi0x+2gsBDLtdJCq5AiH/8QHJ7BcNNqgjK8kIHPT6gaaXgboy6hIw5KGOnw1+y9yGRXhRWT4vAjncoK7P1UO3BTcc42OpDOdet1E5iGzYAd6lIF6lpjPuJBTvdYZDt33I6vXCSBBnI8tlx7HPSj0ULP+kHl8MAY2Nqv/aRBG8LQULT/QhmG7+y4LVtASJGnylcMRt1i3ojiIx root@408cd9fb18a8Copy to the right place. The /var/web directory is no longer needed, deleteCreate a folder for a web page you are building: /var/wwwCreate an index.html file here [...]

By |2022-12-11T16:12:41+00:00December 11th, 2022|Uncategorized|0 Comments

Linux bash tasks

##### MatReview exercises ###### https://github.com/green-fox-academy/safely-syllabus/tree/master/materialreview/scripts/bash 1) Processor number and type #!/bin/bash function ProcCount() { Pcnt=`cat /proc/cpuinfo | grep -o processor | wc -l` echo $Pcnt } function CPUtype() { cputp=`cat /proc/cpuinfo | grep "model name" -m 1 | cut -d ':' -f 2 ` echo $cputp } echo $(CPUtype) x $(ProcCount) 2) Delete date, formatted [...]

By |2023-01-16T18:12:52+00:00December 11th, 2022|Uncategorized|0 Comments

Evening reading for my fellow Sysadmins at GreeFox

Find out what the machine room classification levels are! Make a comparison table! The table below provides a high-level overview of the four data centre levels and shows what the different models offer to customers. PARAMETERS LEVEL 1 LEVEL 2 LEVEL 3 LEVEL 4 LEVEL 4 Operating Time Guarantee 99.671% 99.741% 99.982% 99.995% Annual Downtime <28.8 hours [...]

By |2022-08-22T06:17:52+00:00August 21st, 2022|Uncategorized|0 Comments
Go to Top