Author page: Dev Books

Search for information on Git HEAD and the chances are you come away with a vague idea and possibly a good idea, but confused. It need not be that way if you look at the essence of why we have a HEAD. I am going to explain in two sentences exactly what it is. Then…

From SQL Server 2016, Microsoft provided support for storing and manipulating JSON within a SQL Server database. The aim of this blog is not to teach you how to use JSON but rather a use case for when JSON is a better alternative. For this second example I am going to show you how I…

When creating a Linux VM in Azure we have two options for configuring authentication: Regular username and password Using an SSH public key Username and password need no introduction. The purpose of this blog is to show how we can access the VM using SSH which eliminates the need for entering a password for logging…

From SQL Server 2016, Microsoft provided support for storing and manipulating JSON within a SQL Server database. The aim of this blog is not to teach you how to use JSON but rather a use case for when JSON is a better alternative. For this example I am going to show you how I implemented…

I use window functions a lot however; I often find myself having to remind myself on certain syntaxes or the different outputs between two functions. The following code snippet is used just as a reminder on what is available and is not a complete exhaustive list. The following code consists of three different CTES. Here…

In the last blog I showed you how to configure an Application and Service Principal in Azure using PowerShell. We could have used the portal but the portal changes a lot and the cmdlets ae more consistent. In this blog I will show you how to request a bearer token using Postman. If you do…

For most of my projects I was comfortable with rolling my own logging and it became easy to reference this library in new projects. I then found myself wanting to have multiple log files and sending data from different parts of the application to each log for diagnostic purposes. There needed to be some serious…

This is a series of blogs detailing my introduction to using OData v4 with C# and ASP.NET WebApi. The source code for the project can be found here. Creating the Project The Project is called Part13 Entity Relationships So far in this series of blogs we have been dealing with…

This is a series of blogs detailing my introduction to using OData v4 with C# and ASP.NET WebApi. The source code for the project can be found here. Conventional Routes I mentioned in previous blogs that if we name our controllers and actions in a specific way, an OData request will locate the…

The TRY/CATCH/FINALLY exception handling has been around since C# 1.0 and you are very unlikely to find a developer who does not know how to use them. What may not be so obvious is that there are a number of hidden gems that few developers use. This is on top of new enhancements that have…