What I Write About…
Databases
Helpful posts about SQL Server, Merge Replication and how to tune your databases for maximum performance.
Programming
Mostly focusing on C# and JavaScript but I enjoy exploring other languages such as F# and Python.
Scripting
Automation is the key to productivity, I cover innovative solutions to everyday problems using automated scripts.
Web Development
I cover all aspects of web development with a particular focus on application architecture and security.
InTools
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
How to fix scrolling issue after closing Google AdSense Consent dialog
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!
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
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…InSQL
Query to find table names in a SQL Server database
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…InCareer
Cracking the Code: A Woman’s Guide to Smashing Pay Inequality in Tech
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#
CSV (Comma-separated values) remains an extremely popular file format, and, in the context of programming, it is particularly useful for importing and exporting data between different software applications. One of the issues with CSV, or any other delimiter-separated file format, is that often the values that need to be parsed into separate ‘parts’ will contain…Communicating with ASP.NET Core hosted services from API endpoints using Channels
Hosted services are a powerful .NET feature, providing a robust mechanism for executing long-running background tasks in different types of applications. Given the flexible nature of .NET, such applications could be running on client devices, on-premise servers, or the cloud, depending on the particular use case. When it comes to ASP.NET Core, hosted services are…Categories
- APIs (12)
- Career (4)
- NoSQL (3)
- Programming (41)
- Scripting (15)
- Security (16)
- SQL (17)
- SQL Server Merge Replication (4)
- Tools (4)
- Web (24)