Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • My other dummy projects
  • Games
    • Space Y: An Asteroids clone
  • Services
    • What’s my user agent
    • What’s my IP address
  • About
  • Toggle search form

Merge two or more historical tables with Sql Server T-SQL – Part 2

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” »

Sql Server

Merge two or more historical tables with Sql Server T-SQL – Part 1

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” »

Sql Server

Run an ASP.NET web API in CentOS 7

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…

Read More “Run an ASP.NET web API in CentOS 7” »

.NET 7

Become your own certification authority – Part 2

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” »

SSL

Become your own certification authority – Part 1

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” »

SSL

Play again with Sensible World of Soccer on your PC

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” »

Games

How to extend the trial period of Windows Server 2019

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” »

Windows Server

HTTP 500 – Internal server error in an ASP.NET application

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” »

ASP.NET

An Asteroids clone developed in TypeScript

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…

Read More “An Asteroids clone developed in TypeScript” »

Games

WebResource.axd (404) not found

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…

Read More “WebResource.axd (404) not found” »

ASP.NET

Posts pagination

1 2 … 10 Next

Copyright © 2024 The Dummy Programmer | Privacy Policy | Terms of use |

Powered by PressBook Masonry Dark

Manage Cookie Consent
This site doesn’t collect user personal data and doesn’t install profiling or analytical cookies, either its own or from third parties. Read our privacy policy for more info.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}