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»

June 15, 2020. Aleksei

SQL and databases

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

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»

May 12, 2020. Aleksei

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»

March 13, 2020. Aleksei

SharePoint

Parse SharePoint lookup value with JavaScript and Regular expression

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»

January 16, 2020. Aleksei

SharePoint

Make clickable div with jQuery according to tag “a href”

The task is to make clickable div tags. There are several div blocks in a page, each div contains a hyperlink with URL. You need to make so, that if you click on div element, you open a hyperlink. Read more»

October 14, 2019. Aleksei

TypeScipt / Javascript

How to retrieve SharePoint version from URL

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»

October 9, 2019. Aleksei

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»

October 6, 2019. Aleksei

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»

October 1, 2019. Aleksei

SharePoint

Using multiline string variables in JavaScript

Javascript never had good ways to use multiline strings before ES6 had appeared. In ES6 you can use template literals – strings delimited by backticks instead of quotes, single or double. But what to do if you can not use ES6 possibilities? Read more»

September 26, 2019. Aleksei

TypeScipt / Javascript

Convert date format dd.mm.yyyy to a SharePoint query string format with JavaScript regular expression

In SharePoint queries you should use date in the format ‘yyyy-mm-ddTHH:MM:SSZ’, for example, 2019-09-30T09:00:00Z. But the input form of the SharePoint datetime controls returns the value as ‘dd.mm.yyyyy’, the time value you will recieve in another way. Read more»

September 25, 2019. Aleksei

TypeScipt / Javascript