Blog

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…

Encrypt directories and file names within a zip archive using 7-Zip

InTools

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…

Speaking IT: Bridging the Language Gap for Tech Pros and Non-Tech Folks

InCareer

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…

Finding and deleting duplicate records from a SQL Server database

InSQL

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….

How to fix scrolling issue after closing Google AdSense Consent dialog

InWeb

Since Google’s New Consent Management Platform requirements for serving ads in the EEA and UK came into effect this year (2024), websites that display Google AdSense advertisements must show a Consent dialog to users. This is part of IAB Europe’s Transparency and Consent Framework. One of my blog readers kindly pointed out that ever since…

How to paste JSON as Classes in Visual Studio: A hidden gem!

InProgramming Tools

In the increasingly fast-paced world of software development, efficiency is a critical factor for success in the marketplace. Visual Studio, Microsoft’s flagship IDE (Integrated Development Environment), is packed full of features designed to make your programming experience as productive as possible. Among these is a lesser-known feature that is extremely useful; the ability to paste…

A better way to convert enums to strings with Entity Framework Core

InProgramming

By default, Entity Framework Core stores and retrieves .NET enumerations as their underlying integer values for SQL databases, primarily for performance and storage optimization reasons. Nevertheless, if there is a requirement to store enums within your data model as strings at the database level, it is important to have a suitable way to configure this…

Query to find table names in a SQL Server database

InSQL

When working in a SQL Server or Azure SQL database containing many tables, I often find the need to search for tables with names that contain a specific keyword. This is particularly true when working with an unfamiliar schema. While tools like Azure Data Studio provide easy ways to search by table name, I find…

Cracking the Code: A Woman’s Guide to Smashing Pay Inequality in Tech

InCareer

Guest post by Linda Chase from Able Hire. In the ever-evolving tech industry landscape, discovering a disparity in pay between male and female colleagues can be a disheartening revelation. However, this situation presents an opportunity for women to take proactive and informed steps to address and overcome this challenge. This comprehensive guide provides actionable strategies…

Converting CSV files with values containing commas to JSON using C#