| 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:RE: SQL SERVER
Frank,
There may well se a lot of VB programmers out there, but with a littl=
e
patience they are converted from SQL*Server to Oracle. The real nice par=
t is
that once converted they don't want to go back.
Dick Goulet
____________________Reply Separator____________________Subject: RE: SQL SERVER
I am having the same experience. Due to "TCO" factors they say. BTW there=
is
a very good article on Oracle's website concerning TCO and Oracle. The
article makes a good argument that when the smoke clears and you are runn=
ing
your application in production, Oracle has a lower TCO. MS just lowers th=
eir
initial cost and managers that don't know the difference bite. I think th=
at
the push towards MS SQL Server is also due to the large volume of VB
programmers there are. They don't want to learn anything new and SQL Serv=
er
(more like MS Access on steroids) is familiar to them. VB is a very power=
ful
language and can do some amazing things, but it is not like coding in C o=
r
C++.
I have not started administering the MS SQL Server DB yet but will probab=
ly
have to submit at some point.
In my opinion, there are many differences between MS SQL Server 7 and
Oracle. Most are in the area of scalability and performance. Backup and
recovery is different and not as secure as one can design an Oracle backu=
p
to be. Basically, SQL Server is built like most other M$ products, they t=
ake
out all the guess work, put in more wizards and "help" you do your job
better. Of course, to have any real power or scalability etc. you need to=
get under the covers which you cannot do with MS. I am no expert in MS SQ=
L
Server, but I will bet you that the new TPC performance numbers that MS
posted last month (even though they later pulled them) were not produced =
on
a standard install of MS SQL Server, using visual tools only. They spent
PLENTY of time tweaking every OS settings and underlying structure that t=
hey
could (sounds like everyday Oracle administration doesn't it?).
Wow, I don't think I have written this much to the list in 3 years, must have been a good cup of coffee this a.m.
my 2 cents,
Frank Pettinato
Oracle DBA
Intel Corp.
-----Original Message-----
BoivinP_at_mar.dfo-mpo.gc.ca
Sent: Wednesday, August 02, 2000 5:06 AM
To: Multiple recipients of list ORACLE-L
I am not sure, but I think that in SQL Server there is no Archiver proces=
s,
what you do is a "backup" of the transaction log (read: redo log file).
Then if the disk holding the transaction log has to be replaced, you need=
to
restore that backup if you recover your database after a hardware failure=
=2E
Also they keep stressing that setting autoextend for files saves the DBA
from having to extend files all the time, but beware of this (as you shou=
ld
in Oracle) because the transaction log can grow and grow and grow and ..=
=2E
Then to reduce its size you will have to back it up, and truncate the
transaction log. It won't happen right away, I think you have to wait un=
til
the next checkpoint for the log to shrink back to a reasonable size.
The SQL Server command syntax is different from Oracle's, but you will ge=
t
used to that pretty quickly. Go go go ol=E9 ol=E9 ol=E9 (sorry, it's ea=
rly in
the morning)
Oh and as usual for Microsoft, a "device" is not a device, it's a pointer=
to
a device. Like the printer in your Printers applet in Windows - Microsof=
t
calls the printer icon and the code underlying it a "device" even though =
you
need a REAL PRINTER to print. I don't know why they declared that a litt=
le
bit of code is a device, makes no sense to me! Their focus is obviously =
the
code they write, not the physical devices they are referring to. To the
point where they forgot that the hardware actually does the work.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-----Original Message-----
From: Christine Turner [SMTP:Christine.Turner_at_IPS-Sendero.com]
Sent: Tuesday, August 01, 2000 8:35 PM
To: Multiple recipients of list ORACLE-L
Subject: SQL SERVER
Hello All.....
I have rumors down the line that we are also going to start
developing and
supporting Sql Server. Anyone supporting both Oracle and Sql Ser=
ver
Comments, suggestions, knowing of whether or not I'm going to a straight
jacket????
Thanks In Advance.
Take Care,
Christine Turner
Database Administrator
IPS-Sendero
Scottsdale, Arizona
Phone: (800) 321-6899 ext. 3286
Fax: (480) 946-8224
E-mail: christine.turner_at_ips-sendero.com
--
Author: Christine Turner
INET: Christine.Turner_at_IPS-Sendero.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-50=
51
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 m=
ay
also send the HELP command for other information (like subscribin=
g).
-- Author: INET: BoivinP_at_mar.dfo-mpo.gc.ca 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-LReceived on Wed Aug 02 2000 - 12:11:04 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- = Author: Frank N. Pettinato INET: frankp_at_extremezone.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
 |
 |