January 2020 - Jonathan Crozier

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

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…

Month: January 2020

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

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

Install and test drive the Windows Subsystem for Linux

Introduction to the SQL Server MERGE statement

Operating on data via a SQL Server Stored Procedure efficiently with Table-Valued Parameters using C#

Enable ahead-of-time (AOT) compilation for Blazor WebAssembly