| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: microsoft sql vs. oracle
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C07739.D05BEB20
Content-Type: text/plain;
charset="iso-8859-1"
I have heard from a very bright MS
field engineer that a surface-level
understanding of SS2K is indeed like
this, but, when I asked him if there
were "dials and knobs" to tweak the
database, he assured me there were
tons of them, but most were hidden
from the, er, "casual observer".
This is good for two reasons.
One is that the casual observer should
keep his freakin' fingers out of the db engine.
Another is that it *is* self-tuning,in some areas
to an extent that oracle isn't quite yet, and
so why do you want "the right hand" turning the
dials while "the left hand" is, too?
In any case, punchline: Don't underestimate something until you know it well. I know just enough about ss2k ( very little ) to approach it with respect. Odd thing is, once we know something (or indeed someONE! ) well, we are more likely to respect its unique set of abilities.
my "dwy ceinoig"
-----Original Message-----
From: mRT Bonner [mailto:ravendarke2000_at_yahoo.com]
Sent: Friday, January 05, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: microsoft sql vs. oracle
I think the single biggest difference (of many) between MSSQL Server and Oracle is the level of control you have over what the database is doing. MS continues update SQL Server with one thought in mind, 'Get rid of the DBA'. That's their pitch, in a lot of cases. DBA's are expensive. MS SQL Server is written so the coders can handle the database. And that's fine, if that's what you are looking for. If you need it to do something that MS hasn't forseen, however, you kind of have to go around your head to get to your rear.
Martin Bonner
Oracle DBA
Ex-MS SQL Server DBA
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mRT Bonner INET: ravendarke2000_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). ------_=_NextPart_001_01C07739.D05BEB20 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>RE: microsoft sql vs. oracle</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>I have heard from a very bright MS</FONT> <BR><FONT SIZE=2>field engineer that a surface-level</FONT> <BR><FONT SIZE=2>understanding of SS2K is indeed like </FONT> <BR><FONT SIZE=2>this, but, when I asked him if there </FONT> <BR><FONT SIZE=2>were "dials and knobs" to tweak the</FONT> <BR><FONT SIZE=2>database, he assured me there were</FONT> <BR><FONT SIZE=2>tons of them, but most were hidden</FONT> <BR><FONT SIZE=2>from the, er, "casual observer".</FONT> </P> <P><FONT SIZE=2>This is good for two reasons. </FONT> <BR><FONT SIZE=2>One is that the casual observer should</FONT> <BR><FONT SIZE=2>keep his freakin' fingers out of the db engine.</FONT> <BR><FONT SIZE=2>Another is that it *is* self-tuning,in some areas</FONT> <BR><FONT SIZE=2>to an extent that oracle isn't quite yet, and</FONT> <BR><FONT SIZE=2>so why do you want "the right hand" turning the</FONT> <BR><FONT SIZE=2>dials while "the left hand" is, too?</FONT> </P> <P><FONT SIZE=2>In any case, punchline: Don't underestimate something</FONT> <BR><FONT SIZE=2>until you know it well. I know just enough about ss2k</FONT> <BR><FONT SIZE=2>( very little ) to approach it with respect. Odd thing</FONT> <BR><FONT SIZE=2>is, once we know something (or indeed someONE! ) well, </FONT> <BR><FONT SIZE=2>we are more likely to respect its unique set of abilities. </FONT> </P> <P><FONT SIZE=2>my "dwy ceinoig"</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: mRT Bonner [<A HREF="mailto:ravendarke2000_at_yahoo.com">mailto:ravendarke2000_at_yahoo.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Friday, January 05, 2001 10:56 AM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: Re: microsoft sql vs. oracle</FONT> </P> <BR> <P><FONT SIZE=2>I think the single biggest difference (of many)</FONT> <BR><FONT SIZE=2>between MSSQL Server and Oracle is the level of</FONT> <BR><FONT SIZE=2>control you have over what the database is doing. MS</FONT> <BR><FONT SIZE=2>continues update SQL Server with one thought in mind,</FONT> <BR><FONT SIZE=2>'Get rid of the DBA'. That's their pitch, in a lot of</FONT> <BR><FONT SIZE=2>cases. DBA's are expensive. MS SQL Server is written</FONT> <BR><FONT SIZE=2>so the coders can handle the database. And that's</FONT> <BR><FONT SIZE=2>fine, if that's what you are looking for. If you need</FONT> <BR><FONT SIZE=2>it to do something that MS hasn't forseen, however,</FONT> <BR><FONT SIZE=2>you kind of have to go around your head to get to your</FONT> <BR><FONT SIZE=2>rear.</FONT> </P> <P><FONT SIZE=2>Martin Bonner</FONT> <BR><FONT SIZE=2>Oracle DBA</FONT> <BR><FONT SIZE=2>Ex-MS SQL Server DBA</FONT> </P> <P><FONT SIZE=2>--- bunyamin karadeniz <bunyamink_at_havelsan.com.tr></FONT> <BR><FONT SIZE=2>wrote:</FONT> <BR><FONT SIZE=2>> I do not agree with you Abdul</FONT> <BR><FONT SIZE=2>> Because , Yes You said that MS Sql server only</FONT> <BR><FONT SIZE=2>> works on MS Platforms .That</FONT> <BR><FONT SIZE=2>> is true .</FONT> <BR><FONT SIZE=2>> But do not forget that ORACLE has platform</FONT> <BR><FONT SIZE=2>> problems too.</FONT> <BR><FONT SIZE=2>> For ex. you will publish your application</FONT> <BR><FONT SIZE=2>> developed in oracle forms in</FONT> <BR><FONT SIZE=2>> internet , DB Server + OAS + Forms Server( if there</FONT> <BR><FONT SIZE=2>> are version problems in</FONT> <BR><FONT SIZE=2>> forms and OAS ) You have to set these up. You have</FONT> <BR><FONT SIZE=2>> to configure lots of</FONT> <BR><FONT SIZE=2>> thing . That is a trouble . But after you setup sql</FONT> <BR><FONT SIZE=2>> server and iis . You can</FONT> <BR><FONT SIZE=2>> write applications in asp,asp+,jscript....... and</FONT> <BR><FONT SIZE=2>> embed into iis. No such</FONT> <BR><FONT SIZE=2>> complicated configurings.</FONT> <BR><FONT SIZE=2>> **********************************************</FONT> <BR><FONT SIZE=2>> Bunyamin K. Karadeniz</FONT> <BR><FONT SIZE=2>> Information Technologies Dept.</FONT> <BR><FONT SIZE=2>> Database Group Tel :90-312-2873565/1681</FONT> <BR><FONT SIZE=2>> HAVELSAN Ankara / TURKEY</FONT> <BR><FONT SIZE=2>> **********************************************</FONT> <BR><FONT SIZE=2>> ----- Original Message -----</FONT> <BR><FONT SIZE=2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>> <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=2>> Sent: Friday, January 05, 2001 1:00 PM</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> > Claudia,</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > Oracle is in Database business since 1976 (if I am</FONT> <BR><FONT SIZE=2>> not wrong) when</FONT> <BR><FONT SIZE=2>> Microsoft</FONT> <BR><FONT SIZE=2>> > was not born. With Oracle you have openness to all</FONT> <BR><FONT SIZE=2>> popular (most stable to</FONT> <BR><FONT SIZE=2>> > less stable and shareware) operating systems.</FONT> <BR><FONT SIZE=2>> Where as with SQL you are</FONT> <BR><FONT SIZE=2>> > limiting yourself to MS.</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > Oracle has its own line of products closely</FONT> <BR><FONT SIZE=2>> integrated to each other</FONT> <BR><FONT SIZE=2>> > Designer / Forms / Reports / JDeveloper/ Database</FONT> <BR><FONT SIZE=2>> / Application Server / .</FONT> <BR><FONT SIZE=2>> > Etc. MS does not have such line of product.</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > To my understanding if you use designer, it will</FONT> <BR><FONT SIZE=2>> generate the complete web</FONT> <BR><FONT SIZE=2>> > enabled application. If you use Application Server</FONT> <BR><FONT SIZE=2>> your application is up</FONT> <BR><FONT SIZE=2>> on</FONT> <BR><FONT SIZE=2>> > the Internet or Intranet.</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > In short Oracle has tools that help you design</FONT> <BR><FONT SIZE=2>> business application in</FONT> <BR><FONT SIZE=2>> > minimum possible time for any platform and</FONT> <BR><FONT SIZE=2>> configurations.</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > HTH!</FONT> <BR><FONT SIZE=2>> > Aleem</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > -----Original Message-----</FONT> <BR><FONT SIZE=2>> > Sent: Friday, January 05, 2001 3:11 AM</FONT> <BR><FONT SIZE=2>> > To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>> > Subject: microsoft sql vs. oracle</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > I know this may be a very obvious question, but I</FONT> <BR><FONT SIZE=2>> need to know what would</FONT> <BR><FONT SIZE=2>> > you use oracle vs. miscrosoft sql?</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > Is microsoft sql capable of storing images?</FONT> <BR><FONT SIZE=2>> > What is the maximum storage for oracle vs.</FONT> <BR><FONT SIZE=2>> microsoft?</FONT> <BR><FONT SIZE=2>> > etc...</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > Thanks in advance.</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > --------------Claudia Rivera-----------------</FONT> <BR><FONT SIZE=2>> > DMC, Tech. Media Coordinator</FONT> <BR><FONT SIZE=2>> > crivera_at_utep.edu</FONT> <BR><FONT SIZE=2>> > http://dmc.utep.edu</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > --</FONT> <BR><FONT SIZE=2>> > Please see the official ORACLE-L FAQ:</FONT> <BR><FONT SIZE=2>> http://www.orafaq.com</FONT> <BR><FONT SIZE=2>> > --</FONT> <BR><FONT SIZE=2>> > Author: Rivera, Claudia</FONT> <BR><FONT SIZE=2>> > INET: crivera_at_utep.edu</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > Fat City Network Services -- (858) 538-5051 </FONT> <BR><FONT SIZE=2>> FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>> > San Diego, California -- Public Internet</FONT> <BR><FONT SIZE=2>> access / Mailing Lists</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>> > To REMOVE yourself from this mailing list, send an</FONT> <BR><FONT SIZE=2>> E-Mail message</FONT> <BR><FONT SIZE=2>> > to: ListGuru_at_fatcity.com (note EXACT spelling of</FONT> <BR><FONT SIZE=2>> 'ListGuru') and in</FONT> <BR><FONT SIZE=2>> > the message BODY, include a line containing: UNSUB</FONT> <BR><FONT SIZE=2>> ORACLE-L</FONT> <BR><FONT SIZE=2>> > (or the name of mailing list you want to be</FONT> <BR><FONT SIZE=2>> removed from). You may</FONT> <BR><FONT SIZE=2>> > also send the HELP command for other information</FONT> <BR><FONT SIZE=2>> (like subscribing).</FONT> <BR><FONT SIZE=2>> > --</FONT> <BR><FONT SIZE=2>> > Please see the official ORACLE-L FAQ:</FONT> <BR><FONT SIZE=2>> http://www.orafaq.com</FONT> <BR><FONT SIZE=2>> > --</FONT> <BR><FONT SIZE=2>> > Author: Abdul Aleem</FONT> <BR><FONT SIZE=2>> > INET: abchaudhary-ho_at_beaconhouse.edu.pk</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> > Fat City Network Services -- (858) 538-5051 </FONT> <BR><FONT SIZE=2>> FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>> > San Diego, California -- Public Internet</FONT> <BR><FONT SIZE=2>> access / Mailing Lists</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>> > To REMOVE yourself from this mailing list, send an</FONT> <BR><FONT SIZE=2>> E-Mail message</FONT> <BR><FONT SIZE=2>> > to: ListGuru_at_fatcity.com (note EXACT spelling of</FONT> <BR><FONT SIZE=2>> 'ListGuru') and in</FONT> <BR><FONT SIZE=2>> > the message BODY, include a line containing: UNSUB</FONT> <BR><FONT SIZE=2>> ORACLE-L</FONT> <BR><FONT SIZE=2>> > (or the name of mailing list you want to be</FONT> <BR><FONT SIZE=2>> removed from). You may</FONT> <BR><FONT SIZE=2>> > also send the HELP command for other information</FONT> <BR><FONT SIZE=2>> (like subscribing).</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> -- </FONT> <BR><FONT SIZE=2>> Please see the official ORACLE-L FAQ:</FONT> <BR><FONT SIZE=2>> http://www.orafaq.com</FONT> <BR><FONT SIZE=2>> -- </FONT> <BR><FONT SIZE=2>> Author: bunyamin karadeniz</FONT> <BR><FONT SIZE=2>> INET: bunyamink_at_havelsan.com.tr</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Fat City Network Services -- (858) 538-5051 FAX:</FONT> <BR><FONT SIZE=2>> (858) 538-5051</FONT> <BR><FONT SIZE=2>> San Diego, California -- Public Internet</FONT> <BR><FONT SIZE=2>> access / Mailing Lists</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>> To REMOVE yourself from this mailing list, send an</FONT> <BR><FONT SIZE=2>> E-Mail message</FONT> <BR><FONT SIZE=2>> to: ListGuru_at_fatcity.com (note EXACT spelling of</FONT> <BR><FONT SIZE=2>> 'ListGuru') and in</FONT> <BR><FONT SIZE=2>> the message BODY, include a line containing: UNSUB</FONT> <BR><FONT SIZE=2>> ORACLE-L</FONT> <BR><FONT SIZE=2>> (or the name of mailing list you want to be removed</FONT> <BR><FONT SIZE=2>> from). You may</FONT> <BR><FONT SIZE=2>> also send the HELP command for other information</FONT> <BR><FONT SIZE=2>> (like subscribing).</FONT> </P> <BR> <P><FONT SIZE=2>__________________________________________________</FONT> <BR><FONT SIZE=2>Do You Yahoo!?</FONT> <BR><FONT SIZE=2>Yahoo! Photos - Share your holiday photos online!</FONT> <BR><FONT SIZE=2>http://photos.yahoo.com/</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: mRT Bonner</FONT> <BR><FONT SIZE=2> INET: ravendarke2000_at_yahoo.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>Received on Fri Jan 05 2001 - 11:06:15 CST
 |
 |