Computer Code Background

Dominic Rawle

C# ASP.NET Developer

SQL tricks

(‘|’ + RTRIM({COLUMNWITHDELIMITEDSTRING}) + ‘|’) LIKE ‘%|’ + {ITEM TO FIND} + ‘|%’

Recent Blog

2020-07-31

Auto-Formatting UK Postcodes and validation

If you were to ask a user to provide a postcode little or no validation on, you would probably find that a postcode such as OX26 6XE would end up as something like Ox266xe or ox2 66xe. For some applications, this maybe acceptable. But for others, especially when integrating with address APIs, formatting maybe crucial. […]

Read More…

2020-02-23

Improving MVVM INotifyPropertyChanged

With a project that uses MVVM (Model-View-View Model) design pattern, INotifyPropertyChanged is often used to detect a property value change in an object. This is particularly pertinent as far as creating a two-way data binding. Typical Implementation Normally, the INotifyPropertyChanged is implemented in a similar pattern to the code below. This is something that makes […]

Read More…

2020-02-23

Time-based One Time Password

A nice easy-to-use RFC-6238 based algorithm, that provides a HMAC-based One-Time Password authentication. The algorithm is based on one outlined in this article here. The interval is in seconds. It dictates how long before a TOTP expires. For example, if a TOTP is generated at 14:20 and the interval is 120 seconds. The TOTP will […]

Read More…

2020-01-10

Windows 10 stuck at loading screen under Apple OS Bootcamp

Recently, I had to tackle an issue with my Apple MacBook Pro that is running Windows 10 under Bootcamp, which I thought I would share in case anyone else finds themselves in a similar situation. Especially with the prospect of starting from scratch. One night I booted-up my MacBook and held down the shift key […]

Read More…