The queries to get all the list items, get list items with specific field values, get list items by ContentType Name. The most of the time I spend with the last one.

The React snippet of how to update the selected element in the array of objects. The array of objects is connected with useState hook, and on change of Checkbox control the array must be updated.

Create a console app with .Net Framework 4.7.2 with Dapper and datasource in MSSQL Server or PostgreSQL.

If you create this ancient app, you should only add Dapper and NPGSQL packages from Nuget. The support of MS SQL Server is already built in. The scenario for .Net Framework is from real life, several applications still require this framework.

Short manual how to execute MSSQL server in Docker in Windows 11. For linux there are the same steps but instead of PowerShell you should use terminal and don’t forget about sudo.

When I tried to use PnP PowerShell with just the basic connection, I've got errors immediately with Windows 11. Why it happened - I don't know, but I do how to fix it.

We have a table with columns Id (GUID), Title (nvarchar(50)), PubDate (DateTime). After several tests there were inserted a lot of records and many of them have been inserted more than 1 time. The task is to 'seek and destroy' all the duplicate elements and to leave only unique rows.

How to fix Gitlab CI error during connect: Post http://docker:2375/v1.40/auth: dial tcp: lookup docker on … no such host. I spent more than 1 hour to fix it. And I am totally not sure that I will remember it 🙂

I downloaded a repository from github and decided to install the packages. I entered ‘npm install’ but as a result I’ve got a lot of messages that packages are deprecated and some errors. As I could see in the log files, the problem was connected with old packages. So I wanted to update all the packages in package.json.

Vagrant is a cool application for the automation of the development of the virtual machines. It allows to create a VM for VirtualBox in several seconds or minutes, and it's very cool. But rather other you want to use it offline, otherwise you can use AWS or something like that. So I will write down some notes how to use Vagrant images offline.

I will write some useful commands to work with Docker. If I use them often, I will remember them, otherwise I will remember them quickly if I read this post.