Development

SQL recursive query from bottom to top

The task is to build a tree in a table with parentID from bottom to top. It’s useful for generating hierarchy strings, lists or any other types. You can also create a storage procedure of this and it will make it easy to use in queries. Read more»

SQL and databases

Common error after installation of MS SQL server 2012

After installation of MS SQL Server 2012 on Windows Server 2012, I had gotten these errors in Event Viewer on execution server:The server was unable to initialize encryption because of a problem with a security library. The security library may be missing. Verify that security.dll exists on the system.TDSSNIClient initialization failed with error 0x139f, status […] Read more»

SQL and databases

NodeJS. Fix error “create react app npm ERR! Maximum call stack size exceeded”

NodeJS

Recently I started to learn ReactJS. I could manually install the environment in NodeJS for ReactJS – WebPack, ReactJS, Babel and others. But to make solutions easier, I decided to use Create-react-app. Unfortunately, I got the error “create react app npm ERR! Maximum call stack size exceeded”. Read more»

TypeScipt / Javascript

Expand all the events in Calendar View on page load SharePoint

The method to expand all the events in Calendar View on load using Content Editor WebPart. You should add this code. You should copy and paste it to html file, save this file to document library and set its path into the settings of CEWP. Read more»

SharePoint

Parse SharePoint lookup value with JavaScript and Regular expression

Javascript logo

If you use SharePoint and get data from lists with JavaScript, once you will receive SharePoint lookup value which looks like ’34;#Item title’. There is a way to parse this data with Regular expression and to convert it to an object. I have created a small method to make it easier. In my case I […] Read more»

SharePoint

How to retrieve SharePoint version from URL

SharePoint 2016 Logo

To retrieve a SharePoint version there’s no need to go to Central Administration. You can easily see it if you enter the URL http://mig1/_vti_pvt/service.cnf Read more»

SharePoint

Disable modal windows in Calendar view SharePoint 2010

With SharePoint 2010 you can disable usage of modal windows in List settings. But if you use calendar view, it does not matter what you have installed in the settings – all the list forms will be opened in modal windows. How to disable them? Read more»

SharePoint

Make requests to SharePoint 2010 web services with SoapUI

This post is about SharePoint web services. In SharePoint 2010 you can use only SOAP requests to get or to send data from or to SharePoint web sites. A bit below in this post you can see the list of WSDL URL addresses. Read more»

SharePoint

Popular Posts