CodeFirst (@code_first) header
CodeFirst (@code_first) profile picture

CodeFirst is a UK software company that maintains, takes over and modernises business software. We also build new systems at a fixed price.

United Kingdom
Joined August 2013
You can modernise a core system without switching it off. Replace one capability at a time, keep old and new on the same database, and make every step reversible. The hard part is choosing which capability goes first.
1
13
When was your nightly backup last restored, rather than just taken? Preventive maintenance is the type most often skipped, because nothing appears to be wrong.
1
4
A database upgraded to SQL Server 2019 from 2008, 2012 or 2014 may still run at its old compatibility level. Worth checking before the next upgrade, and worth testing on its own when you raise it.
1
4
No tests on your old system? Run last month's real orders through it, save the invoices, and compare after every change. Any difference is either intended or a regression. Someone has to say which.
1
2
NCSC: update PHP now. Two critical flaws can allow unauthenticated remote code execution. Fixes are in 8.5.12, 8.4.27, 8.3.36 and 8.2.35. Anything on PHP 8.1 or older has no simple update. #PHP
1
37
SQL Server 2014 is in the final year of paid Extended Security Updates. They end on 12 July 2027, and there is no further year to buy. A database migration is easier to plan in October than in June.
9
Is the contractor who wrote your system retiring? Don't ask them for documentation. Have whoever takes over build, release and restore the system with them before their last day. The questions that come up are what no document captures.
1
6
Restoring the database is not the whole SQL Server upgrade. Agent jobs, SSIS packages, Reporting Services reports, linked servers and logins sit outside it and do not come across on restore. List them first.
1
14
.NET Framework 4.6.2 stops getting security fixes on 12 January 2027. Versions 4.7 to 4.8.1 remain supported for as long as the Windows version they run on. Worth knowing which one your older apps target.
1
1
14
Paying for bespoke software does not make you its owner. In the UK, copyright stays with the supplier unless a written, signed agreement assigns it to you. Worth checking before you need to change supplier.
1
3