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.

If you want to set a background image for an element in CSS, you can do it at least in 2 ways. Which one fits you, it depends on your tasks and the tools you work with. This way of adding a SVG image as a background can be applied for any CSS property, for which you can add image.

Recently I met a new kind of screen locker while browsing. I could see it with Chrome and Edge in Windows 11. It opens a window which looks like a Windows defender and tells you to call to a number of the support. Of course, you will just pay too much for this call and that’s all. But it’s not easy to close this window. I will write how to do it.

In Microsoft Power BI Desktop it’s not obviously how to write a Number as it is without modifications like to write ‘2k’ instead of ‘2023’. Truth be told, it took me approximately 5 minutes to do it.

If you want to get the Author login from the SharePoint object, for example, list item, you should use 'expand=Author' in the query. It's necessary, but not sufficient. There's one more option, which you must use.