Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Career Advice, Oracle or SQL Server

Mar 9, 2016 12:10PM PST

Hi,

I'm looking for some advice, currently employed as a SQL Analyst looking to move in to BI and gain MCSE status over the next couple of years but I have been offered a very exciting Junior BI role for a large insurance company that offers a 6 month fast track program and the opportunity to work with large amounts of data that I don't do at the moment. However all the work I have done has been T-SQL and I would like to continue with Microsoft, people say that SQL is interchangeable and if I took this role I would like to continue with my Microsoft Certs and look at a Microsoft BI role in the future. I just wanted to ask for any advice or experience on the reality on moving from one RDBMS to another and if people have done that, how did they get on or do people feel they have missed on a position because they are more towards the other.

Any help will be appreciated.

Discussion is locked

- Collapse -
Let's see how big a change it was for this app.
Mar 9, 2016 12:42PM PST
- Collapse -
Well my organization uses MS SQL and we have over 200
Mar 11, 2016 5:54AM PST

databases. As far as Oracle versus MS SQL alot of companies use Oracle for huge databases with over 1,000,000 records. I work with applications and sometimes when I create software specs i design queries for the developers to add to their code. Basically the core SQL will be the same with MS versus Oracle but the functions and formatting maybe different. Almost all SQL use the Select **** from DB where type statements. The number of DB we have has increased the number of DBA's we have now. Our DBA's have to troubleshoot when databases go off line, manage backup, control rights, some organization use SQL express in cleints and sync to a central SQL server using publications and subscriptions. MS tends to release a new version every 2 years after SQL 2012.

Now one thing that will affect the industry is the cloud. The cloud is moving the databases from your internal organizations to the big cloud companies. The more the cloud becomes a strandard the more important integration between system becomes more important. The cloud compnaies will will still need the database professional but the companies that used to keep their own databases won't need DBA's as much. There will always be a need for DBA's just who needs them can change.

- Collapse -
Re: Career Advice, Oracle or SQL Server
Mar 30, 2016 11:22PM PDT

I prefer BI is the best choice than SQL Server, even though both has great career growth, but you need to do lot of skill work on BI role, most of the brilliants are in the BI department of any firm.