[dba-SQLServer] SQL Server versus Oracle

I work for a company that has both Oracle and SQL Server databases.
Both can handle large databases. Most reporting things can work with
either. Oracle generally runs in a UNIX environment although I think
there are also Windows versions available too. SQL Server needs
Windows based servers to run I think. Having both requires 2 sets of
database administrators and if you have Oracle On UNIX and SQL Server
on Windows server, then you need system administrator type people that
can deal with both of those worlds. If you need to you need to but if
you don't then you are going to be having two sets of geeks where you
could get away with one.  Or have a backup set for the one platform
you could be using. People that work with one or the other usually
think that the one they use is superior to the other and that the othe
is junk. That is how it is here. Our SQL Server DBA thinks everything
else is bad and the Oracle DBA's think that SQL Server is terrible.

GK

On 5/31/07, Elizabeth.J.Doering at wellsfargo.com
<Elizabeth.J.Doering at wellsfargo.com> wrote:
>
> Come to find out, I am speaking in 30 minutes about the virtues of SQL
> Server 2005 versus those of Oracle.  Given that my knowledge of Oracle
> could still dance comfortably on the head of a pin, I am frantically
> googling up details for my 'speech', and I would love to have your
> opinions
>
> I can easily say that we have already SQL Server and that Oracle is
> going to cost us $$$$$ that we hadn't budgeted for.  The thing I am most
> up against is a contention that 650 users are going to generate more
> data in a year or two than SQL Server can possibly hold.  I'm of the
> opinion that with a normalized database in a call center environment,
> users generating 10 or 12 records per call can go for years without
> seeing much if any slowdown.  Is this accurate?
>
> Oracle isn't being suggested for the production environment however.
> Oracle is being pushed for the REPORTING side of this system, for the 3
> or 4 analysts who will be looking at the long term performance of the
> folks in the call center.
>
> Is this making sense?  The production staff can live with SQL Server,
> but 3 or 4 analysts need the big bucks spent on Oracle for running their
> reports.
>
> Opinions, please?
>
>
> Thanks,
>
>
> Liz
>
>
> Liz Doering
> elizabeth.j.doering at wellsfargo.com
> 612.667.2447
>
>
> This message may contain confidential and/or privileged information. If
> you are not the addressee or authorized to receive this for the
> addressee, you must not use, copy, disclose, or take any action based on
> this message or any information herein. If you have received this
> message in error, please advise the sender immediately by reply e-mail
> and delete this message. Thank you for your cooperation.
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Gary Kjos
garykjos at gmail.com