Posted inCode base
How to use SSL in PHP Data Objects (PDO) mysql
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.
Posted inWindows Server
Windows Server 2016 on Hyper-V stuck at stopping
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.
Posted inWordPress
Increase WordPress’ memory limit WP_MEMORY_LIMIT properly in wp-config.php
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.
Posted inWindows Server
List all SPNs used in your Active Directory
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.
Posted inWindows Server
Important note about Windows Update KB4056892
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:
Posted inWindows Server
How to: Determine which .NET Framework versions are installed
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.
Posted inPowerShell
How to unzip a file in PowerShell
Unzipping a file on your PowerShell command line may come in handy sometimes, even on your Windows 10 workstation. Use Expand-Archive for this
Posted inMySQL
Restore single MySQL table from a full mysqldump backup file
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.
Posted inGNU Linux
Release hold queue email in Postfix – postsuper
Flush and delete the hold queue in Postfix or delete all mail from the deferred queue with Postfix postsuper command as explained in this post.
Posted inPowerShell
How to determine if a SQL Server backup is compressed?
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.
Posted inWindows Server
How to turn off the TLS default in FileZilla?
Here is how to disable TLS encryption in FileZilla and turn off the FTP over TLS default setting. Connect plain FTP without TLS.
Posted inWeb application security
Protect WordPress from brute-force XML-RPC attacks
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.
Posted inWindows Server
WsusPool keeps crashing: stops again and again
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.
Posted inWordPress
Remove Jetpack email sharing service
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.
Posted inWindows Server
Merge multiple files into one new file in Windows
Merge or concatenate multiple files into one new file in Windows using the copy command in cmd.exe. Here is how.