Jonathan Crozier, Author at Jonathan Crozier

Chrome Developer Tools: Speed up changes to your web app front-end with Workspaces

Most front-end web developers are aware of the developer tools that are built into modern web browsers such as Google Chrome. Many of these developers also use some of the available features to help debug their applications. However, in my experience, not many developers have put in the effort required to learn the full extent…

How to obfuscate .NET assemblies with ConfuserEx

InProgramming Security

Software assemblies containing managed code, such as those used by .NET applications can be easily decompiled into readable source code using free decompilation tools. This can present a challenge to application vendors who have a desire to prevent their code from being viewed or changed due to copyright or potential security concerns. For any application…

Learning the Kusto Query Language (KQL) with Application Insights Logs

InWeb

Application Insights is a powerful Azure feature for monitoring web applications. It collects a wide range of useful data that you can analyse either in real-time or by executing queries against logs at a later point in time. The logs that are stored by Application Insights enable you to see how your web requests are…

Preventing SQL injection in C# applications

InProgramming Security SQL

SQL injection is a common attack vector that remains one of the most prevalent security risks for applications today. One of the reasons SQL injection attacks are so pervasive is the fact that injection vulnerabilities are very easy for attackers to discover and exploit, sometimes with devastating consequences. On the other hand, mitigating SQL injection…

How to use tuples with named fields in C# by example

InProgramming

Tuples are a very useful feature of the C# language; they allow more than one value to be grouped and passed back and forth without needing to define additional types. As we’ll discover later in this article, tuples are particularly convenient for returning more than one value from a method, avoiding the need for ugly…

Interacting with MongoDB using C#

InNoSQL

In my previous two posts, I covered how to set up a MongoDB development environment and then followed this up with how to get started with MongoDB queries. While it’s great to have a development environment set up and know how to run queries from the command line, ultimately you’ll need to figure out how…

Getting started with MongoDB queries

InNoSQL

As a document-oriented database, MongoDB is very different from relational databases such as SQL Server or PostgreSQL. This is particularly true in regards to database queries since MongoDB features its own unique query API that is completely different from using a traditional query language like SQL. Working with MongoDB can sometimes seem like wizardry to…

Setting up a MongoDB development environment

InNoSQL

MongoDB is a hugely popular NoSQL database engine that is continuing to grow both in terms of its userbase and its feature-set. Given the ongoing push for rapid application development and the need to adapt quickly to changing requirements, MongoDB provides a platform where you can iterate quickly and change course as needed. In more…

What makes a good device identifier?

InProgramming

Choosing a strategy for calculating a unique and reliable device identifier can be a frustrating and somewhat more difficult decision than you might initially think. There’s no silver bullet and like many things in the world of programming, pros and cons need to be determined and trade-offs need to be made. In this article, I…

SQL Server upsert with condition and returned value

InSQL

Sometimes when working with a SQL Server database, you need to update a specific table row or insert a new row if the one you were trying to update isn’t already there. This logic is known as an ‘upsert’ operation i.e. either update or insert a row depending on whether it currently exists. In this…

Author: Jonathan Crozier

Chrome Developer Tools: Speed up changes to your web app front-end with Workspaces

How to obfuscate .NET assemblies with ConfuserEx

Learning the Kusto Query Language (KQL) with Application Insights Logs

Preventing SQL injection in C# applications

How to use tuples with named fields in C# by example

Interacting with MongoDB using C#

Getting started with MongoDB queries

Setting up a MongoDB development environment

What makes a good device identifier?

SQL Server upsert with condition and returned value

How to print SQL Server messages to the output immediately

Introduction to the SQL Server MERGE statement

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