Install and run MSSQL Server in Docker
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. Read more»
Development
Fix error “Import-Module : Could not load file or assembly ‘System.Management.Automation, Version=7.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies.” with the usage of PnP commands
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. Read more»
Get duplicate SQL entities and remove duplicates
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. Read more»
NodeJS: Update all the packages to current versions with NPM
I downloaded a repository from github and decided to install the packages. I entered ‘npm install’ but as a result I’ve got a lot of messages that packages are deprecated and some errors. As I could see in the log files, the problem was connected with old packages. So I wanted to update all the […] Read more»
SharePoint and field called “state”
Many times I told myself not to work with SharePoint, but it’s forever with me 🙂My colleague asked to help him with a problem with modern lists. There some simple fields, without lookups. But there’s an error in displaying items. I spent about an hour to determine the problem – created a copy of the […] Read more»
Create list item and add data to SharePoint 2019 lists via REST C#
Once I tried to make the application to migrate a custom data source from SharePoint 2010 to SharePoint 2019 on-premise. To make it easier, I decided to make to separate solutions – the first one to export the data from SharePoint 2010 from the list to JSON and attachments to local folder(CSOM for SharePoint 2010 […] Read more»
Python. Find max sum of digits without arrays
The task is. You have an array of numbers, you should find the max sum of the digits. The numbers are natural. Constraints: you can not use arrays. Read more»
C# Convert Char to Int
Once again I decided to make a new task from LeetCode and finally my process had been stopped. I could not convert Char to Int. I even spent some time for research, but I could not find any solution. Then I open the documentation and started to read. Read more»
useEffect and load async data in React
I spent a lot of time to understand how to get async data from web-services and to set it to vars in React I need to try to change ‘fetch’ to ‘axios’ Read more»
Allow CORS in Net Core application
It’s not for production, but for developer environments Add the block below to Program.cs. I talk about Net Core 5 or Net Core 6 application. Read more»