I like the Ant Design of React and for me it’s very useful. Usually I prefer functionality to a better design and it allows me to achieve a functionality much faster. But when you do something not for yourself, you have a customer and he decides which design better.

You can get properties of an image from SharePoint library with RestAPI

The request looks like this:

https://markimarta.com/sites/Euro2024/bestboat/_api/Web/GetFileByServerRelativeUrl('/sites/Euro2024/bestboat/VoteLib/Team2/Regal.jpg')/Properties

The result is XML from which you should extract the values you want to use.

I used EventCalendar component with resources and timeline view, the default interval is 1 month, I also add week numbers to the header. I wanted to fit the calendar to the page without horizontal scroll.

The queries to get all the list items, get list items with specific field values, get list items by ContentType Name. The most of the time I spend with the last one.

The React snippet of how to update the selected element in the array of objects. The array of objects is connected with useState hook, and on change of Checkbox control the array must be updated.

Create a console app with .Net Framework 4.7.2 with Dapper and datasource in MSSQL Server or PostgreSQL.

If you create this ancient app, you should only add Dapper and NPGSQL packages from Nuget. The support of MS SQL Server is already built in. The scenario for .Net Framework is from real life, several applications still require this framework.

Short manual how to execute MSSQL server in Docker in Windows 11. For linux there are the same steps but instead of PowerShell you should use terminal and don’t forget about sudo.

When I tried to use PnP PowerShell with just the basic connection, I've got errors immediately with Windows 11. Why it happened - I don't know, but I do how to fix it.

We have a table with columns Id (GUID), Title (nvarchar(50)), PubDate (DateTime). After several tests there were inserted a lot of records and many of them have been inserted more than 1 time. The task is to 'seek and destroy' all the duplicate elements and to leave only unique rows.

How to fix Gitlab CI error during connect: Post http://docker:2375/v1.40/auth: dial tcp: lookup docker on … no such host. I spent more than 1 hour to fix it. And I am totally not sure that I will remember it 🙂