Agrippa Solutions from Norway (https://www.agrippa.no) is listed on official site expressjs.com and selected from all companies over the world. I am proud that I can co-create solutions (as our company – JRB SYSTEM) on node.js and work in such a wonderful team https://expressjs.com/en/resources/companies-using-express.html
Read MoreAgrippa Solutions from Norway (https://www.agrippa.no) is listed on official site expressjs.com and selected from all companies over the world.
How split single text with delimiter or multiline from column/cell into multiple rows? In case of massive data, the performance is very important and has high priority, so we focus on solution which we can use in production environment. The solution bases on created function on MS SQL server, presented below on attached screen: CREATE FUNCTION […]
Read MoreSOLVED: Massive Data – How split single text with delimiter or multiline from column/cell into multiple rows
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 MoreSQL Server – Deadlock diagnosis in SQL Server – A very quick guide to locate problem
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 MoreSolved: SQL Server and problem with timezone for json results (FOR JSON PATH)
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 MoreTotal.js – Connection with SQL Server on Portal Azure
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 MoreSQL Server & Node.js REST API – Problem Solved – How send in parameters massive string datas longer then 2000 characters – error “Invalid precision value”
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.