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

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.

• ufw - Uncomplicated 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:

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!