InSQL
How to generate batches of SQL Server INSERT statements with the maximum allowed number of row values
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…
InWeb
Treat Blazor component Warnings as Errors: Found markup element with unexpected name
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
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!
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
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…
InSQL
Working with JSON functions in SQL Server
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
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’…
InSQL
How to output inserted and source IDs when cloning SQL Server table data
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…
