InWeb
Formatting JSON with proper indentation using PowerShell
PowerShell is a powerful scripting language that makes working with data a breeze, allowing you to import and export to a variety of common file formats such as CSV, XML, and JSON. However, when it comes to JSON, the formatting applied by the built-in ConvertTo-Json cmdlet leaves a lot to be desired. While this may…
InWeb
.NET 8 Blazor MSAL Error – There was an error trying to log you in: ‘”undefined” is not valid JSON’
When developing a Blazor WebAssembly application that uses the MSAL (Microsoft Authentication Library) for .NET packages, you may encounter an error message similar to the following after trying to log in. There was an error trying to log you in: ‘”undefined” is not valid JSON’ The above error message is usually noticed after upgrading a…
How to dynamically build OR filters in an Entity Framework Core LINQ query
Entity Framework Core is an ORM (Object Relational Mapper) that allows us to leverage LINQ (Language Integrated Query) to abstract away the SQL (Structured Query Language) that would otherwise need to be written for interactions with a database. However, while LINQ is an awesome .NET feature, there are some limitations to be aware of when…
How to catch and parse a SQL Server Duplicate Key Exception
When developing an application that connects to a SQL Server (or Azure SQL) database, you will often want to leverage the features that the database engine provides to help minimise checks that would otherwise need to be performed at the application level. By delegating these checks to the database, you can simplify your application logic,…
How to publish a .NET application as a standalone executable file
When you need to create a .NET application that can be easily deployed to a system without worrying about the installed .NET version or other dependencies, the publishing options that have been made available since .NET Core 3.0 are most welcome. If you are publishing a modern .NET application today, not only is it possible…
InTools
Encrypt directories and file names within a zip archive using 7-Zip
When storing or transmitting sensitive digital data, it is vital to take adequate measures to protect it against unintended disclosure that could harm your privacy or the privacy of others. Common examples of sensitive data include client files that need to be stored offline for a limited time, and documents containing customer details that need…
InCareer
Speaking IT: Bridging the Language Gap for Tech Pros and Non-Tech Folks
Guest post by Linda Chase from Able Hire. Effective communication is a fundamental skill for IT professionals, especially when it comes to conveying complex technical knowledge to non-technical stakeholders. The challenge lies not just in sharing information, but in doing so in a manner that is both understandable and engaging for those outside the tech…
InSQL
Finding and deleting duplicate records from a SQL Server database
Sometimes duplicate data can make its way into a database, whether it be due to a software defect or as the result of an error that one or more users have made. Regardless of the cause, you may find yourself in a position where you need to find and delete duplicate records from a database….
InWeb
