Jan Reilink 
Windows Server
Last updated:
A manual SQL Server failover can only be initiated from the principal server, and the mirrored database must be synchronized (that is, when the database is in the SYNCHRONIZED state). In this article I will show you how to manual failover mirrored SQL Server databases using Transact-SQL (T-SQL) in SQL Server 2017 and up.
Codebase
Last updated:
Modern connection string examples for ASP.NET Core, Legacy ASP.NET, and Classic ASP. Learn how to use MSOLEDBSQL, ODBC 18, and fix MySQL UTF-8/Emoji support.
Codebase
Last updated:
Whenever you need to test your ASP.NET connection to your MySQL database, using ODBC, you can use the following C# test script. Currently it uses MySQL ODBC 8.0 Unicode Driver, but you can easily change the version used
Web applications
Last updated:
Connect securely to your MySQL database using PHP Data Objects (PDO); Here is how to connect to MySQL with PHP PDO using SSL.
Windows Server
Last updated:
3 unique methods to list Service Principal Names (SPNs) in your Windows network quickly using PowerShell. An SPN or Service Principal Name is a unique identity for a service, mapped with a specific account (mostly service account).
Windows Server
Last updated:
If a Windows Server 2016 guest VM on Hyper-V hangs while stopping after Windows Updates, and it won’t reboot, it might be caused by the recovery debug information type set. Especially when you have moved the Windows PageFile to a different partition / VHDX
WordPress
Last updated:
How to increase the memory limit for your WordPress website, the right way. In this post I show you a correct way of setting WordPress WP_MEMORY_LIMIT and PHP memory_limit settings to improve Wordpress speed & performance.
Windows Server
Last updated:
Users can install and run multiple .NET Framework versions on their computers. When you develop or deploy your app, you might need to know which .NET versions are installed on a machine and here is how to check the .NET version.
GNU/Linux
Last updated:
The postsuper command controls different types of queues in the Postfix mail system, like the deferred or hold queue. This post shows you some Postfix queue operations to maintain your mail servers.
Windows Server
Last updated:
Compressed SQL Server backups can be verified in PowerShell using a handy PowerShell function. This comes in handy when you need to verify if existing SQL Server backups are compressed.
Windows Server
Last updated:
Unzip a file on your PowerShell command-prompt may come in handy sometimes, even on your Windows 11/10 workstation. Use Expand-Archive for this, and all that is required is PowerShell 5.0+, or the .NET 4.5+ Framework to use System.IO.Compression.ZipFile.
GNU/Linux
Last updated:
Learn how to restore a single table from a full MySQL mysqldump backup file using Bash shell in Linux
WordPress
Last updated:
How to protect your WordPress from brute-force XML-RPC attacks, because the WordPress XML-RPC API has been under attack for many years now.
Windows Server
Last updated:
WSUSPool keeps stopping? Sometimes you find your WSUS server keeps crashing over and over again. The WSUS application pool periodically stops, WSUS is unavailable and/or the WSUS management console hangs.
WordPress
Last updated:
Remove Jetpack email sharing service using WordPress plugin or theme functions.php file. It’s often abused by spammers
Windows Server
Last updated:
In this post I address four (4) important actionable security measures for your servers running Windows Server (AD DS, DFS, IIS) and RDP.
Windows Server
Last updated:
It is urged you disable SMBv1 in your Windows variant (Windows 10, 8.1, Server 2016, 2012 R2), and here is how if you haven’t done so yet.
Windows Server
Last updated:
Being able to detect the ethernet network speed using PowerShell or WMI is perfect for Windows Server Core. If you ever need to lookup the speed of your ethernet network card in Windows, on the command-prompt, use one of the following PowerShell / WMIC commands.
WordPress
Last updated:
Check WordPress integrity and verify WordPress Core files’ md5 checksums against WordPress’ checksums API, using this standalone PHP file.
Windows Server
Last updated:
Windows Server 2016 was released last week, meaning we can finally lift the idiotic 260 characters limitation for NTFS paths. For this, you use a GPO or Group Policy Object in Windows Server.