Uncategorized

  • Monitor SQL Server DB Processes

    If you don’t have DBArtisan or other more advanced SQL Editor, you can use the query below. Take note that you’ll need necessary rights to be able to run it. select spid, status, blocked, open_tran, waitresource, waittype, waittime, cmd, lastwaittype, cpu, physical_io, hostname, hostprocess, loginame, program_name, net_address, net_library, dbid, ecid, kpid, nt_domain, nt_username, uid, sid,…

  • Create New User in CentOS

    create the user syntax useradd -d [folder_name] -s /bin/bash -c “[name]” [userid] sample useradd -d /usr/kwatog/ -s /bin/bash -c “Kwatog Admin” kwatog set the password passwd kwatog clean up later