Skip to Content
24x7 Support
Email: mail@example.com
Call Us +(21) 1234 5678

    • Home
    • MSSQL
      • SQL On Linux
      • T-SQL Scripts
    • Sybase ASE
      • Sybase Scripts
    • Sybase Replication
    • Sybase IQ
    • Linux
    • Search for:

    Category Archives: Linux

    1. Home  - 
    2. Archive by category "Linux"
    16 Sep, 2021
    How to read Unix Top command output 0 (0)
    Linux, MSSQL How to read Linux top command, SQL on Linux, SQL Server on Linux

    Linux top command is frequently used command in our daily BAU support and we use it to understand the resource utilization by different processes on Linux server.

    In this article, we will see how to read the top command output, … Read the rest

    1 Aug, 2020
    Useful Find command in Unix 0 (0)
    Linux

    #Search the file with its name

    $ find ./test -name "1.txt"
    ./test/subdir/1.txt

    #to search for specific files from specific directories/sub directories.

    $ find /home1/test -type f -exec grep -l 1.html {} \;

    wildcards can be used to search for specific

    … Read the rest
    1 Aug, 2020
    How to get top space consuming files and directories in Linux and Sun Solaris 0 (0)
    Linux

    As a DBA, many a times we need to know what files and directories are consuming more space on our unix file system.

    In this article, i will try to share to share the commands that are used to achieve … Read the rest

    1 Aug, 2020
    Display Nth line of a file in Linux 0 (0)
    Linux

    There are multiple ways to get the Nth line of a file but below are the most used commands.

    1. Sed

    Let's consider the below input file

    $ cat file1

    mango
    apple
    grapes
    banana
    strawberry
    papaya
    orange
    cherry

    #to print 4th

    … Read the rest
    1 Aug, 2020
    Using multiple variables from a file and loop in shell scripts 0 (0)
    Linux

    There are several ways to read a file in loop, here are few of them with examples

    consider my input file is as below

    FileName: file1

    File Content:

    A B C
    D E F
    G H I
    J … Read the rest

    1 Aug, 2020
    How to replace all white space with comma in a text file 0 (0)
    Linux

    for example, i have a text file like below

    test1 test2
    test3 test4
    test5 test6

    i want my text file to look like as below

    test1,test2
    test3,test4
    test5,test6

    use below sed function to achieve the result.

    sed -e 's/\s+/,/g' old … Read the rest

    1 Aug, 2020
    How to remove spaces between lines from a file 0 (0)
    Linux

    for example, i have a file like below

    test1 test2

    test3 test4

    test5 test6

    i want my output to look like as below

    test1 test2
    test3 test4
    test5 test6

    use below sed function to achieve the result.

    sed '/^ *$/d'

    … Read the rest
    1 Aug, 2020
    Splitting one file into multiple and running them in parallel. 0 (0)
    Linux

    Syntax:

    split -d -l <no. of lines> <input file> <prefix name>

    Example:

    split -d -l 3 testsplit.txt testsplit.txt.

    here, '-d' option will split files with numeric suffix like x00, x01, … x0n

    here, '-l' is used to split a file … Read the rest

    Recent Posts
    • SQL Server: T-SQL Script to find object level permission of specific table
    • SQL Server: T-SQL Script to find object level permission of user database
    • T-SQL Script to get user with DB OWNER role in SQL Server
    • T-SQL script to list all database user access in SQL Server
    • T-SQL script to find active processes in SQL Server

    Pages

    • About Me
    • Contact
    • Disclaimer
    • Privacy Policy

    Categories

    • Linux (8)
    • MSSQL (75)
      • SQL On Linux (15)
      • T-SQL Scripts (19)
    • Sybase ASE (26)
      • Sybase Scripts (1)
    • Sybase IQ (3)
    • Sybase Replication (27)
    • Uncategorized (1)

    Archives

    Copyright © 2025 | Powered by Neom