MS SQL vs Oracle

  • HI All,

    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 !

  • What you do is entirely up to you. Search the jobs in your area for both SQL Server and Oracle. Take the certification exams if that's what floats your boat. Decide which one you like better or offers better opportunities for you.

  • the thing is that i wonder more about market itself. Which Technology will lead in databases in future.

  • People who say that Oracle is the future are probably people that already work with Oracle or just got certified on Oracle. The truth is that I'd have more confidence in a product that has been constantly growing to reach the top, rather than in a product that has been leader but lost the great advantage it one had. Both will live for a long time, I wouldn't choose one over the other just for market.

    Maybe this article should help support my personal choice on SQL Server.

    https://blogs.technet.microsoft.com/dataplatforminsider/2015/10/15/gartner-positions-microsoft-as-a-leader-in-the-magic-quadrant-for-operational-database-management-systems/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • raven066 (3/3/2016)


    HI All,

    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

  • SQL Server seems to be growing steadily.

    The recent announcement that SQL Server will be available on the Linux OS gives me even more confidence that Microsoft is making the right moves for the SQL Server platform.

    However, if you were to become a competent Oracle developer also, in addition to your SQL Server skills, you would be golden. Many companies have both flavors of database in their environment. So knowing both of them makes you extremely valuable.

  • This is like asking if you should get a Honda or a Toyota. They are both pretty good at what they even if they are slightly different on the outside. Saying one has a better future than the other is a discussion that has no purpose. Pick one, get really good with it and stick with it.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • raven066 (3/3/2016)


    HI All,

    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 !

    Just to confirm, are you referring to the city of Oracle, Arizona ?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • raven066 (3/3/2016)


    Some people said that oracle is future, and i'm little bit confused.

    Frankly, it seems like Amazon is the future.

    As my next database platform, I am tempted to become an expert in AWS data platforms.

    DynamoDB (nosql), Red Shift (OLAP) and Aurora (OLTP).

  • I think it depends on where you live. For example, Oracle seems to be much more popular than SQL Server in the San Francisco Bay Area. Then again, Oracle has a "home team" advantage here. Your experience may be different.

    As far as "the future," I don't think it belongs to Oracle or SQL Server. The future belongs to Big Data and the Cloud.

  • SeattleDBA (4/21/2016)


    raven066 (3/3/2016)


    Some people said that oracle is future, and i'm little bit confused.

    Frankly, it seems like Amazon is the future.

    As my next database platform, I am tempted to become an expert in AWS data platforms.

    DynamoDB (nosql), Red Shift (OLAP) and Aurora (OLTP).

    And RedShift is PostgreSQL. So what you really mean to say is that PostgreSQL is the future right? :w00t:

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply