Connect securely to your MySQL database using PHP Data Objects (PDO) and SSL/TLS; Here is how to connect to MySQL with PHP PDO using an SSL encrypted connection.
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.
How to increase the memory limit for your WordPress website, the right way. The WordPress memory limit can be increased by the WP_MEMORY_LIMIT variable in wp-config.php. However, I see this done wrong over and over again in WordPress plugins and themes. In a worst case scenario this may even decrease the available amount of memory for WordPress! So be careful with the advice you follow. In this post I show you a correct way of setting WordPress WP_MEMORY_LIMIT and PHP memory_limit settings.
A service principal name (SPN) is a unique identifier of a service instance. Listing duplicate SPNs is fairly easy, but how do you find out which SPNs are used for which users, computers and services? Start troubleshooting SPNs here and learn how to use setspn.exe to list all SPNs used in your Active Directory.
There is another VERY IMPORTANT THING with Microsoft Meltdown patches like update KB4056892: - Customers will not receive these security updates and will not be protected from security vulnerabilities unless their anti-virus software vendor sets the following registry key:
To get an accurate list of the .NET Framework versions installed on a computer, you can view the registry or query the registry in code. Note that the .NET Framework consists of two main components, which are versioned separately. Here is how to list installed ASP.NET versions using PowerShell.
Here are the steps required to restore a single MySQL table from a full mysqldump database backup file on the command-line. If you need to restore a single table from a full MySQL backup, you may find yourself wondering "how do I do that?". There are a few steps required, I outline them here for you to restore the contents of just one table back into the database from the mysqldump using Bash.
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.
Secure WordPress against XML-PRC attacks. This post gives you some insights about how you can create an IP whitelist for xmlrpc.php, on Windows Server and Linux Apache (web.config and .htaccess). And how you can block access to xmlrpc.php file.
Is Windows Server Update Services (WSUS) slow or is WSUSPool application pool constantly crashing or restarting? Are client computers checking for Windows Update erroring out with code 0x80244021? This indicates the client is unable to reach WSUS. Here is how to improve Windows Server Update Services (WSUS) availability.
Recently the WordPress Jetpack email sharing service is often abused by spammers. They use the Send to Email Address for sending spam. All these kind of "Tell a Friend" scripts are abused a lot. Here is how to disable email share service in Jetpack.