RE: Agnostic references for Oracle v SQl Server 2000

Well, it might be a smart move. From what I see on www.tpc.org, benchmarks on the lower end are usually performed with SQL Server 2000. DBA for SQL Server tend to be much cheaper for the organization then an oracle DBA. You can also get quite a decent support for SQL Server from a 3rd party and the total cost of ownership is very low for one or two PC servers. It is also a decent database, having row locking, hot backups and quite a decent version of SQL. Personally, I learned to love the temporary tables and I consider that logic to be much simpler for the duhveleopers then the Zen of SQL tuning that must be learned by the oracle duhvelopers.
Unfortunately, oracle didn't create particularly user-friendly database on the low end and people are baffled with the variety of options that they don't know or understand. Oracle was developed on the VMS platform and there are still remnants of the VMS influence (afiedt.buf), which means that it was, and unfortunately still is, tailored for the knowledge of an average VMS system administrator, which was, generally speaking, extremely high when compared to the knowledge necessary for successfully managing an NT server.

All that said, NT and Win2k have problems with security and stability. SQL Server is tied to that platform, so I wouldn't use it for 24x7 systems or high level transactional systems which need to process thousands of OLTP transactions per second. That is still oracle/DB2 playground.

> -----Original Message-----
> From: Martin Kendall [mailto:mkendall_at_oracle-rescue.com]
> Sent: Monday, September 23, 2002 4:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Agnostic references for Pracle v SQl Server 2000
>
>
> Hi Dennis,
>
> Personally I would like them not to move.
>
> Apart from all the Platform issues, they don't have ANY experience in
> .NET
> architecture and they only think it will be easier to
> administer the DB
> because they do not have any experienced Oracle DBA's in their employ.
>
> I am struggling to understand how they can possibly think of
> future-proofing their systems AND at the same time become a 100%
> Microsoft site.
>
> Martin
>
> -----Original Message-----
> WILLIAMS
> Sent: 23 September 2002 20:39
> To: Multiple recipients of list ORACLE-L
>
> Martin - If I understand your first statement, the database is now on
> Oracle
> and you are writing a paper on why they should move it to MS
> SQL Server.
> If
> this is true, and given your other statements about the
> client, I would
> think you could get plenty of reasons from the Microsoft web site. Or
> did
> you mean to say you are trying to give them reasons not to move?
>
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
>
>
> -----Original Message-----
> Sent: Monday, September 23, 2002 1:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hello all. I need to provide a one page report on why it may be
>
> beneficial for an organisation with light usage, small DB to move
>
> from Oracle to SQL Server. Their request is purely due to
>
> having a recognition of their charity status by Microsoft and
> therefore
> being able to get everything
>
> at a much reduced price.
>
>
>
> It is bad enough that they do not have experienced Oracle
> DBA's on site,
>
> now it seems that they are attracted by the apparent ease of use /
> setup/
> Graphical everything.
>
> They are even looking at adopting the same development
> technology as one
> of
> their main benefactors as this may help them
>
> win further funding from such a benefactor. I am talking .NET and VB.
>
>
>
> I am also asked to phrase my paper from the point of "future proofing"
> their
> business technology.
>
>
>
> I am struggling with the agnostic approach when taking into
> account the
> concept of "vendor lock-in".
>
>
>
> It seems that cost is everything. But they will need to accept that
> cost is
> not just what you pay
>
> for the base product.
>
>
>
> People, I am not really interested in a "religious war" on this - no
> doubt
> such discussion types
>
> have appeared on this List before. All I am asking for is pointers to
> any
> ref. material that you may know of.
>
>
>
> Happy days !
>
>
>
> Martin
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Martin Kendall
> INET: mkendall_at_oracle-rescue.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).