Codebase
Last updated:
Connect to multiple MySQL servers in a for and foreach loop
Check the connectivity of multiple MySQL servers, and connect to the servers in a loop. Here are two example code snippets
Windows Server
Last updated:
Target multiple ASP.NET versions with AppCmd.exe
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!
Codebase
Last updated:
Test MySQL database connectivity with MySql.Data.MySqlClient
MySql.Data.MySqlClient ASP.NET test script
GNU/Linux
Last updated:
Split Comma Separated Values (csv) fields with VIM or sed
Split a csv field into two fields using Vim and print or delete csv fields with AWK/Gawk (how to)
Codebase
Last updated:
Asynchronous PHP calls with XMLHttpRequest
Async PHP calls with XMLHttpRequest
Web applications
Last updated:
Optimize images for the web in bulk
Lossless compress and optimize hundreds of PNG images for the web in bulk, using OptiPNG on the Windows command line.
GNU/Linux
Last updated:
Mount an Open-Xchange InfoStore on Linux
How to access and mount your Open-Xchange WebDAV InfoStore (OX Drive) on Linux with mount.davfs, or in a file manager like Dolphin.
Codebase
Last updated:
Optimize all MySQL tables with MySQLi multi_query
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.
Windows Server
Last updated:
Delete files recursively with ForFiles in 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.
WordPress
Last updated:
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.
Web applications
Last updated:
How to fix Joomla HTTP 500 errors after updates
Here is how to resolve Joomla HTTP 500 errors (0x8007000d) on IIS after applying Joomla updates, by fixing the database from the back-end.
Codebase
Last updated:
Add websites and application pools to IIS with PowerShell, in a for loop
How to use PowerShell to add websites and application pools in IIS
Windows Server
Last updated:
Create your own CDN using IIS Outbound Rules
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.
GNU/Linux
Last updated:
Bash: Grep through a large number of files - "Argument list too long"
/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.
WordPress
Last updated:
WordPress CMS admin password reset
Lost or forgotten your WordPress admin password? Reset it with a MySQL query, through functions.php over FTP, or with the lost password feature.
Web applications
Last updated:
Fix "Could not establish trust relationship for the SSL/TLS secure channel" error
Fix "System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." in ASP.NET on IIS
Windows Server
Last updated:
ASP.NET performance: what to keep in mind
Valuable articles about ASP.NET performance I frequently pass on to customers, so they can improve their ASP.NET web applications.
Useful
Last updated:
Don't turn off CURLOPT_SSL_VERIFYPEER and fix your PHP configuration
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.
GNU/Linux
Last updated:
Installing Debian GNU/Linux 7.0 (Wheezy) on HP EliteBook 8570w
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.
Web applications
Last updated:
Connect to SqlCe (SQL Server Compact) database from ASP
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.