Linux commands for SQL DBA’s who don’t know Linux (yet)

Download PDF

With SQL Server now being available (pre-release) on Linux, I think we will see many SQL DBA’s who previously did not have Linux experience being forced into a new area. I am lucky in that I have had my share of Linux experience over my career, it has come easy to me. I figured I would share some Linux nuggets for those SQL DBAs diving into the Linux pool.

  • ls - List directory contents. Similar to dir on Windows.
  • top  - Sort of like the Windows task manager, shows you the top applications using cpu and memory.
  • sudo - runs a program or command with escalated user permissions.
  • apt-get - used to install a program. Kinda like the windows "add or remove programs" without the graphical interface.
  • ufwUncomplicated Firewall, is a front-end to iptables. Use this to allow or prevent port access to your Linux Server.
  • ps - processes.  Provides information on currently running process. For instance ps aux shows all running processes.
  • man - gets help on any of the Linux commands. For instance man ps provides the help page for the ps application.

That’s it for now, I will continue to grow this list as I have time.

 

More from Stedman Solutions:

SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

2 Comments on “Linux commands for SQL DBA’s who don’t know Linux (yet)

  1. “sudo – runs a program or command with escalated user permissions.”

    Should probably read “with elevated user permissions.”

Leave a Reply

Your email address will not be published. Required fields are marked *

*