Linux

hi,

I want to change my career path from Windows sys admin to Linux admin (or a hybrid).
I did certification on RH Admin and RH Eng. Now when I look at job adds they are asking for MYSQL or SQL. I am a bit confused now.I know MSSQL. Not a expert but can get away with it.
In order to get a job in Linux should I work on MSSQL or MYSQL. Reason for my question is MYSQL is open source and Red Hat is an open source as well. When they are asking for SQL in job adds, do they mean MYSQL or is the case that MSSQL being popular people connect Red Hat to MSSQL DB.
LVL 1
ukitsmeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lee W, MVPTechnology and Business Process AdvisorCommented:
You have to read the ad.  They are asking for SQL - could be MySQL, PostGRES SQL, SQLLite, Oracle, MS-SQL, IBM DB2... it depends on what they use.
0
ukitsmeAuthor Commented:
please note I am talking generally.
0
ukitsmeAuthor Commented:
My question is if they are using Red Hat how can they connect to MS SQL. I am talking about the current market.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Lee W, MVPTechnology and Business Process AdvisorCommented:
I'm talking generally as well.  ODBC - Open Database Connectivity.  Most SQL databases are ODBC compliant and have drivers on most platforms.  So they could use whatever they want.
0
arnoldCommented:
Agree with Lee, as long as you have some and can quickly learn, you should be fine.

MySQL can run on multiple/many platforms.

A sysadmin has the most/broadest responsibility. I.e. You are not solely responsible for the server starting/booting the OS.
Most times you are or should be aware of what functions this server performs on which other servers and server roles each application depends relies.  One if such is the backend DB. Further, you would be the troubleshooter to identify the issue before it gets escalated to a more specialized ......

When something is reported to you with an issue with the above referenced info you will be in a good position to narrow the issue down. With SQL skills you would be able to determine if the issue is a DB, to query it as an example to determine whether it is something you can resolve or a DBA needs to be called in.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
arnoldCommented:
Oh, there is freetds as well as other odbc type tools including commercially available that could would fascilitate a connection.
ms sql has also included XML support and there are ways to setup paths for queries........
0
Dave BaldwinFixer of ProblemsCommented:
Microsoft has written a driver for RedHat to connect to Microsoft SQL Server.  See here: https://msdn.microsoft.com/en-us/library/hh568451.aspx
0
Tom ChadaraviciusSenior DeveloperCommented:
I have installed the Microsoft driver Dave has mentioned, I have had it running since spring. I have wrapped it into ODBC and PDO class (PHP).
If you have a rather standard MS SQL server, you may want to use mssql module in PHP. Adjust FreeTDS to version 7.1 or above.
0
ThomasMcA2Commented:
I suggest installing a LAMP server, and experiment with MySQL from that server. Note that the "server" can be any flavor of Linux, such as RedHat, Ubuntu, OpenSUSE, etc.

I like to run a LAMP server as the primary OS on my laptop, and I run Windows 7 in a VM. Learning virtualization would also help with Linux administration.

I run a personal wiki (there are many to choose from) on my laptop, which I use as my personal kbase. I access the wiki from both the Linux host and the Windows guest. The back-end data for that wiki is stored in a MySQL database, which I backup via shell scripts.
0
ukitsmeAuthor Commented:
Thanks for your help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.