Recent posts

A quick way to recursively scan a folder and remove Thumbs.db thumbnail caches.

In the UK, “bank holiday” is the commonly used term for both bank and public holidays; The days on which most businesses and non-essential services close. Most companies when measuring and reporting on activity, want to know how weekdays, weekends and bank holidays affect their performance. Depending on where in the UK you are and what period you are reporting for this can be tricky with the bank holidays changing several times over the last hundred years.

SELECT [IsGeneric] = (CASE WHEN [BNFCode] LIKE '_________AA____' THEN 1 ELSE 0 END) ,[GenericMask] = CONCAT(LEFT([BNFCode], 9), 'AA', RIGHT([B].[Code],2), '__')

An interesting article on the pros and cons of various rate limiting methods and an alternative approach which you may not have considered.

Simple Regex for dissecting SNOMED-CT Codes into their subparts, useful for validation.