Recently i was thinking about Oracle, beacuse right now I'm MS SQL DBA/DEVELOPER.
Some people said that oracle is future, and i'm little bit confused.
Can Senior members in SQL Server advise if i should move to Oracle or stay with SQL Server
Thank you !
From the development side I say that if you can get really good with one flavor of SQL you can do well with any flavor of SQL. E.g. If you get really good with Window Functions that skill will port over nicely to any version of SQL. The various flavors of SQL are different but many concepts are the same across board. I do some AWS Redshift work, for example, which involves Postgres SQL and it was easy to pick up.
Oracle is pretty big but I think Microsoft is and will remain more popular. I also think you're going to see more stuff happening in the Cloud. AWS is huge, Azure is growing fast, Google is getting in the SQL Server in the cloud game too. That's the future in my opinion but MS SQL Server isn't going anywhere.
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001