Jonathan Crozier, Author at Jonathan Crozier

How to parse the name parts from a full name using SQL

Sometimes I come across situations where I need to extract the individual parts of a full name from a database record that relates to a person e.g. a customer or an employee. This may be part of general application logic or perhaps something that needs to be carried out during a database migration. For example,…

Time to Reflect… How to add properties to a C# object dynamically at runtime

InProgramming

Have you been searching for a way to dynamically add properties to an object at runtime using C#? If so, you may have come across how to do this using ExpandoObject. However, after some further research, perhaps you’ve determined that it’s not what you are really looking for. For example, you might be trying to…

Don’t be a victim… Log your SQL Server deadlocks

InSQL

Quite often there are situations in which you are aware that deadlocks are happening in your SQL Server database, but you are lacking the information required to fix them. What you need under these circumstances is an automated way of tracking the locks and logging them. In this article, I demonstrate a simple way to…

Base your API error response model on a solid standard with the Problem Details RFC

InAPIs

If you’re trying to come up with an error response model for your API, but are finding it difficult to settle on a format that is simple, yet future-proofed; look no further! In this article, I expound the virtues of the ‘Problem Details’ RFC standard and why I believe it’s a no-brainer to use it…

Install and test drive the Windows Subsystem for Linux

InScripting

I’ve always had a keen interest in Linux-based operating systems and especially since .NET Core is a cross-platform framework there’s more reason than ever to sharpen up your Linux skills if you enjoy programming with C# or another .NET language. In this article, I walk through the process of installing and testing out the Windows…

Query to find column names in a SQL Server database

InSQL

Whenever I’m considering making database schema changes, I often find the need to search the database I’m working with for columns with a particular name. It can be especially valuable to do this when dealing with a large model consisting of many tables and columns. In this situation, I’m typically seeking to establish whether a…

Getting started with the NEW Windows Terminal

InScripting

If like me, you’re more than a little bit tired of the old Windows Console then you’ll be excited to know that Microsoft finally has a replacement in the pipeline… and it’s not far away from official release! It’s called the Windows Terminal and it is a quantum leap from the old Console host, both…

How to not make a hash of your passwords with Scrypt.NET

InSecurity

I wasn’t aware until I began writing this article that the phrase “to make a hash of something” was in common use in the English-speaking world today. According to the Cambridge Dictionary, to make a hash of something can be interpreted as follows. hash noun (FAILURE) make a hash of sth [ S ] UK…

Calling all APIs… How to use Flurl with C#

InAPIs

I, like many software developers these days, spend a lot of time talking to APIs. Not literally (of course!) but I do believe that choosing the right API client library can really help to boost your productivity and as a bonus, you can end up with much cleaner code. My ‘go-to’ solution at the moment…

New blog… Where to start?

InCareer

Hi, I’m Jonathan Crozier and welcome to my blog! This is the first post I’ve written for my website and I am very excited to begin this adventure into the ‘blogosphere‘. A question that I imagine is on most people’s minds after starting a personal blog is “what should my first blog post be?”. Many…

Author: Jonathan Crozier