Optimize all MySQL tables with PHP/MySQLi multi_query
The PHP MySQLi extension supports multiple queries, which are concatenated by a semicolon, with `mysqli->multi_query`. We use this to optimize all MySQL tables, in a single multi-query statement. Neat! Optimizing MySQL tables is important to keep tables small and fast. This boosts MySQL, PHP and website performance and we all love that, don't we? :)
How to load google-code-prettify syntax highlighting without plugins
If you run a WordPress blog where you display (parts of) source code, syntax highlighting is a must! It prettifies the code which makes it easier to read and it distinguishes code from text. However, most syntax highlighting is made available through plugins, and we all know too many plugins bring a lot of overhead to your blog.
Configure SQLServer sessionState for Umbraco
This post explains how to prepare your Umbraco website for a high performance web garden or web farm, and load balancing environments.
Clean-up WordPress spam comments and meta data
How to delete WordPress spam comments and meta data with phpMyAdmin. A lot of WordPress spam comments and meta data will keep your WordPress database huge, and slows down your site. It's best to delete spam comments regularly, but if you're facing hundreds of thousands spam comments, here is how to delete them all in bulk.
Add (custom) headers to MailMessage class
System.Net.Mail sometimes lacks important email headers like the Message-Id. This post shows you how to add them and improve email delivery from websites.
Install Node.js, iisnode module and Ghost on Windows Server / IIS
This post describes the steps necessary to install Node.js and Ghost Publishing Platform on Windows Server IIS. Ghost is a Node.js web application, specific for just blogging. To run Node.js applications in IIS, you need iisnode as a module. Here is how to install all of this.
Ssh shorthand name for hostnames
How to use shorthand names for hostnames with ssh? You don't always want to type in a complete host name when using ssh to remote hosts. Here is how to configure and use shorthand hostnames with ssh.
Target multiple ASP.NET versions with AppCmd.exe
Did you know you can target both x86 and x64 versions of ASP.NET with AppCmd.exe?
Optimize images for the web in bulk
Optimizing and lossless compressing images is one of those items that always pops up when analyzing your website with Google PageSpeed Insights. Images have to be lossless compressed to save many bytes of data and thus bandwidth. But, how do we optimize images for the web?
Mount an Open-Xchange InfoStore on Linux
Open-Xchange is an all-in-one Groupware solution, providing not only email, but also a CalDAV calendar, tasks, file- or InfoStore and an online document editor. All shareable with other users. The InfoStore is used to save documents online, in the cloud. This article is about accessing and mounting your Open-Xchange remote WebDAV InfoStore file share, on Linux with mount.davfs or Dolphin GUI file manager.
Forfiles: How to delete files recursively on Windows Server
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.
Block WordPress comment spammers manually
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 fix Joomla HTTP 500 errors after updates
Here is how to resolve Joomla HTTP 500 errors after applying updates
Add websites and application pools to IIS with PowerShell, in a for loop
How to use Powershell to create websites and application pools in IIS
Windows Live Mail error 0x80041161 (Fix)
After not using Windows Live Mail for quite some time, it gave me an error code 0x80041161. This Windows Live Mail error can have several different reasons, like corrupt files or services that aren't started, not easing the task of identifying the cause. Read on to learn how to fix this Windows Live Mail error 0x80041161...