Software

My case of crashing the laptop with the connected external monitor

I started to use my old laptop (2019year) for specific tasks. Usually, I plug the laptop into my 32inch display and work this way. But after 2-3 minutes of work my laptop hanged. The display was with a huge quantity of noise. But without external display it worked perfectly. There are 2 video adapters – […] Read more»

Windows

Fix error no such table: “pragma_table_list” in DBeaver on opening the tables of SQLite database

Error with ‘pragma_table_list’ is actual not only for DBeaver, but also for any driver for SQLite. This post is about DBeaver just because I was working with it, when I met the error. The case is like this: I created an SQLIte database with Microsoft.EntityFrameworkCore and then I wanted to open it in DBeaver. But […] Read more»

Windows

The Implementation of STDEV for values from 3 columns in the table

Standard deviation is the degree of dispersion or the scatter of the data points relative to its mean, in descriptive statistics. It’s often used in data analysis and reports. And, of course, how to calculate Standard deviation in PowerBI is very important to know. Read more»

Microsoft Office

Add to archive (Tar) files by mask

In Linux (Debian, Ubuntu) it’s very cool to use bash and command line. Recently I wanted to add to archive approximately 3000 ‘jpg’ files, which were named like ‘test_2024_06_10 11:22:00’. I didn’t want to select so many files manually, so I did it from command line. This is how my command line text looked like: Read more»

Linux

Extend Windows Server trial

Windows

For local development I often need Windows server and I use trial version. As six months came through, I need to buy or extend it. Of course, I prefer to extend 🙂 Open PowerShell as administrator and execute the command: slmgr -rearm To continue the trial for your Microsoft Office, you can use OSPPREARM.EXEcd %SystemDrive%\Program […] Read more»

Windows

Run PostgreSQL in Docker

To Run PostgreSQL in Docker I use an official image ‘postgres’ from https://hub.docker.com/_/postgres. You can start it as it’s described in the documentation, but I prefer to use docker-compose. For me it’s more flexible and allows to avoid of errors when start form command line. Read more»

Web server

Add new value to $PATH variable in Linux (Debian, CentOS, Ubuntu)

With SSH you sometimes need to add new value to the $PATH variable. When your application is not in the directory, which exists in the $PATH array. If you don’t want to write down the full path in the command line, for example, ‘/home/user/myapps/makephoto’, you can add ‘/home/user/myapps/’ to $PATH and then you can execute […] Read more»

Linux

Parse CSV in Microsoft Flow (PowerAutomate)

I parsed the CSV file. The lines are separated by ‘\r\n’. If in Flow you use split(text, ‘\r\n’), it doesn’t work as you’d like to. Instead use function decideUriComponent and respective values: \r – %0D, \n – %0A Read more»

Microsoft Office

Popular Posts