blog
My blog of techy stuff, ranging around SQL (SQL Server, that is), C# and .net, JavaScript and a smattering of stuff about the Orchard CMS (that powers my site) as I get more familiar with it. There's the occasional non-technical post when something is of interest to me that I feel is worth sharing, but they should be few and far between
-
Where does Certify put the certificate if you choose 'No Deployment' as the Deployment mode?
I've today (finally!) had cause to migrate a site to a Let's Encrypt SSL certificate, mainly because the incumbent provider is being somewhat useless when it comes to issuing the certificate.
We' …
-
Scaffolding an Entity Framework Core database in a project that targets .NETStandard
I've been working on a project recently for storing system configuration data (I know, I know, this is a problem that's been solved a thousand times over!) and after defining the database structure …
-
Adding a delay to ASP.NET Core Web API methods to simulate slow or erratic networks
I recently commented on a tweet by @jongalloway, saying:
A thousand times this! Run your app with an artificial delay introduced into server responses and look for things that don't make sense. …
-
Running Pi-hole on a CentOS virtual machine
Pi-hole is an awesome piece of software intended to be run on a Raspberry Pi (the clue's in the name!) that will sit quietly on your network responding to DNS requests, dropping ones for spammy …
-
'The specified URL cannot be found' - it can, but your Barracuda WAF doesn't want it to be
If you're seeing the following symptoms:
Your're seeing customers saying they're getting 'stuck' at a certain point in your application
There's nothing in your IIS (or web server of choice) to …
-
Adding logging to an old .NET 4.0 project via Castle Windsor to measure performance
Recently I've been working with a reasonably old codebase, one that's using Castle / Castle.Windsor 3.1.0 which dates back to late 2012, targeting plain .NET Framework 4.0. This has been 'interesting' …
-
Resolving 'missing' assemblies where the assembly has been renamed
We've probably all seen assembly binding redirects kicking around in config files, looking like this:
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
< …
-
Upgrading a Windows MySQL instance from 5.1 to 8.x
I've got a very old instance of MySQL kicking around (5.1.73 - released in December 2013) that's due for an upgrade. It's actually relatively newly created as it was installed using the Web …
-
Don't store monetary values as doubles
It's something that everyone should know, but apparently not...
I had an issue raised by a user recently for a piece of software that I inherited where they were being told that EUR 31,995.27 was …
-
TIL: You can use column aliases in an ORDER BY clause
This is almost certainly something a lot of other people know, but I've somehow managed to not learn it in the many (many!) years of using SQL Server that I have under my belt...
You can use the …