How to disable WordPress updates
By default WordPress will automatically install minor updates - for example, 5.0.0 -> 5.0.1. This can be disabled in a number of ways - but remember, if you do this…
Date
SQL – How to copy column data to another column
The following SQL statement shows how to copy the data from one column to another. It will replace any existing values in the destination column - so be sure to…
How to install Adobe Reader XI silently using SCCM
The following process shows how to create a silent install of Adobe Reader DC for distributing with a software distribution tool like SCCM. It was last tested with Adobe Reader…
Crystal Reports – How to convert text date to datetime format
Text of dates in Crystal Reports can be annoying - you can't apply any date-specific formatting or use the date in formulas - because it is after all, just the…
Crystal Reports – How to calculate financial year from date
The following code shows how to calculate the financial year from a date in a Crystal Reports. It uses the Australian financial year which is from July to June, e.g.…
SQL – How to convert line separated text to comma separated
The following T-SQL for Microsoft SQL Server shows how to convert line separated text to comma separated text. For example, if we had a table with the following data Lucky_Numbers 2 33…
SQL -Find and replace text in string
The following T-SQL for Microsoft SQL Server shows how to find and replace text in a string. In this example we'll change "PO Box" to "P.O. Box". The REPLACE function will search for…
Excel 2016 – How to calculate age from date of birth
The following formulas show how to calculate current age from a date of birth. Calculate age in years This formula will calculate the current age in full years - for…
How to silently install iTunes
The following steps show how to create a silent install package for iTunes, for distribution with a software distribution tool like SCCM. The installer will install either the 32-bit or…