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]

Re: Admin a SQLServer environment from an Oracle DBA perspective?

Dave wrote:
[color=blue]
>Hey all,
>
> Recently we had a small re-org which combined DBA teams,
>specifically Oracle and SqlServer. Just wondering if anyone has
>documentatio n/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
>
>[/color]
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/ext/certificates/oad/oad_crs.asp

http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

damorgan@x.wash ington.edu
(replace 'x' with a 'u' to reply)

[Dave]

Re: Admin a SQLServer environment from an Oracle DBA perspective?

Daniel Morgan <damorgan@x.was hington.edu> wrote in message news:<106816343 8.675023@yasure >...
[color=blue]
> Get Tom Kyte's book 'Expert one-on-one Oracle".
>[/color]

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]

Re: Admin a SQLServer environment from an Oracle DBA perspective?

Dave wrote:
[color=blue]
>Daniel Morgan <damorgan@x.was hington.edu> wrote in message news:<106816343 8.675023@yasure >...
>
>
>[color=green]
>>Get Tom Kyte's book 'Expert one-on-one Oracle".
>>
>>
>>[/color]
>
>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
>
>[/color]
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/ext/certificates/oad/oad_crs.asp

http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

damorgan@x.wash ington.edu
(replace 'x' with a 'u' to reply)

[Dan Guzman]

Re: Admin a SQLServer environment from an Oracle DBA perspective?

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/default.asp?url=/library/en-us/dnsqlsm/html/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.publi c.sqlserver.ser ver. 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.cfm?DepartmentID=800

http://www.sqlserverfaq.com

http://www.mssqlserver.com/faq

-----------------------

"Dave" <shoad316@hotma il.com> wrote in message
news:78cf0572.0 311061359.587be 850@posting.goo gle.com...[color=blue]
> 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[/color]