In HTML tag 'input type = number' is not very user friendly. So, I always implement it as a text with transformation text to number.

I needed to check if the tables are in the database or not. Here is an example of the SQL query - it returns 1 if one of the tables exists and 0 if they do not exist.

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.

If you want to customize the styles for filter panels in DataGrid from Material UI (MUI), you need to know, where it is. And only so. To update these styles you can only with the object properties.

You have a sim-card and need to find what's you number. If your balance is active, you can call somebody, but if you can't do it? Of course, for different operators the commands are uniuque. But for AldiTalk there's such a ocmmand.

You can delete timer job only with PowerShell. Why? I guess you know why 🙂 The most popular reason is the duplicating of timer jobs. To delete a timer job, you need to know the ID. And you can get it also with PowerShell or with GUI.

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:

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.