As you progress with your PowerShell skills you will find it necessary to understand the execution policies & permissions for PowerShell. At this stage, I am dealing with issues as…

A standard addition to any website is some kind of ability to contact the website owners. Whilst many have opted for the implementation of “chat” functionality, the tried-and-tested Contact form…

Here is my second attempt at copying folders using Microsoft PowerShell scripting. The task I need to accomplish is to copy a set of folders from a server to another…

Many of the computer labs are set up as follows: the learners log into a Windows server and a script sets up the PC they are working on with their…

The PHP system() function is used to execute an external program. Because MySQL already has a built-in tool for creating MySQL database backups, mysqldump, let’s use it from our PHP…

This is how to backup and restore a MySQL table using a PHP script. Please note: this is an old post and the scripts include deprecated PHP functions. Execute a…

Anyone who has spent any time working on a dev team will have some war stories to tell about code repositories. Managing large code-bases is a daunting task that requires…

If you have the Pinterest plug-in enabled in your browser as I do, when you hover over the image below a bright red Pinterest “Save” button will display in the…

After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up, this time with Microsoft Excel. This is how to dynamically…

I find Visual Basic for Applications (“VBA”) most useful in Excel. I have created many small enhancements to make my larger spreadsheets easier to use. Here follows a simple “Hello…