SQL Server on Linux was released with version 2017. Since then, I've seen some deployments of SQL Server on Linux, but many of the customers I work with still deploy SQL Server on Windows. While there are limitations and unsupported features, most of what we need is available in SQL Server on Linux.
I assume most of you out there work on Windows machines against Windows servers. Maybe some of you run containers, but that's likely a minority. Windows seems to have won the desktop and for most of us running SQL Server, the server room as well.
However, if you use containers, you likely use Linux ones since SQL Server isn't supported on Windows containers. I know I do, and I like them, but overall, I find I need to know very little Linux to do my job, or even work with the containers.
I like Linux. As someone who learned Unix early on and installed Linux 0.8, I thought at one point I'd spend most of my career in that world. Especially as I worked with DOS and Windows 3.1 in corporate work and found them much less capable. I still remember writing grep.bat and awk.bat files to duplicate some of the things I did in Unix on DOS machines.
For doing database work, most platforms are ported to Windows, but even if you connect to an Oracle/PostgreSQL/MySQL/MongoDB/etc. system running on Linux, do you need much linux? I find that ls, pwd, and cat get me through most of the things I need to do. When there's something more complex, like sudo systemctl restart mssql-server, there are plenty of code snippets in the docs or some website. These days, you could even ask an AI how to do many simple tasks.
If you don't use Linux, then you don't need any, but if you deal with any sort of system running on Linux, how much is important to know? What's your top ten list of things a newbie should learn? Let us know today.