Development

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»

SQL and databases

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»

SharePoint

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»

SQL and databases

NodeJS: Update all the packages to current versions with NPM

NodeJS

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»

React

SharePoint and field called “state”

SharePoint 2016 Logo

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»

SharePoint

Create list item and add data to SharePoint 2019 lists via REST C#

SharePoint 2016 Logo

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»

SharePoint

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»

Python

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»

.Net & C#

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»

TypeScipt / Javascript

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»

.Net & C#

Popular Posts