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!
“sudo – runs a program or command with escalated user permissions.”
Should probably read “with elevated user permissions.”
Thank you Steve for helpful share !!