PowerShell Get-Command PSWindowsUpdate lists all available cmdlets within the PSWindowsUpdate module

Windows Server

Last updated:

Install Windows Updates using PowerShell

You can use PowerShell to install Windows Updates automatically, unattended and simple. Neat, right? For this, you don't have to have an enterprise environment with WSUS, or Windows Server, but since this is Sysadmins of the North, I assume you do. In this post I show you how to install Windows Updates with PowerShell and the PSWindowsUpdate module.

Codebase

Last updated:

Send email with PowerShell

Easily send your DevOps reporting using SMTP email with this PowerShell function, because the Send-MailMessage cmdlet is obsolete. Of course you'll be using StartTLS and authenticated SMTP as additional security.

Red and white barrier tape crossed over a metal fence

Useful

Last updated:

Are you in my blocklist?

With just a few manual steps you create your own little IP blocklist for WordPress in .htaccess or web.config. Here are the IP addresses I blocked.

Microsoft SQL Server logo

Windows Server

Last updated:

Create an additional SQL Server Login

Sometimes you need to create an additional SQL Server Login (user) for your database (databases). Here is a small T-SQL snippet that creates such a login for contained databases in SQL Server and adds memberships.

Microsoft SQL Server logo

Windows Server

Last updated:

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).

Windows Server

Last updated:

Extract files from an MSI package

How to extract MSI files without installing Windows Server 2022 (quick command-line method). Learn the definitive way to extract files from .msi packages using the msiexec /a switch, TARGETDIR, and PowerShell for automated deployments.

Spider

GNU/Linux, Web applications

Last updated:

Blocking bad bots and search engines using .htaccess

Take control of your server resources by learning how to block aggressive bots and unwanted search engines using .htaccess and mod_rewrite. This guide provides copy-paste ready configurations to prevent bandwidth theft, stop scrapers, and ensure that only relevant search engines crawl your website.

DevOps/SysOps Infrastructure as a Service flow

Windows Server

Last updated:

Windows 11 and WSL 2 DevOps environment

DevOps in Windows: 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.

Windows Server

Last updated:

YubiKey support in OpenSSH for Windows 11

YubiKey support in ssh for Windows: secure your Windows environment by moving SSH private keys to hardware. Learn how to configure YubiKey FIDO2/U2F support in native OpenSSH, manage the ssh-agent, and eliminate file-based credential risks.

Bash logo

GNU/Linux

Last updated:

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.

Umbraco

Last updated:

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.

Windows Server

Last updated:

3 Ways of blocking sendmail.php on IIS webserver

Block PHP files like sendmail.php on Windows Server IIS webservers. 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. Here are 3 methods.

Piranha CMS login screen

Web applications

Last updated:

How to extend TinyMCE in Piranha CMS?

In Piranha CMS you can easily extend the TinyMCE editor with additional plugins and toolbar buttons through editorconfig.json. Here is how.

Umbraco

Last updated:

How to add a trailing slash in Umbraco 8

Add a trailing slash to URL's in Umbraco 8, using IIS URL Rewrite Module, without breaking the Umbraco backend. Forcing one particular URL avoids duplicate content, which is important for SEO.