Posted inWordPress
Are you in my blocklist?
Is your IP address in my WordPress .htaccess block list? Here are IP addresses I block manually because of comment spamming.
Posted inWindows Server
Create an additional SQL Server Login
Here is a small T-SQL snippet that creates an additional (extra) SQL Server Login (User) for contained databases in SQL Server. It sets memberships too.
Posted inWindows Server
Monitor SQL Server and databases in depth using Zabbix
Monitor Microsoft SQL Server, databases and performance with Zabbix, PowerShell, Performance Counters and WMI. Keep SQL Server and databases in top shape and performance up! In this post I show you how you can use Zabbix to monitor those important aspects for database administrators (DBA).
Posted inWordPress
Query all WordPress posts in MySQL not having a Yoast SEO meta description
Here is a query you can use to query all posts in WordPress not having a Yoast SEO meta description yet. You can run this on your MySQL prompt or in phpMyAdmin.
Posted inWindows Server
Configure Windows Debugging Symbols in WinDbg
Before you can properly debug crash and memory dumps in Windows (Windows 11, Windows 10, Windows Server), you need to install WinDbg -Windows Debugger- and its debugging symbols. In this article I explain how to set up these debugging symbols for WinDbg in Windows. Debug BSOD like a boss!
Posted inWindows Server
Extract files from an MSI package
To extract all files from a .msi file, use the following msiexec command and arguments. Windows has the ability to allow the MSI package (.msi file) contents to be extracted using the command line or via a script.
Posted inWindows Server
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 over ssh (qemu+ssh://) in Windows using Windows 11 and WSL 2. This setup allows you to connect to virt-manager through an ssh tunnel and an arbitray port through a bastion host and ssh key authentication.
Posted inWindows Server
Windows 11/10 and WSL 2 DevOps environment
In this post I showed you how you can turn Windows 11 and Windows 10 with WSL into a fully fledged development environment. Here are the settings and tools I use for DevOps/SysOps on Windows. It may take some getting used to, but if you're as shortcut-Ninja as I'm (I alt-tab, ctrl-c/ctrl-v a lot), you can work pretty fast in this set up.
Posted inWindows Server
YubiKey support in OpenSSH for Windows 11 and Windows 10
Configure and use YubiKey security keys with Microsoft OpenSSH in Windows Server, Windows 11 and Windows 10 to support FIDO/U2F devices.
Posted inGNU Linux
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 the full username in Bash ps, here is how.
Posted inWindows Server
Monitor .NET CLR Garbage Collected heap from your web application
Use Zabbix to monitor your web application and application pool's .NET CLR Garbage Collected heap by utilizing WMI and PowerShell. Keeping track of .NET memory usage enables you to optimize usage and performance further.
Posted inWindows Server
Quickly check EnableTrailerSupport isn’t set in your network for http.sys (CVE-2022-21907)
Find out fast if your IIS webservers have EnableTrailerSupport enabled for https.sys. Here is a small PowerShell method to check the Windows registry.
Posted inWeb applications
Convert SqlCe database to SQL Server
Learn how to convert an SQL Server Compact (SQL CE) database to an SQL Server database. Because the SQL CE database type is unsupported, it’s recommended by Microsoft to upgrade to SQL Server. But how do you convert your SqlCe database?
Posted inUmbraco
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. Here on Sysadmins of the North, I wrote about "11+ tips to optimize Umbraco CMS" earlier, and in this post I write about implementing them. On a just installed and running website.
Posted inWeb application security
3 Ways of blocking sendmail.php on IIS webserver
Use IIS URL Rewrite Module and Request Filtering in IIS to block access to certain scripts. Sendmail.php for example. To prevent sending spam.