The latest in tech, SysOps, personal growth, scripting, servers, virtualization and databases curated for you daily.
Jan Reilink 
MySQL's mysqlcheck is a command line table maintenance program: it checks, repairs, optimizes, or analyzes tables. Very handy for automated performance optimizations of MySQL databases and tables.
On IIS, Contact Form 7 captcha has one HUGE disadvantage: temporary captcha files placed in wp-content/uploads/wpcf7_captcha, are not automatically removed. Here is how to remove Contact Form 7 temporary captcha files on IIS…
Change file attributes with PHP chmod to make files read-only or normally accessible on Windows Server IIS.
The System.Net.Mail Namespace leaves out the required Message-ID header in email. Here is how you can add this important header to your email, to make sure email arrives.
Configure Umbraco for SQLServer sessionState storage and prepare Umbraco for high performance web garden or web farm, and load balancing environments. This post explains it all.
Check the connectivity of multiple MySQL servers, and connect to the servers in a loop. Here are two example code snippets
Address both x86 and x64 versions of .NET with AppCmd. When administering an IIS web server you frequently have to use AppCmd.exe to make configuration changes. Whether it is for a specific web site or server wide. Some think AppCmd is very limited, but here is how you can target multiple ASP.NET versions with AppCmd!
MySql.Data.MySqlClient ASP.NET test script
Split a csv field into two fields using Vim and print or delete csv fields with AWK/Gawk (how to)
PHP MySQLi extension supports multiple queries which are concatenated by a semicolon. We can use this to optimize all MySQL tables in one single multi_query statement.
The Forfiles command on Windows selects and executes a command on a file or set of files. Forfiles is ideal for batch processing through scripts, for instance on Windows Server systems. With Forfiles, you can run a command on or pass arguments to multiple files. For example, you could run the type or del command on all files in a tree with the .txt extension.
The less spammers hit your WordPress blog, the better your blog performs, is one of my opinions. A second is, the less unnecessary plugins you use on your WordPress blog, the better. So, a little while ago I decided to remove plugins like Stop Spammer Registration Plugin and do its work myself.
How to use PowerShell to add websites and application pools in IIS
Use IIS Outbound Rules and URL Rewrite Module to create a custom created Content Delivery Network (CDN) for static content ofloading and speed-up your website.
/bash/grep and /bash/rm give me an error Argument list too long. Here is how to overcome this error with Bash grep and rm.
Learn how to fix your PHP config instead of turning off CURLOPT_SSL_VERIFYPEER in php.ini and overcome certificate validation errors with cURL and PHP.
I was FedUp with Fedora Core 17/18 after a day, so I decided to return to my old love: Debian GNU/Linux. It's been a couple of years, but I'm happy to be back! Just run the netinst installer which will take care of the most.
Here is how to install the Microsoft.SQLSERVER.CE.OLEDB.4.0 Provider and use classic ASP to connect to an SqlCe (SQL Server Compact) database sdf file, as a Microsoft Access database replacement.
How to use GnuWin32 ported tools like grep.exe and find.exe for forensic log file analysis in Windows Server. Find webshells and backdoors in websites, check visitor's IP addresses or hits to backdoor/webshell files in IIS log files easy. Command-line log analysis in Windows Server, search for Joomla-, WordPress-, Drupal- and PHP- malware & backdoors in your website with grep and find.