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. Read more»
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»
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. Read more»
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 command. Read more»
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. Read more»
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»
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»
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. Read more»
When you want to download a publish profile for the service in Azure, there can be an error, that basic authentication is disabled. Read more»
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 – 4×4 and 1×1. Read more»
