Categories
System recovery
Using Amazon Windows Images
If you tried to use some windows images on aws, you may have noticed, that they have no password specified. In fact, there agent fails to set one. I've tried multiple ways to reset t...
In Administration, System recovery, Jul 16, 2018Hacking an SQL-Server
Basically if you're admin you own everything. So how would you access an SQL-Server if you don't have SQL-Permissions but you're administrator on the system the SQL-server is running...
In Administration, Security, System recovery, Dec 06, 2017ntds.dit Auditing
By searching for a way to remotely force an Windows Update check, I accidentally found this: DSInternals This looked very promising, so I checked out the linked blog and found th...
In PowerShell, Security, System recovery, Jun 10, 2016SFC is deprecated, use dism instead
Often sfc.exe reports errors that it cannot resolve automatically. Instead of "sfc.exe /scannow" run as Administrator: Dism /Online /Cleanup-Image /ScanHealth Dism /Online /C...
In System recovery, Oct 19, 2015Linux
Oneline backup
tar -PcJf - /home | pv -s $(du -sb /home/user | awk '{print $?}') | xz -z -T0 -1 - > /mnt/backupTarget/home.tar.xz
In Administration, Linux, Apr 28, 2020MSSQL on kubernetes (non azure)
Copy the code below into a file named mssql.yaml Apply the deployment file to your kubernetes cluster using:sed -i s/TXlDMG05bCZ4UEBzc3cwcmQ=/$(pwgen -s 120 1 | base64 -w 0)/...
In Administration, Linux, SQL, k8s, Mar 14, 2020m4 1.4.17 fails to compile
While following the cross linux from scratch instructions over here I ran into this issue: freadahead.c: In function 'freadahead': freadahead.c:91:3:error: #error "Please port gnu...
In Development, Linux, Feb 04, 2020Encrypted LVM remote unlock
Sometimes you want to have a strong Disk encryption but be still able to unlock it remotely. Sure, this is a compromise between security and usability, but here is what I come up wit...
In Administration, Linux, LVM, Security, Jul 24, 2017iptables to rsyslog
Log all dropped connections to syslogiptables -N LOGGINGiptables -A INPUT -j LOGGINGiptables -A OUTPUT -j LOGGINGiptables -j LOG --log-prefix "iptables: "iptables -A LOGGING -j DROPch...
In Administration, Linux, Security, Dec 17, 2016Apache2 optimizations
To gain a faster page loading, you can enable the client side caching. That means that the browser of the connecting clients is storing the contents of your page until it expires.Ther...
In Linux, Security, Webserver, Dec 22, 2015Disable Zone Transfer BIND9
If you use webmin go to "Zone Defaults" and enter "none" into the "Allow transfers from..." text box. If you don't use webmin go to the file "/etc/bind/named.conf.options" and en...
In DNS, Linux, Dec 21, 2015Logfile Monitoring (PowerShell/Bash)
In Linux, PowerShell, Oct 23, 2015Status Monitoring - Statusbar
How to have one line updated, for example showing available disk space updated every second.Within one line: while true; do echo -ne "$(df | grep /dev/sda4)\\r"; sleep 1; donehow ...
In Linux, Oct 19, 2015PowerShell
Fix Loud Fan Win10 Dell Notebook
My Dell notebook was making very loud fan noises as soon as it was connected to the dock. I already suspected the windows powerplan settings from the start, but MS decided to clear ...
In Development, Documentation, PowerShell, Fan, Windows 10, Oct 13, 2023Merging dictionaries within powershell
I needed to join dictionaries from within a list together, so that they become one whole dictionary. First I thought it may be a trivial task. Than I used google and realized, that ...
In Development, Documentation, PowerShell, Sep 01, 2020Install Selenium
Install Selenium: function Install-PSArchive { param() $null = Install-PackageProvider -Name PowerShellGet -Force -Scope CurrentUser Install-Module -Name 'Microsoft.PowerShell.Ar...
In Administration, Development, PowerShell, Security, Webserver, Dec 19, 2018netstat for Powershell
If you cannot use "Get-NetTCPConnection" here is the same using the good old "netstat -a" ;-) netstat -a | Select-Object -Skip 3 | ForEach-Object {$_ -replace '\s+', ' '} | ForEa...
In Administration, PowerShell, Sep 24, 2016PowerShell access private fields and properties
Using the poke module it is possible to access private and internal fields of objects you would otherwise not be able to.Example# peek at a Job instance using pipeline syntax$job = st...
In Development, PowerShell, Aug 19, 2016Get password from Securestring
Getting the password from a secure string is not always easy. If you have a PSCredential object however it is most of the times as simple as: $credential = Get-Credential $insecur...
In PowerShell, Security, Aug 15, 2016Clear all Eventlogs
wevtutil.exe enum-logs | Foreach-Object {wevtutil.execlear-log "$_"}
In Administration, PowerShell, Jun 14, 2016ntds.dit Auditing
By searching for a way to remotely force an Windows Update check, I accidentally found this: DSInternals This looked very promising, so I checked out the linked blog and found th...
In PowerShell, Security, System recovery, Jun 10, 2016PowerShell and SQL Server
To be able to use the "sqlps" PowerShell Module you first need to install it from here. SQLSysClrTypes.msi - CLR Types for SQL Server SharedManagementObjects.msi - Shared Man...
In Administration, Development, PowerShell, SQL, Apr 10, 2016PowerShell send E-Mail
Without smtp Server Authentication (with static IP or internal Mail Server) Note: Most public mail servers only accept a message for there users and don't forward it to other serv...
In Mailserver, PowerShell, Mar 24, 2016Status Monitoring
Here is a code sniped to monitor your servers. In the first example the result is simply written into a CSV-File, but in the second a e-mail is sent. Import-Csv -Path ".\IP-List.t...
In Mailserver, PowerShell, Security, Mar 24, 2016VPN Connection and Device Authentication
Automatically establish a VPN connection if a specific application is launched. So your users cannot forget to launch it first and will not call you therefor ;-) Add-VpnConnectio...
In Administration, PowerShell, Security, VPN, Feb 25, 2016SMB: Short file name creation should be disabled
If the Best Practive Analyzer is showing this error, you can disable the 8dot3 Names by running the following commandsInvoke-Command -ComputerName $ServerName -ScriptBlock { fsutil b...
In BPA, PowerShell, Feb 11, 2016Srv.sys should be set to start on demand
If the Best Practice Analyzer is showing this error, you have to run the command: Invoke-Command -ComputerName $ServerName -ScriptBlock { cmd /C "sc config srv start=demand" Get-...
In BPA, PowerShell, Feb 11, 2016Documentation of a given infrastructure
Getting the same information from every pc especially in a very complex and grown environment can be a tedious work. So why don't just call a script to help out ;-) # Network Driv...
In Administration, Documentation, PowerShell, Jan 26, 2016Remote Powershell
Login automatically with current privileges Enter-PSSession -computername hostname
In Administration, PowerShell, Oct 27, 2015Powershell UNC and Registry Paths
In Administration, PowerShell, Oct 27, 2015Get Powershell Version
$PSVersionTable $PSVersionTable.PSCompatibleVersions$PSVersionTable.PSVersion
In PowerShell, Oct 27, 2015Logfile Monitoring (PowerShell/Bash)
In Linux, PowerShell, Oct 23, 2015Native Network Scanner - foreach-object (PowerShell)
1..255 | foreach-object {[System.Net.Networkinformation.Ping]::new().Send("192.168.1.$_") } |where-object {$_.Status -eq "success"} | select Address
In PowerShell, Oct 23, 2015Administration
Oneline backup
tar -PcJf - /home | pv -s $(du -sb /home/user | awk '{print $?}') | xz -z -T0 -1 - > /mnt/backupTarget/home.tar.xz
In Administration, Linux, Apr 28, 2020MSSQL on kubernetes (non azure)
Copy the code below into a file named mssql.yaml Apply the deployment file to your kubernetes cluster using:sed -i s/TXlDMG05bCZ4UEBzc3cwcmQ=/$(pwgen -s 120 1 | base64 -w 0)/...
In Administration, Linux, SQL, k8s, Mar 14, 2020Wordpress nginx config
server { listen 80; listen [::]:80; root "/var/www/vHOST"; server_name vHOST; index index.html index.php; client_max_body_size 2G; rewrite ^/wp-json/.*$ index.php$uri last; ...
In Administration, Documentation, Webserver, WordPress, nginx, May 04, 2019Install Selenium
Install Selenium: function Install-PSArchive { param() $null = Install-PackageProvider -Name PowerShellGet -Force -Scope CurrentUser Install-Module -Name 'Microsoft.PowerShell.Ar...
In Administration, Development, PowerShell, Security, Webserver, Dec 19, 2018Bypass chrome tls security checks
Normally things like invalid certificates throw an error within google chrome, and if the page has HSTS in place, there is no way to bypass that error. For normal users this is a goo...
In Administration, Development, Security, Webserver, Dec 19, 2018Using Amazon Windows Images
If you tried to use some windows images on aws, you may have noticed, that they have no password specified. In fact, there agent fails to set one. I've tried multiple ways to reset t...
In Administration, System recovery, Jul 16, 2018Hacking an SQL-Server
Basically if you're admin you own everything. So how would you access an SQL-Server if you don't have SQL-Permissions but you're administrator on the system the SQL-server is running...
In Administration, Security, System recovery, Dec 06, 2017Encrypted LVM remote unlock
Sometimes you want to have a strong Disk encryption but be still able to unlock it remotely. Sure, this is a compromise between security and usability, but here is what I come up wit...
In Administration, Linux, LVM, Security, Jul 24, 2017iptables to rsyslog
Log all dropped connections to syslogiptables -N LOGGINGiptables -A INPUT -j LOGGINGiptables -A OUTPUT -j LOGGINGiptables -j LOG --log-prefix "iptables: "iptables -A LOGGING -j DROPch...
In Administration, Linux, Security, Dec 17, 2016netstat for Powershell
If you cannot use "Get-NetTCPConnection" here is the same using the good old "netstat -a" ;-) netstat -a | Select-Object -Skip 3 | ForEach-Object {$_ -replace '\s+', ' '} | ForEa...
In Administration, PowerShell, Sep 24, 2016Microsoft Best Practices for Securing Active Directory
https://technet.microsoft.com/en-us/windows-server-docs/identity/ad-ds/plan/security-best-practices/best-practices-for-securing-active-directory
In Administration, Documentation, Security, Sep 02, 2016Install From Media Dump
Install from media is created using: C:\> ntdsutil - activate instance ntds - ifm - create sysvol Full C:\ifm - q - q - q C:\> exit Or more simply and compact: C:\> ntdsut...
In Administration, Aug 14, 2016Disable Windows 10 auto reboot
In Administration, Jul 02, 2016Policy Analyzer
Today I found a tool, that can be very useful, if you need to identify changes made to e. g. the "Default Domain Policy". Here is the Link: Policy Analyzer
In Administration, BPA, Documentation, Security, Jun 21, 2016Clear all Eventlogs
wevtutil.exe enum-logs | Foreach-Object {wevtutil.execlear-log "$_"}
In Administration, PowerShell, Jun 14, 2016Centralized Windows Event Log
Another feature many administrators don't know about, is the centralization of Windows Event Logs. This allows you as administrator to view all related Event Log information on y...
In Administration, Security, Jun 05, 2016Mobile Broadband Modem and PuTTY
Find the right com-Port. Go to control panel, telephone and modem, modems. Here you have your com-port. For the baud rate go to Settings and Modem after selecting the correct mode...
In Administration, Mobile Broadband, Apr 16, 2016PowerShell and SQL Server
To be able to use the "sqlps" PowerShell Module you first need to install it from here. SQLSysClrTypes.msi - CLR Types for SQL Server SharedManagementObjects.msi - Shared Man...
In Administration, Development, PowerShell, SQL, Apr 10, 2016VPN Connection and Device Authentication
Automatically establish a VPN connection if a specific application is launched. So your users cannot forget to launch it first and will not call you therefor ;-) Add-VpnConnectio...
In Administration, PowerShell, Security, VPN, Feb 25, 2016Unsolicited Remote Assistance
Yes it is possible to make the Remote Assistance somewhat usable.Upside: - It's free - I recommend setting it up as a backup (If e.g. TeamViewer servers are down again).Downside: - UA...
In Administration, Jan 28, 2016Documentation of a given infrastructure
Getting the same information from every pc especially in a very complex and grown environment can be a tedious work. So why don't just call a script to help out ;-) # Network Driv...
In Administration, Documentation, PowerShell, Jan 26, 2016Remote Powershell
Login automatically with current privileges Enter-PSSession -computername hostname
In Administration, PowerShell, Oct 27, 2015Powershell UNC and Registry Paths
In Administration, PowerShell, Oct 27, 2015DHCP
2012R2 IPv6 DHCP without Router
If you want to have your DHCP-Server assigning unique local ipv6 addresses, but you don't have a IPv6 gateway or router jet, you will notice the following behavior: The IPv6 adre...
In DHCP, IPv6, Oct 29, 2015IPv6
2012R2 IPv6 DHCP without Router
If you want to have your DHCP-Server assigning unique local ipv6 addresses, but you don't have a IPv6 gateway or router jet, you will notice the following behavior: The IPv6 adre...
In DHCP, IPv6, Oct 29, 2015General
MMC and ServerManager is dead
This year on the Microsoft Ignite conference Microsoft announced the modern replacement for MMC and ServerManager. It is called Honolulu: https://docs.microsoft.com/en-us/windows...
In General, Oct 07, 2017Install a VMWare ESXi 6.0 Hypervisor in a Hyper-V VM
Commenting on my journey on:Recently I’ve been playing around with the new Hyper-V Nested Virtualization feature within Windows 10 (build 10565 and greater) and Windows Server 2...
In General, Dec 20, 2016Enable Strict Replication Consistency
If your Domain had existed pre Windows 2003 you have to run the following command:Open Nodepad and add the text (NO WHITE-SPACES AT THE END):dn: CN=94fdebc6-8eeb-4640-80de-ec52b9ca17f...
In General, Nov 14, 2015Presentation
Presentation about Hacking [German]
Presentation Hacking Handout Presentation Hacking PowerPoint
In Presentation, Nov 29, 2015DNS
Disable Zone Transfer BIND9
If you use webmin go to "Zone Defaults" and enter "none" into the "Allow transfers from..." text box. If you don't use webmin go to the file "/etc/bind/named.conf.options" and en...
In DNS, Linux, Dec 21, 2015Security
Install Selenium
Install Selenium: function Install-PSArchive { param() $null = Install-PackageProvider -Name PowerShellGet -Force -Scope CurrentUser Install-Module -Name 'Microsoft.PowerShell.Ar...
In Administration, Development, PowerShell, Security, Webserver, Dec 19, 2018Bypass chrome tls security checks
Normally things like invalid certificates throw an error within google chrome, and if the page has HSTS in place, there is no way to bypass that error. For normal users this is a goo...
In Administration, Development, Security, Webserver, Dec 19, 2018Hacking an SQL-Server
Basically if you're admin you own everything. So how would you access an SQL-Server if you don't have SQL-Permissions but you're administrator on the system the SQL-server is running...
In Administration, Security, System recovery, Dec 06, 2017Encrypted LVM remote unlock
Sometimes you want to have a strong Disk encryption but be still able to unlock it remotely. Sure, this is a compromise between security and usability, but here is what I come up wit...
In Administration, Linux, LVM, Security, Jul 24, 2017iptables to rsyslog
Log all dropped connections to syslogiptables -N LOGGINGiptables -A INPUT -j LOGGINGiptables -A OUTPUT -j LOGGINGiptables -j LOG --log-prefix "iptables: "iptables -A LOGGING -j DROPch...
In Administration, Linux, Security, Dec 17, 2016Microsoft Best Practices for Securing Active Directory
https://technet.microsoft.com/en-us/windows-server-docs/identity/ad-ds/plan/security-best-practices/best-practices-for-securing-active-directory
In Administration, Documentation, Security, Sep 02, 2016Get password from Securestring
Getting the password from a secure string is not always easy. If you have a PSCredential object however it is most of the times as simple as: $credential = Get-Credential $insecur...
In PowerShell, Security, Aug 15, 2016Policy Analyzer
Today I found a tool, that can be very useful, if you need to identify changes made to e. g. the "Default Domain Policy". Here is the Link: Policy Analyzer
In Administration, BPA, Documentation, Security, Jun 21, 2016ntds.dit Auditing
By searching for a way to remotely force an Windows Update check, I accidentally found this: DSInternals This looked very promising, so I checked out the linked blog and found th...
In PowerShell, Security, System recovery, Jun 10, 2016Centralized Windows Event Log
Another feature many administrators don't know about, is the centralization of Windows Event Logs. This allows you as administrator to view all related Event Log information on y...
In Administration, Security, Jun 05, 2016Status Monitoring
Here is a code sniped to monitor your servers. In the first example the result is simply written into a CSV-File, but in the second a e-mail is sent. Import-Csv -Path ".\IP-List.t...
In Mailserver, PowerShell, Security, Mar 24, 2016VPN Connection and Device Authentication
Automatically establish a VPN connection if a specific application is launched. So your users cannot forget to launch it first and will not call you therefor ;-) Add-VpnConnectio...
In Administration, PowerShell, Security, VPN, Feb 25, 2016Apache2 optimizations
To gain a faster page loading, you can enable the client side caching. That means that the browser of the connecting clients is storing the contents of your page until it expires.Ther...
In Linux, Security, Webserver, Dec 22, 2015WordPress
Wordpress nginx config
server { listen 80; listen [::]:80; root "/var/www/vHOST"; server_name vHOST; index index.html index.php; client_max_body_size 2G; rewrite ^/wp-json/.*$ index.php$uri last; ...
In Administration, Documentation, Webserver, WordPress, nginx, May 04, 2019Webserver
Wordpress nginx config
server { listen 80; listen [::]:80; root "/var/www/vHOST"; server_name vHOST; index index.html index.php; client_max_body_size 2G; rewrite ^/wp-json/.*$ index.php$uri last; ...
In Administration, Documentation, Webserver, WordPress, nginx, May 04, 2019Install Selenium
Install Selenium: function Install-PSArchive { param() $null = Install-PackageProvider -Name PowerShellGet -Force -Scope CurrentUser Install-Module -Name 'Microsoft.PowerShell.Ar...
In Administration, Development, PowerShell, Security, Webserver, Dec 19, 2018Bypass chrome tls security checks
Normally things like invalid certificates throw an error within google chrome, and if the page has HSTS in place, there is no way to bypass that error. For normal users this is a goo...
In Administration, Development, Security, Webserver, Dec 19, 2018Apache2 optimizations
To gain a faster page loading, you can enable the client side caching. That means that the browser of the connecting clients is storing the contents of your page until it expires.Ther...
In Linux, Security, Webserver, Dec 22, 2015Documentation
Fix Loud Fan Win10 Dell Notebook
My Dell notebook was making very loud fan noises as soon as it was connected to the dock. I already suspected the windows powerplan settings from the start, but MS decided to clear ...
In Development, Documentation, PowerShell, Fan, Windows 10, Oct 13, 2023Merging dictionaries within powershell
I needed to join dictionaries from within a list together, so that they become one whole dictionary. First I thought it may be a trivial task. Than I used google and realized, that ...
In Development, Documentation, PowerShell, Sep 01, 2020Wordpress nginx config
server { listen 80; listen [::]:80; root "/var/www/vHOST"; server_name vHOST; index index.html index.php; client_max_body_size 2G; rewrite ^/wp-json/.*$ index.php$uri last; ...
In Administration, Documentation, Webserver, WordPress, nginx, May 04, 2019Windows protocols
Technical Documents All pdf protocol documentations Name: Windows_Protocols.zip Size: 595648189 Bytes (568 MB) SHA256: 35E049A3AE9C6A32B1E3446018C0DFA916E18EADF319D97567F6CB7FE6...
In Development, Documentation, Oct 26, 2018Microsoft Best Practices for Securing Active Directory
https://technet.microsoft.com/en-us/windows-server-docs/identity/ad-ds/plan/security-best-practices/best-practices-for-securing-active-directory
In Administration, Documentation, Security, Sep 02, 2016Policy Analyzer
Today I found a tool, that can be very useful, if you need to identify changes made to e. g. the "Default Domain Policy". Here is the Link: Policy Analyzer
In Administration, BPA, Documentation, Security, Jun 21, 2016Documentation of a given infrastructure
Getting the same information from every pc especially in a very complex and grown environment can be a tedious work. So why don't just call a script to help out ;-) # Network Driv...
In Administration, Documentation, PowerShell, Jan 26, 2016BPA
Policy Analyzer
Today I found a tool, that can be very useful, if you need to identify changes made to e. g. the "Default Domain Policy". Here is the Link: Policy Analyzer
In Administration, BPA, Documentation, Security, Jun 21, 2016SMB: Short file name creation should be disabled
If the Best Practive Analyzer is showing this error, you can disable the 8dot3 Names by running the following commandsInvoke-Command -ComputerName $ServerName -ScriptBlock { fsutil b...
In BPA, PowerShell, Feb 11, 2016Srv.sys should be set to start on demand
If the Best Practice Analyzer is showing this error, you have to run the command: Invoke-Command -ComputerName $ServerName -ScriptBlock { cmd /C "sc config srv start=demand" Get-...
In BPA, PowerShell, Feb 11, 2016VPN
VPN Connection and Device Authentication
Automatically establish a VPN connection if a specific application is launched. So your users cannot forget to launch it first and will not call you therefor ;-) Add-VpnConnectio...
In Administration, PowerShell, Security, VPN, Feb 25, 2016Mailserver
outlook.com manual configuration Outlook 2016
Select Exchange or outlook.com mail address and enter the following details: E-Mail Address: your-mail@live.de or your-mail@outlook.com (your https://www.outlook.com mail address...
In Mailserver, May 22, 2016PowerShell send E-Mail
Without smtp Server Authentication (with static IP or internal Mail Server) Note: Most public mail servers only accept a message for there users and don't forward it to other serv...
In Mailserver, PowerShell, Mar 24, 2016Status Monitoring
Here is a code sniped to monitor your servers. In the first example the result is simply written into a CSV-File, but in the second a e-mail is sent. Import-Csv -Path ".\IP-List.t...
In Mailserver, PowerShell, Security, Mar 24, 2016Development
Fix Loud Fan Win10 Dell Notebook
My Dell notebook was making very loud fan noises as soon as it was connected to the dock. I already suspected the windows powerplan settings from the start, but MS decided to clear ...
In Development, Documentation, PowerShell, Fan, Windows 10, Oct 13, 2023Merging dictionaries within powershell
I needed to join dictionaries from within a list together, so that they become one whole dictionary. First I thought it may be a trivial task. Than I used google and realized, that ...
In Development, Documentation, PowerShell, Sep 01, 2020shadow compile error
when compiling shadow there is an error in the cross linux from scratch documentation. instead of echo "#define ENABLE_SUBUIDS 1" >> config.h one has to run echo "#defi...
In Development, Feb 04, 2020gcc compile error
when compiling gcc 4.8 for cross linux from scratch it throws this error: gcc-4.8.2/gcc/doc/gcc.texi:88: warning: @tex should only appear at the beginning of a line gcc-4.8.2/gcc/...
In Development, Feb 04, 2020ncurses5.9 compile error
When building cross linux from scratch ncurses 5.9 does fail to compile with: gcc -DHAVE_CONFIG_H -I../ncurses -I. -D_GNU_SOURCE -DNDEBUG -I. -I../include -I/foo/include/ncurses ...
In Development, Feb 04, 2020m4 1.4.17 fails to compile
While following the cross linux from scratch instructions over here I ran into this issue: freadahead.c: In function 'freadahead': freadahead.c:91:3:error: #error "Please port gnu...
In Development, Linux, Feb 04, 2020Profiling Python
In Development, Python, May 04, 2019Install Selenium
Install Selenium: function Install-PSArchive { param() $null = Install-PackageProvider -Name PowerShellGet -Force -Scope CurrentUser Install-Module -Name 'Microsoft.PowerShell.Ar...
In Administration, Development, PowerShell, Security, Webserver, Dec 19, 2018Bypass chrome tls security checks
Normally things like invalid certificates throw an error within google chrome, and if the page has HSTS in place, there is no way to bypass that error. For normal users this is a goo...
In Administration, Development, Security, Webserver, Dec 19, 2018Windows protocols
Technical Documents All pdf protocol documentations Name: Windows_Protocols.zip Size: 595648189 Bytes (568 MB) SHA256: 35E049A3AE9C6A32B1E3446018C0DFA916E18EADF319D97567F6CB7FE6...
In Development, Documentation, Oct 26, 2018PowerShell access private fields and properties
Using the poke module it is possible to access private and internal fields of objects you would otherwise not be able to.Example# peek at a Job instance using pipeline syntax$job = st...
In Development, PowerShell, Aug 19, 2016XLSX (Excel Api)
LINK: https://www.nuget.org/packages/ClosedXML/ Project Site: https://closedxml.codeplex.com/ Showcase: https://closedxml.codeplex.com/wikipage?title=Showcase&referringTitle=Home
In Development, Aug 15, 2016VisualStudio import Templates
Place the template project in "%UserProfile%\MyDocuments\Visual Studio %VERSION%\Templates\ProjectTemplates\" Place the template items in "%UserProfile%\MyDocuments\Visual Studio ...
In Development, Apr 10, 2016PowerShell and SQL Server
To be able to use the "sqlps" PowerShell Module you first need to install it from here. SQLSysClrTypes.msi - CLR Types for SQL Server SharedManagementObjects.msi - Shared Man...
In Administration, Development, PowerShell, SQL, Apr 10, 2016SQL
MSSQL on kubernetes (non azure)
Copy the code below into a file named mssql.yaml Apply the deployment file to your kubernetes cluster using:sed -i s/TXlDMG05bCZ4UEBzc3cwcmQ=/$(pwgen -s 120 1 | base64 -w 0)/...
In Administration, Linux, SQL, k8s, Mar 14, 2020PowerShell and SQL Server
To be able to use the "sqlps" PowerShell Module you first need to install it from here. SQLSysClrTypes.msi - CLR Types for SQL Server SharedManagementObjects.msi - Shared Man...
In Administration, Development, PowerShell, SQL, Apr 10, 2016Mobile Broadband
Mobile Broadband Modem and PuTTY
Find the right com-Port. Go to control panel, telephone and modem, modems. Here you have your com-port. For the baud rate go to Settings and Modem after selecting the correct mode...
In Administration, Mobile Broadband, Apr 16, 2016LVM
Encrypted LVM remote unlock
Sometimes you want to have a strong Disk encryption but be still able to unlock it remotely. Sure, this is a compromise between security and usability, but here is what I come up wit...
In Administration, Linux, LVM, Security, Jul 24, 2017Video editing
Add chapters to mp4
Get the frame rate of your source video (assuming you have 30fps and the video is called input.mp4 for later steps) Calculate Timebase value Timestamp fps*1000 =...
In Video editing, May 26, 2018Python
Profiling Python
In Development, Python, May 04, 2019nginx
Wordpress nginx config
server { listen 80; listen [::]:80; root "/var/www/vHOST"; server_name vHOST; index index.html index.php; client_max_body_size 2G; rewrite ^/wp-json/.*$ index.php$uri last; ...
In Administration, Documentation, Webserver, WordPress, nginx, May 04, 2019Uncategorized
Twitter hack lessons learned
I'm not an twitter employee, but the recent "twitter hack" has shown some valuable lessons that everybody can learn from it. It is funny (and shocking) to read about how bad twit...
In Uncategorized, Aug 05, 2020Compile Linux Kernel for UBNT UNIFI
Download Cavium Open Source Distributions Octeaon SDK Former: https://web.archive.org/web/20190215075110/https://github.com/Cavium-Open-Source-Distributions/OCTEON-SDK ...
In Uncategorized, Feb 02, 2020k8s
MSSQL on kubernetes (non azure)
Copy the code below into a file named mssql.yaml Apply the deployment file to your kubernetes cluster using:sed -i s/TXlDMG05bCZ4UEBzc3cwcmQ=/$(pwgen -s 120 1 | base64 -w 0)/...
In Administration, Linux, SQL, k8s, Mar 14, 2020Story
Dream
Fan
Fix Loud Fan Win10 Dell Notebook
My Dell notebook was making very loud fan noises as soon as it was connected to the dock. I already suspected the windows powerplan settings from the start, but MS decided to clear ...
In Development, Documentation, PowerShell, Fan, Windows 10, Oct 13, 2023Windows 10
Fix Loud Fan Win10 Dell Notebook
My Dell notebook was making very loud fan noises as soon as it was connected to the dock. I already suspected the windows powerplan settings from the start, but MS decided to clear ...
In Development, Documentation, PowerShell, Fan, Windows 10, Oct 13, 2023Featured
-
Twitter hack lessons learned
In Uncategorized, -
shadow compile error
In Development, -
gcc compile error
In Development, -
ncurses5.9 compile error
In Development, -
m4 1.4.17 fails to compile
In Development, Linux, -
Hacking an SQL-Server
In Administration, Security, System recovery, -
Encrypted LVM remote unlock
In Administration, Linux, LVM, Security,