Author: Naveen Nayak

Installing nodejs on CentOS 7 with NVM

Naveen Nayak November 8, 2018 No Comments Javascript, Web Development ,

Using NVM(Node Version Manager) we can have multiple nodejs versions and switch between them quickly. I am doing this on CentOS 7. # install nvm curl -o- https://raw.githubusercontent.com/creationix/nvm/v0.33.11/install.sh | bash # open a new terminal and check the version nvm –version # install latest node LTS and check version nvm install –lts node –version npm […]

MSSQL: Session and Request info, Blocking sessions

Naveen Nayak September 17, 2018 No Comments MSSQL, Tips and Tricks

Here is a list of queries that can be helpful if you are trying to troubleshoot locks and blocking sessions on SQL server. — to get session and connections on the server SELECT * FROM sys.dm_exec_sessions AS sess JOIN sys.dm_exec_connections AS conn ON ( sess.session_id = conn.session_id ); — another command to see details EXEC […]

SQL substring replacement

Naveen Nayak May 14, 2018 No Comments MySQL, Tips and Tricks

There are times when you need to replace only a part of the string in the database column. You can use the stuff() function in MSSQL or insert() function in MySQL MSSQL Definition: STUFF ( string , start , length , replaceWith ) Example: select stuff(‘My Original String’, 4, 8, ‘Replaced’); Output: My Replaced String […]

Centos7 cleaning boot partition

Naveen Nayak March 20, 2018 No Comments Linux

Boot partition might be full as it stores old kernels etc. To clean it up and store only the latest 2 kernels do the below Take a backup of your /boot partition somewhere first edit /etc/yum.conf and set installonly_limit=2  # install yum utilities  yum install yum-utils # cleanup old kernels  package-cleanup –oldkernels –count=2

Page 1 of 13