Blog - Jonathan Crozier

Getting started with GitHub Copilot in Visual Studio

GitHub Copilot is a revolutionary AI-powered coding assistant that helps developers write code faster, reducing effort and freeing up time to focus on problem-solving and collaboration. For decades, aside from their own experience, developers have relied on online resources such as Stack Overflow and various forms of documentation, where available, to assist with the development…

How to generate batches of SQL Server INSERT statements with the maximum allowed number of row values

InSQL

When working with SQL databases, you may find the need to copy data from one table into another table with an identical or similar schema, either within the same database or across different databases. Often in these cases, the volume of data you need to copy will be quite large, and therefore, performance will be…

Treat Blazor component Warnings as Errors: Found markup element with unexpected name

InWeb

When developing Blazor applications, certain issues with component markup are flagged as warnings by default that can have a substantial impact if undetected. One of these cases is warning code RZ10012, which is raised when a Blazor component cannot be found due to a missing using directive within the Razor file. In my opinion, I…

Maximize .NET LINQ performance using ZLinq

InProgramming

LINQ is one of the standout features of .NET and is loved by many C# developers, for whom it has become second nature in their day-to-day work. The declarative nature of LINQ allows for expressive queries over collections to be composed, resulting in highly readable and maintainable code. However, while LINQ provides powerful abstractions and…

.NET Run File: Run C# code with no project file!

InProgramming Scripting

The world of .NET is in a constant state of evolution, with the pace of framework improvements steadily increasing, especially following the advent of the cross-platform .NET Core in 2016. Over the past few years, Microsoft has been working hard to increase the adoption of the C# language among new software developers, who often choose languages…

Exploring SQL Server JSON mapping support in Entity Framework Core 9

InProgramming SQL

JSON is a ubiquitous format for defining structured data, and it is increasingly common to see it being stored directly in databases that are primarily relational in nature. Over the past several years, Entity Framework Core has steadily improved its support for JSON, culminating in first-class JSON mapping support in EF Core 8 and EF…

Working with JSON functions in SQL Server

InSQL

JSON has become the de facto standard for data interchange and its ubiquity in modern software applications makes the support that SQL Server offers for working with JSON more relevant than ever. Whether you’re developing APIs, dealing with semi-structured data, or storing configuration, the ability to handle JSON natively at the SQL level will help…

Using AzCopy to transfer a large number of files between Azure Blob Storage Containers

InScripting

Azure Blob Storage is Microsoft’s primary cloud storage solution and can handle massive amounts of unstructured data. Whether you need to store images, videos, documents, or log files, it offers a secure and scalable platform for online file storage that you can trust. Within an Azure Blob Storage account, you can configure one or ‘containers’…

How to output inserted and source IDs when cloning SQL Server table data

InSQL

If you write T-SQL scripts for SQL Server or Azure SQL databases, you will likely come across the requirement to ‘clone’ existing data at some point along the way. It’s usually quite straightforward to accomplish a clone operation when copying data from a single table to another table, but how about when you need to…

How to keep the host window open after executing a PowerShell script

InScripting

When working with PowerShell scripts, it’s common to encounter scenarios where you want to launch an automated operation on demand by running the script file and then viewing its output at the end of the process. On a modern Windows system, you can right-click on a PowerShell file and select the Run with PowerShell option from…