Blog

Getting started with MongoDB queries

As a document-oriented database, MongoDB is very different from relational databases such as SQL Server or PostgreSQL. This is particularly true in regards to database queries since MongoDB features its own unique query API that is completely different from using a traditional query language like SQL. Working with MongoDB can sometimes seem like wizardry to…

Setting up a MongoDB development environment

InNoSQL

MongoDB is a hugely popular NoSQL database engine that is continuing to grow both in terms of its userbase and its feature-set. Given the ongoing push for rapid application development and the need to adapt quickly to changing requirements, MongoDB provides a platform where you can iterate quickly and change course as needed. In more…

What makes a good device identifier?

InProgramming

Choosing a strategy for calculating a unique and reliable device identifier can be a frustrating and somewhat more difficult decision than you might initially think. There’s no silver bullet and like many things in the world of programming, pros and cons need to be determined and trade-offs need to be made. In this article, I…

SQL Server upsert with condition and returned value

InSQL

Sometimes when working with a SQL Server database, you need to update a specific table row or insert a new row if the one you were trying to update isn’t already there. This logic is known as an ‘upsert’ operation i.e. either update or insert a row depending on whether it currently exists. In this…

IIS Publish Error: Could not verify the server’s certificate

InWeb

When publishing a website to IIS (Internet Information Services), it’s not uncommon to encounter errors from time to time. If you’re publishing an intranet application there are a number of errors that are more likely to crop up. In this post, I explain how to resolve a specific publish error relating to the server certificate….

How to become a quantum programmer

InProgramming

If like me, you are fascinated by science, you’ll possibly know a little bit already about the strange phenomena of quantum mechanics. Concepts like superposition, entanglement, and teleportation are all things that seem like they should be impossible but have been proven time and time again in the lab. Yes, things do behave very strangely…

How to stop and start IIS websites using C#

InProgramming

IIS (Internet Information Services) remains a widely used web server for hosting websites, FTP (File Transfer Protocol) sites, and other applications on Windows servers. While the graphical IIS Manager interface is great for setting things up initially and for providing a visual overview of your web configuration, there are also some great use cases for…

Implementing an async Repository and Unit of Work with Entity Framework Core

InProgramming

Implementing the Repository pattern in conjunction with the Unit of Work pattern is a best practice for data access that can bring a number of benefits to your application codebase when implemented correctly. Given the ease of use and scalability advantages that async .NET code offers, it makes sense to ensure that your data access…

SQL Server Database Mail setup via SQL

InSQL

Setting up SQL Server Database Mail is relatively simple when using SQL Server Management Studio, thanks to the graphical setup wizard it provides for most SQL Server editions. However, SQL Server Express, the free edition of SQL Server, does not offer the facility to configure Database Mail via a user interface. Thankfully, once you understand…

SQL Server Database Mail setup simplified

InSQL

Having the facility to send emails directly from your database engine is a hugely useful feature and this is exactly what the Database Mail functionality in SQL Server provides. With Database Mail, you can send email alerts when specific database events occur, or send query results and reports to users automatically on a scheduled basis….

Getting started with MongoDB queries

Setting up a MongoDB development environment

What makes a good device identifier?

SQL Server upsert with condition and returned value

IIS Publish Error: Could not verify the server’s certificate

How to become a quantum programmer

How to stop and start IIS websites using C#

Implementing an async Repository and Unit of Work with Entity Framework Core

SQL Server Database Mail setup via SQL

SQL Server Database Mail setup simplified

Getting started with GitHub Copilot in Visual Studio

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

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