Nobody can't work all day, you need to have a rest. And also, you should laugh, because it extends your life. Here are the coding jokes which I like (and remember)

PowerBI applies a lot of functions automatically or you can make them manually. But if you work with a dynamically changed data, for example, when new columns are added in SharePoint list, and you don’t want to add them manually every month (week, year, etc), you can automatically iterate through them.

Class to determine if a user is in the SharePoint group or is in the AD Group, which is added to the SharePoint group. So, the admin access to a custom SharePoint module is that everybody, who exists in the admin group, has more data. The admin group is a SharePoint group, which contains SPUsers (from domain) and Domain groups, which contain AD Users. Actual for SharePoint 2016, 2019.

Obviously, true developers prefer to return the date in a digital format, for example, '24.01.2024', '24-01-2024' and various combinations of this. But customers often want to work with human dates. In this post you can find how to return the custom localized date and how to use it with a Fluent-UI component DatePicker.

In apps with different Roles and permissions you may need to get information about AD Groups. Here are some snippets which can help you with this part of the task.

While the development SPFX for SharePoint 2019 once the loading of the webpart at 'workbench.aspx' page stopped. SharePoint server is installed at my virtual machine, the development of SPFX is local. At first I totally could not understand what's wrong. But soon started to look for the reason.

If you need to select the records between 2 dates in MS SQL, where the DateTime column contains both Date and Time, you can use SQL functions for WHERE clause and avoid of adding the time information like '23:59:59.000'. Though you can do it and this way.

Today I will write about a very important option in VS 2022, which is called 'Enable Just My Code'. I don't really know, why is set so. In my opinion, almost all the developers update this value after installation of Visual Studio.

When you make a SharePoint 2019 on-premises solution, you can make not only SPFX solutions, but also old-school WSP-solutions. It allows you not only to use SharePoint API, but also to use your own API services. With SharePoint 2019 you can use WCF service. For example, it’s a good way when you develop an application which uses the external database. This works also for SharePoint 2013 and SharePoint 2016.

To add the arrows UP and DOWN for a visualization of data changes in Power BI report, you can use this DAX function. It can help you to make a table more descriptive.