How to find the lines with the specific text in Linux console
You can use AWK or grep or grep Read more»
Software
Move multiple lines up and down with Notepad++
Accidentally I found out, that Notepad++ allows to move multiple lines up and down without Copy-Cut / Insert? Use Ctrl + Shift + (arrow up | arrow down). Read more»
Hotkeys to transform text to UPPERCASE or to LOWERCASE in Visual Studio and Visual Studio Code
Transform text UPPERCASE or lowercase is a very common task for a developer. And when the text is not in the required case, you obviously don’t want to type it one more time. Luckily, there are the developers of Visual Studio who already thought about it. Read more»
How to fix error WSL (12 – Relay) ERROR: CreateProcessParseCommon in Windows 11
I knew that Linux is installed at my Windows Installation. And if I choose Ubuntu among the installed apps, I could use it. But not with WSL, then the error. It was the same as from command line, PowerShell. It also didn’t allow me to execute any Linux utils within ‘wsl -e … ‘ Read more»
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»
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»
How to insert N strings of text to each row of the existing table
We have a table in word document and now we need to add new rows from the existing text. The text was copied from the text editor Notepad. Read more»
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»
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»
Extend Windows Server trial
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»