Blazor, RabbitMQ and MQTT using Paho with JSInterop.

With Blazor being in official preview I decided to create a simple chat application using the Client-side Blazor project template which runs on WebAssembly. The goal Connect to a RabbitMQ service with one or more clients sending and receiving public chat messages. Lets get start I've never used any MQTT library before but found Paho …

Continue reading Blazor, RabbitMQ and MQTT using Paho with JSInterop.

SQL – Deleting duplicate rows using ROW_NUMBER()

So your database is/was designed in a way that exact duplicate records could be inserted with no way to uniquely identify each row. Now that you need to delete duplicate rows you can do one of two things: Schema: Solution 1: One way to do this is by inserting the data into a temp table, …

Continue reading SQL – Deleting duplicate rows using ROW_NUMBER()

Generating a PEM private and public certificate with OpenSSL on Windows

To generate a PEM certificate using OpenSSL is easy, but if you haven't yet done it before it can be a bit frustrating if you've never used OpenSSL before. If you think you can just go to OpenSSL.org and download the binaries you are mistaken. They only provided source files which you need to compile. …

Continue reading Generating a PEM private and public certificate with OpenSSL on Windows