XML Serialization with C#
Today JSON has taken over the role of XML for many scenarios, however, XML is still in very wide usage. XML stands for eXtensible Markup Language and has been a stalwart for data-interchange since the year 1998. It has been adapted over time to solve many different problems related to programming. In this article, I…
InSQL
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 which 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
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…
InSQL
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…
InAPIs
Base your API error response model on a solid standard with the Problem Details RFC
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
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…
InSQL
Query to find column names in a SQL Server database
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
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…
InSecurity
