There are a lot of cases when you need to get the items by the author. For me the only correct way to get the SharePoint list items by user with CAML is like this:

<Where><Eq><FieldRef Name='Author' LookupId='TRUE' /><Value Type='Integer'>123</Value></Eq></Where>

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

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.