If you use a Pro version of Material UI, then you have a tool, how to switch the cells in the DataGrid table. But if you work with a wide table and you just want to make it more comfortable to work with it, there are some tricks for that. The first thing is to 'freeze' the header, so user can collate the column and headers. All the Excel users like this function. And the second thing is to allow user scroll the page if he has a small resolution and he doesn't have touch screen.

In one Web Api Net Core solition I used Microsoft.AspNetCore.Identity.EntityFrameworkCore for Authentication. It’s really comfortable to work with this package because you a free from the implementation of all the methods and don’t spare much time. It also returns the text of errors, for example, that password is to short or special character is required. For me everything was ok, but the customer wanted to see the text in German.

Obviously, it's an ordinary case, when you get an array of objects and you need to create for the reply the array of other Objects, but you need to initialize it on load. For React developers it can be often used with useEffect or componentDidMount.

To modify the size of the TextField component in Material UI, you can make several things. The basic modification is obvious, but other ones are not so. By default, the component TextField is rather big and it's really a common task to make it less.

There’s a nice online tool for rendering the test data. It’s at the website https://www.mockaroo.com/. I often use it to render fake SQL data. But now I am working on a Net application with EF Core. And obviously, I need test data for webservices and interfaces. Below is the way to quickly insert the test data in the Net solution.

It's an extremely nice article about how to implement the Role-based Authorization in Net Core Web API. I won't copy it here because it's written to good. Maybe I will publish to Git a template app later, but now just save for future.

Below you can find a PowerShell script to copy items from one SharePoint list at one site to another SharePoint list in another site. I use it with several modifications to work with the data in test environments.

I parsed the CSV file. The lines are separated by '\r\n'. If in Flow you use split(text, '\r\n'), it doesn't work as you'd like to. Instead use function decideUriComponent and respective values: \r - %0D, \n - %0A

In the developer database (MS SQL Server) I had a field, in which all the values were the same. The value was "OldDoc.txt". I wanted to make values unique and for this I wanted to add "ID" before ".txt".

When I executed Update-SPSolution command in PowerShell  to update  one of WSP-solutions, I got the error, that 'LOG_BACKUP' is full "Update-SPSolution : Das Transaktionsprotokoll für die 'SP19_Config'-Datenbank ist aufgrund von 'LOG_BACKUP' voll". In English versions of SharePoint the text of the error can be like this "The transaction log for database ‘SP19_Config’ is full due to LOG_BACKUP".