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
-
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 …
-
Ignoring parameters that haven't been specified in a SQL query
I answered a question on Stackoverflow today that was looking to cater for having parameters to the query that aren't always required, i.e.
The report has three parameters, Sales Id, Start Date and …
-
2019: Time for even more
After a thoroughly action packed 2018 where I’ve learnt many different new technologies (AngularJS, Gulp and more) along with some more protocol-esque things (SWIFT, you and your MT103s and friends, …
-
End of 2018 link dump
Things I've had open in tabs to read, some of which may be of interest to you!
Nick Craver - Stack Overflow: How We Do Monitoring - 2018 Edition
Seriously, read it. There's a lot you can take away …