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()

Advertisements

Using LEAD and LAG in your SQL queries

So you need to show some sales data. You are then asked that the quarters you are returning in the query need to show the previous and next quarter's sales data in the same row. This is easily handled by using the built-in SQL server functions LEAD and LAG. Setting up the schema and sample …

Continue reading Using LEAD and LAG in your SQL queries

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

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.