Admin a SQLServer environment from an Oracle DBA perspective?

[Dave]

Hey all,

Recently we had a small re-org which combined DBA teams,
specifically Oracle and SqlServer. Just wondering if anyone has
documentation/presentations, etc that show's how to admin a SQLServer
environment from an Oracle DBA perspective?

I guess, something that map's each DB's concepts to each other. As
an Oracle DBA how to troubleshoot/support the environment, etc....

Thanks!

Dave

[Daniel Morgan]

Dave wrote:

Hey all,

Recently we had a small re-org which combined DBA teams,
specifically Oracle and SqlServer. Just wondering if anyone has
documentation/presentations, etc that show's how to admin a SQLServer
environment from an Oracle DBA perspective?

I guess, something that map's each DB's concepts to each other. As
an Oracle DBA how to troubleshoot/support the environment, etc....

Thanks!

Dave

Get Tom Kyte's book 'Expert one-on-one Oracle".

I won't do what you ask. But the first three chapters will point out to
you in graphic detail
the areas on which you will need to focus.

The two database products are so totally different I can't imagine how
one would try to
administer them together. One has limited row level locking and low
escalation. The other
has no similar concept. One has infinite log files the other does not.
One has a multi-versioning
architecture the other does not. One has autonumbering the other
sequences. One has packages
the other does not. One has .... and on and on and on and on.

One person can manage both. But they need to view them as they are, Each
with its own
concepts and architecture. With more differences than similarities.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

[Dave]

Daniel Morgan <da******@x.washington.edu> wrote in message news:<1068163438.675023@yasure>...

Get Tom Kyte's book 'Expert one-on-one Oracle".

Oppps... maybe my post wasn't clear.. Were Oracle DBA's inheriting SQL
Server databases, not the other way around. :)

I've read a "Teach yourself in 24 hours SQL Server" book by Sams but I
need to put together some docs for the rest of our group. I'm just
curious if anyone has done that before? ie, Point out to an Oracle
DBA how to administer a SQL Server environment.

Thanks
Dave

[Daniel Morgan]

Dave wrote:

Daniel Morgan <da******@x.washington.edu> wrote in message news:<1068163438.675023@yasure>...

Get Tom Kyte's book 'Expert one-on-one Oracle".

Oppps... maybe my post wasn't clear.. Were Oracle DBA's inheriting SQL
Server databases, not the other way around. :)

I've read a "Teach yourself in 24 hours SQL Server" book by Sams but I
need to put together some docs for the rest of our group. I'm just
curious if anyone has done that before? ie, Point out to an Oracle
DBA how to administer a SQL Server environment.

Thanks
Dave

I did read your post the other way around. I am not aware of any good
books that approach
the subject from the other standpoint.

Given that SQL Server affeccionados proclaim their product's management
ease ... perhaps
you can just ignore it. ;-)

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

[Dan Guzman]

The article below explains many of the differences in architecture and
terminology. Although written for SQL 7, it mostly applies to SQL 2000
as well.

http://msdn.microsoft.com/library/de...oracle2sql.asp

The products are totally different in some areas but similar in others.
In any case, you'll need to wear different DBA hats.

Feel free to post your SQL Server specific questions here or to
microsoft.public.sqlserver.server. Many of us work with Oracle as well
and can assist you in managing your SQL Server databases.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Dave" <sh******@hotmail.com> wrote in message
news:78**************************@posting.google.c om...

Hey all,

Recently we had a small re-org which combined DBA teams,
specifically Oracle and SqlServer. Just wondering if anyone has
documentation/presentations, etc that show's how to admin a SQLServer
environment from an Oracle DBA perspective?

I guess, something that map's each DB's concepts to each other. As
an Oracle DBA how to troubleshoot/support the environment, etc....

Thanks!

Dave