Recent posts
A pure T-SQL replace-all function using PATINDEX
Although SQL Server is a powerful and fully-featured database engine, one of the things it has always lacked is support for regular expressions. This isn’t a super big deal, because you don’t (or at least shouldn’t) need regexes in your database all that often, and if you do need them you can always write a trivial C# extension for it thanks to the SQL CLR. read full post
A template for Dependency Injection and Configuration in .NET Core console apps
One of the nice things about working with ASP.NET Core is that dependency injection (DI) and configuration is wired up right out of the box. Working with console apps, you don’t have this luxury. However, it turns out it’s very easy to set this up yourself. In this post, I’ll set up a minimal template for using DI and appsettings.json configuration from a .NET Core console app. I’ll be using .NET Core 3.1, which is the current latest LTS version. read full post
Creating a Companion Cube in Blender 2.8
The Vital Apparatus Vent will deliver a Weighted Companion Cube in three, two, one… read full post
Visual Studio 2019 is kind of a disappointment
Microsoft Visual Studio is over 2 decades old at this point, and is currently still the way to work with the .NET ecosystem. It’s a solid IDE, arguably one of the best around. Earlier last month Visual Studio saw the release its latest major version: version 2019. Despite having been around for such a long time, this is actually the first release of Visual Studio that took place in the face of genuine competition (in the form of JetBrains Rider), and in that light, version 2019 is kind of a disappointment. read full post
Security Analysis of the Aperture Science Turret Production Line Turret Integrity Arbiter Integrity Judgment Protocol
We analyze the behavior of the Integrity Judgment Protocol, which is used by the Turret Integrity Arbiter on the Aperture Science Turret Production Line to determine the integrity of assembled Aperture Science Sentry Turrets. This analysis is primarily an assessment of the security of the Integrity Judgment Protocol. read full post
How much Pi do you really need?
Last Thursday was Pi day, at least in those parts of the world with a month-before-day date format. Google celebrated this event by computing a record-breaking 31.4 trillion digits of Pi. There’s no practical applications for this whatsoever, but it did get me wondering: how much Pi is enough? read full post
Why I don't have a very active GitHub profile
I was approached by a recruiter on LinkedIn the other day with yet another unsolicited job offer. I get these every week, and usually I just ignore them. This one stood out to me, however, due to the way the candidate profile was described. This guy was unironically looking for a “rockstar developer” who “lives and breathes code,” maintains an “active GitHub profile,” and spends a lot of time on reddit and hackernews. read full post