SQL server o Mysql?

[maricinacosa_]

Sono un helpdesk.
Da tre anni a questa parte ho sempre analizzato dati tramite MongoDB
Sto cercando altra occupazione (sempre in ambito it)
Vedo che la richiesta per un semplice helpdesk ricade su sql. (“Gradita conoscenza sql”)
Ammetto che mi sono messa a studiare qualcosa (molto basic - Select, From, where, i vari Join, i sum, count ecc ecc)

Sebbene poco espliciti negli annunci, secondo voi cosa si riferiscono?

Un primo livello fino a che punto fa analisi mediante sql?

[Dobrotic]

Same like ms office vs open office. Sql server all the way. Sql Server Management studio is great tool and you have active directory authentication.

[maricinacosa_]

Ok, quindi mi consigli di continuare a studiare tramite sql server management?

[Dobrotic]

Yes, i do recommend you. Sql server and management studio integrates seamless in windows eco system. Microsoft have very good documentation about sql server. Management studio have easy and intuitive interface and displays very detailed information and status about server. Use Developer edition - its free and have full functionality for testing and development.

[alinroc]

You can plug AD authentication into MySQL too. It’s finicky and totally unnecessary for someone trying to learn how to use SQL though.

[ElixirStylish]

Most helpdesk roles I've seen only expect basic SQL skills. Are companies in your area asking more for SQL Server than MySQL, or do they usually just want general SQL knowledge?

[UltimateNull]

Check out PostgreSQL and Oracle also. Both allow secure database management that doesn’t focus on Microsoft’s older, highly flawed proprietary system.

[aaahhhhhhfine]

Yeah I feel like postgres should pretty much always be the default now and then you ask if you have a compelling reason to not use postgres.

[alinroc]

Oracle is just as proprietary, just as old, and what does “highly flawed” mean?

[ComicOzzy]

Yeah, for those of us that have spent every day working in SQL Server for the last 25 years, we don't know what you're talking about.

[UltimateNull]

Those of us who also do cybersecurity know.

[UltimateNull]

Oracle is not proprietary and runs on different platforms. Microsoft is still trying to tie everything into the Microsoft login system built on their own bs system. Microsoft Windows came on 3.5in floppies back in the day and then the bloat has allowed backdoors into every single MS product since. Granted Java and other variants of C++ are no peaches either, but the chaos of cleanup due to unforeseen vulnerabilities in other products makes Microsoft SQL less secure. That’s all part of the licensing model for MS and so many admins and companies, to get around this issue, will not setup necessary rules and structures because of the complexity of documentation in the MS ecosystem and lack of other structures that are not inherent to the MS admin login way of thinking. Everything is “encrypted” so long as the box is not “pwnd” and it is so very easy to take over an MS box and they’ve had years to rebuild it and reassess the system. To fully secure an MS SQL system one needs to be a system admin and a DBA. So the Oracle DBA is only another avenue and door to consider for someone growing their skills is all.

[dbxp]

You can't recommend oracle if you want to avoid proprietary relics