SQL Server – Deadlock diagnosis in SQL Server – A very quick guide to locate problem

Do You have problems with deadlocks on SQL Server or on Portal Azure? Do You want locate problem in quick time? Below I present very quick guide how in the easiest way perform analyse without additional or sophisticated tools. In case of deadlocs, problem not bases on fixing problematic sql statements but on finding source […]

Read More SQL Server – Deadlock diagnosis in SQL Server – A very quick guide to locate problem
September 12th, 2017

Solved: SQL Server and problem with timezone for json results (FOR JSON PATH)

  If You use on SQL Server select statements with output result to json structure, for instance select * from Table FOR JSON PATH You may feel surprise in case of DATE type and for many developers  makes headache. The problem is losing time zone after converting data to json. For example: in the database we […]

Read More Solved: SQL Server and problem with timezone for json results (FOR JSON PATH)
May 4th, 2017

Total.js – Connection with SQL Server on Portal Azure

  One of the best node.js modules for connection to the SQL Server database on Azure Portal is mssql (https://www.npmjs.com/package/mssql). The documentation states that to connection with the database, we use the following construction connection string “mssql://username:password@localhost/database”. Problems begin in when we need to use the specific driver with which cooperates our database or we […]

Read More Total.js – Connection with SQL Server on Portal Azure
December 7th, 2016

SQL Server & Node.js REST API – Problem Solved – How send in parameters massive string datas longer then 2000 characters – error “Invalid precision value”

In case of SQL Server & Node.js Rest Api (when we use SQL Native Driver 10 or 11) when we try to send as parameter huge string that counting more then 2000 characters during DB CRUD operations we have got the error “Invalid precision value” – that means that length of string of our parameter […]

Read More SQL Server & Node.js REST API – Problem Solved – How send in parameters massive string datas longer then 2000 characters – error “Invalid precision value”
August 15th, 2016