Query all WordPress posts in MySQL not having a Yoast SEO meta description
Query all posts in WordPress not having a Yoast SEO meta description yet. You can run this on your MySQL prompt or in phpMyAdmin
Jan Reilink
In my day to day work, I’m a systems administrator – DevOps / SRE and applications manager at Embrace – The Human Cloud. At Embrace we develop, maintain and host social intranets for our clients. Provide digital services and make working more efficient within various sectors.
Configure Windows Debugging Symbols in WinDbg
Set up debugging symbols for WinDbg in Windows and debug BSOD like a boss.
Extract files from an MSI package
Windows has the ability to allow the MSI package (.msi file) contents to be extracted using the command line or via a script. I keep forgetting the correct msiexec.exe syntax to use to extract files from an .msi file (MSI package), so here is a short post with the command.
Connect to a KVM host through an ssh tunnel and arbitrary port in Windows 11 and WSL 2
Connect virt-manager to a KVM host through an ssh tunnel and arbitrary port in Windows using Windows 11 and WSL 2.
Windows 11 and WSL 2 DevOps environment
In this post I describe some of the settings and changes I made to make my Windows 11 and Ubuntu WSL2 into a fully fledged development environment. Here are the settings and tools I use for DevOps / SysOps on Windows.
YubiKey support in OpenSSH for Windows 11
In this post, I’ll show you how to properly install Microsoft OpenSSH client in Windows 11 and Windows 10, and how to configure your YubiKey.
How to display longer username in ps
Display full username in ps. The ps output truncates usernames to 7 characters and a +. If you need full usernames in Bash ps, here is how.
Monitor .NET CLR Garbage Collected heap from your web application
Whether you run a .NET web application or administer a webserver that hosts .NET web applications, it is important to keep an eye out for memory usage. As developers and systems administrators we're all too familiar with OutOfMemoryException. As the name suggests, the exception is thrown when a .NET application runs out of memory, something you don't want to happen.
Convert SqlCe database to SQL Server
How can I convert an SqlCe database to Microsoft SQL Server?
How to optimize Umbraco 8 performance
Out of the box, Umbraco is a well built and pretty fast content management system. However, it is still important you perform some steps to further optimize Umbraco's performance and loading speed.
3 Ways of blocking sendmail.php on IIS webserver
Here are 3 ways of blocking access to a PHP sendmail.php script on your Windows Server IIS webserver. This comes in handy if a websites on your webserver sends out spam and you need to block access to a script on a specific website or globally in IIS.
Add VirtIO drivers to Windows Recovery Environment (Windows RE)
Learn how to add VirtIO drivers to your Windows Recovery Environment (Windows RE) to recover your Windows virtual machines. Using Powershell of course and Windows Server 2022.
Retrieve SSH public key from Active Directory for SSH authentication
If you have tens (hundreds) of servers and/or users it's easier to retrieve user SSH public keys from Active Directory (AD) than from various unmanaged authorized_keys files.
Install SQL Server cumulative updates silently
Learn how to install SQL Server cumulative updates (CU) silently using PowerShell opposed to the cumbersome task of running the GUI installer.
Add, list and remove IP addresses in Windows Firewall
How to bulk add IP addresses in Windows Firewall, list an IP address and how to remove all IP addresses from Windows Defender Firewall with Advanced Security
Block brute force attacks on SQL Server, block IP addresses in Windows Firewall using PowerShell
For the time being, some manual labor is involved, but it is still manageable. You can use this to create your own solution to block offending IP addresses in SQL Server’s firewall.
How to enable HTTP/3 in Windows Server 2022
Native support for HTTP/3 in Windows Server 2022, jeej! Host HTTP/3 web services in Windows
Windows Defender: Turn off routine remediation (DisableRoutinelyTakingAction)
Turn off Windows Defender routine remediation using a GPO setting called “DisableRoutinelyTakingAction”. This policy setting allows you to configure whether Microsoft Defender Antivirus automatically takes action on all detected threats.
How to share OpenSSH keys with WSL in Windows
Here is how you can share your SSH keys between Windows 11/10 and WSL 2 if you don't want to copy over your ssh keys from Windows to WSL 2 Linux, or generate new ones.
Increase WMI memory to support large volume of queries
Learn how to fix memory issues and subsequent crashes in WMI / WmiPrvse.exe by increasing available memory and handles
