OS: RaspberryPI Lite users you should create
dvandenbosch (sudoer)
gui (non sudoer)
install dotfiles (This is for Dan Van Den Bosch own sanity)
kam-daniel
/ PostgreSQL_needle_in_a_haystack.sql
Created
November 13, 2023 16:29
— forked from danielleevandenbosch/PostgreSQL_needle_in_a_haystack.sql
Search all tables inside of PostgreSQL up to a certain size. This is good for finding those smaller tables when a sample of data is given to you.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DO | |
| $$ | |
| DECLARE | |
| value int := 0; | |
| sql text := 'The constructed select statement'; | |
| rec1 record; | |
| rec2 record; | |
| BEGIN | |
| FOR rec1 IN | |
| SELECT |
kam-daniel
/ restart_my_personal_global_shop_session.bat
Created
January 2, 2024 13:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @echo off | |
| setlocal | |
| set SERVER1=10.30.1.15 | |
| set SERVER2=10.30.1.16 | |
| for %%i in (%SERVER1%, %SERVER2%) do ( | |
| call :logoffUser %%i | |
| ) | |
| exit /b |
kam-daniel
/ give_me_back_my_g_drive.bat
Last active
January 17, 2024 16:11
This is a script to get the m drive returned to users client pcs
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @echo off | |
| net use G: \\10.30.1.5\apps /persistent:yes |
kam-daniel
/ codesoft_unix_time.txt
Created
September 3, 2024 19:40
in codesoft, this formula will return the current unix time as if your timezone is gmt
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (((my_year - 1970) * 365) + | |
| ((my_year - 1970) / 4) - if(my_year % 4 = 0,1,0) + | |
| IF(my_month > 1, 31, 0) + | |
| IF(my_month > 2, IF((my_year % 4 = 0), 29, 28), 0) + | |
| IF(my_month > 3, 31, 0) + | |
| IF(my_month > 4, 30, 0) + | |
| IF(my_month > 5, 31, 0) + | |
| IF(my_month > 6, 30, 0) + | |
| IF(my_month > 7, 31, 0) + | |
| IF(my_month > 8, 31, 0) + |
Purpose:
This document outlines the steps to configure unattended upgrades on Debian-based Linux systems, ensuring that systems automatically receive and apply security updates.
kam-daniel
/ view_column_getter.sql
Last active
September 24, 2024 17:28
Postgres view column getter with casting for migrating views to functions and maintaining legacy
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH | |
| my_table_name AS | |
| ( | |
| SELECT 'v_forecast_summary' AS table_name | |
| ) | |
| , colpad AS | |
| ( | |
| SELECT | |
| MAX(length(columns.column_name)) AS pad | |
| FROM information_schema.columns |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Windows Registry Editor Version 5.00 | |
| ; Disable VBA warnings for Access Runtime | |
| [HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security] | |
| "VBAWarnings"=dword:00000001 | |
| ; Optional: Trusted Locations (adjust path accordingly) | |
| [HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location1] | |
| "Path"="C:\\Path\\To\\Your\\Database\\" |
kam-daniel
/ caps_to_esc.reg
Created
June 26, 2025 21:03
Cap lock is useless. Make it escape for vim purposes for your windows system.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Windows Registry Editor Version 5.00 | |
| [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout] | |
| "Scancode Map"=hex:00,00,00,00,00,00,00,00,\ | |
| 02,00,00,00,01,00,3A,00,\ | |
| 00,00,00,00 |