I had an interesting problem to solve: How long did a task take to complete? The challenge was that our task history table contains one row for the start and another one for the end of a task:
| Id | TaskId | Action | Timestamp |
|---|---|---|---|
| 1 | 100 | Start | 2022-08-01 08:00:00.000 |
| 2 | 101 | Start | 2022-08-02 07:30:00.000 |
| 3 | 100 | Stop | 2022-08-03 17:00:00.000 |
| 4 | 102 | Start | 2022-08-04 08:00:00.000 |
| 5 | 102 | Stop | 2022-08-04 17:00:00.000 |
| 6 | 101 | Stop | 2022-08-05 18:00:00.000 |
As we were trying to combine a private key with a certificate into a pkcs12 file, we got this OpenSSL error:
For the last 3 years we used Let's Encrypt certificates for our user group site. Since there is no direct and easy-to-use solution in Azure, we needed the sjkp plug-in. Unfortunately, that no longer works after we moved from Windows to Linux as the hosting platform and we needed to fall back to a manual process for the renewal of the certificates.
After I wrote last year about 3 Database Viewers for SQLite, one of the maintainers of Beekeeper Studio pointed me to their database manager. I was interested, but unfortunately there where too many bugs that made it impossible to work with my demo database. I liked what I saw, but it needed more time to get useful.
If you wrote a comment in this blog in the past weeks, you got an error like this one:
Warning: Attempt to read property "comment_ID" on null in /home/*/class-urvanov-syntax-highlighter-plugin.php on line 714 Warning: Attempt to read property "comment_ID" on null in /home/*/class-urvanov-syntax-highlighter-plugin.php on line 724 Warning: Cannot modify header information - headers already sent by (output started at /home/*/class-urvanov-syntax-highlighter-plugin.php:714)...
For the last 5 years I posed at least one post per week. I like to take a moment to celebrate this milestone and look back on how I did this and what I learned in doing so.
The NDC 2017 had a long-lasting effect on me. Especially the presentation by Troy Hunt on "Hack Your Career" gave me the motivation to blog more and showed me a way to do it.
Since a few people had troubles with creating the .well-known folder for the security.txt in ASP.Net, I will explain in this post how you can do it in .Net 4.8 and .Net 6.
Your web application is under the constant thread of hackers. It does not matter if you have a small pet project application on the internet or a big commercial site. As soon as it is accessible from the internet, someone will attack it.
Sometimes we get lucky, and someone finds a security issue and wants to report it. But where should they report it to? The address [email protected] may be processed by someone without any knowledge of IT or security and ignores the report.
If you need to block an IP address, you can do that directly in IIS 10 with the Web IP Security feature. You can install it with this PowerShell command (run it as administrator):
After a long time, I am back at an annoying problem with Visual Studio. One ASP.Net application works when I start it through "With Debugging", but it fails when I try "Run Without Debugging":
