Stories of daily programming
In the previous post we saw how to merge two or more historical tables with a T-Sql script. We will now propose a different solution to the problem that also takes into account the presence of gaps in the validity periods of the records. We’ll start from the same test database we used for the…
Read More “Merge two or more historical tables with Sql Server T-SQL – Part 2” »
In this post we are going to explain how we can merge the content of two or more historical tables in a Sql Server database with some T-SQL queries. I’ll try to be more clear: Create a basic data structure Let’s start by creating some tables that we will fill with some fake data, just…
Read More “Merge two or more historical tables with Sql Server T-SQL – Part 1” »
It’s been a really long time since I wrote the last time and now here I am. I hope you missed me :). In recent weeks I have been busy developing a WhatsApp client that interfaces with the WhatsApp Business API. This application consists of a web client developed in Javascript / VueJs 3 and…
In the previous post we saw how to create an SSL certificate (*.thedummyprogrammer.com) and the related CA certificate. To show you how to use those certificates, I’m going to use them in a website running in the local IIS of my PC. A practical example with an IIS website We will see an example on…
Read More “Become your own certification authority – Part 2” »
Suppose you developed a web application and you want to install this application in a test environment. To make the test more meaningful, you would like to install an SSL certificate with the application and use a domain name other than the standard ones, such as .com or .org. Consequently, the SSL certificate cannot be…
Read More “Become your own certification authority – Part 1” »
I’m a person who lives on memories, so today I decided to talk about a soccer game that in my opinion made the history of this genre: Sensible Soccer. At the time of this game’s release I was a kid and the proud owner of a Commodore Amiga, on which I spent several hours of…
Read More “Play again with Sensible World of Soccer on your PC” »
In this short post, I will show you how to extend the trial period of Windows Server 2019. It’s really very easy to do… First I suggest you check how many days are left before the trial period expires. You can do this executing the following command in Windows PowerShell: After executing this command a…
Read More “How to extend the trial period of Windows Server 2019” »
HTTP 500: every web developer has faced this error at least once in his life, and today I want to tell my story… A few days ago I was working on an ASP.NET WebForm application, which consistently showed the error HTTP 500 – Internal server error. Since IIS was configured not to show detailed errors,…
Read More “HTTP 500 – Internal server error in an ASP.NET application” »
Good morning everyone! Here we are once again! Today I am proud to announce the release of a clone of the Asteroids game developed in TypeScript. Why build an Asteroids clone? I thought it would be fun and so… I did. For the development I was inspired by this tutorial on w3schools.com, where you can…
Good morning guys! A few days ago I was working on an ASP.NET web form application which uses the control library Telerik ASP.NET AJAX. The application worked without problems until it was moved in a new server running Windows Server 2019. Running in the new environment it stopped working and in the browser’s development console…