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.EXE
cd %SystemDrive%\Program Files (x86)\Microsoft Office\Office16
OSPPREARM.EXE

In a recent project, I needed to create a SharePoint list and add an index to it, triggered by the addition of a web part to a page. The goal was to fully automate the process using the SharePoint REST API, eliminating the need for any manual intervention by administrators. Here's how I achieved this.

When you want to download a publish profile for the service in Azure, there can be an error, that basic authentication is disabled.

I found a very cool collection of flags in SVG format. It can be used as CDN or added to a project with npm. The library is called ‘flag-icons’. The flags are in 2 formats – 4x4 and 1x1.

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.

Once again I have to make Export of to Excel. And this time there are requirements to the template – colors, formatting and others. Not so long ago I implemented the export to Excel with XLSX package for React, and it was rendered at client. This solution is good but has many constraints. So, I started to look for another solution.

The Date is an object in JavaScript and TypeScript. When you have some spare time, try to compare 2 objects, you will find a lot of interesting things 🙂 Obviously, you need to compare not object, but their properties.

Obviously, it's a often cased task to update an object, or even a property in one object the array of objects. Especially it's actual for React applications.

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 'makephoto' easier.

Sometimes I like to use calculate different measures for one or another site. Last weekend I read about Lighthouse – it’s a part of DevTools in Google Chrome. I have already forgotten that I have such a powerful tool in my pocket and don’t use it. What is Lighthouse? Lighthouse is an open-source, automated tool for improving the performance, quality, and correctness of your web apps.