THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Alexander Kuznetsov

Book Review: Oracle Database Administration for Microsoft SQL Server DBAs

Working in mixed database environments is a very interesting challenge, both for DBAs and developers. If we already have experience with SQL Server, and need to work with Oracle, our SQL Server experience may be an advantage  - we already have a good handle on what an RDBMS should do (backups, restores, etc.). On the other hand, our experience and common patterns with SQL Server may cause us to make mistakes on Oracle, because its internals and best practices are not the same.

 

I have read a book named “Oracle Database Administration for Microsoft SQL Server DBAs”, and I really liked it. The book’s goal is to introduce Oracle to SQL Server data professionals, to explain similarities and differences between these two very common RDBMS. This book is filled with practical, real life information, necessary to perform daily activities of a production DBA. The book can really prevent us from missteps when we try to use Oracle as if it were SQL Server. It has the following chapters:

 

  •          Oracle Internals - I was especially fascinated by the description of transaction process flow, which is different in Oracle
  •          Oracle Installation, which also describes a few useful Linux commands, and connectivity
  •          Database Definitions and Setup (databases and schemas have different meanings)
  •          DBA Tools
  •          Database Backup, Restore, and Recovery
  •        Database Maintenance
  •        Performance and Tuning
  •         PL/SQL (which is VERY different from T-SQL)
  •         High Availability Architecture

 

Overall, this is a must-read book for any SQL Server professional intending to improve their Oracle skills.

 

The author of the book, Michelle Malcher, is an Oracle ACE, and is currently on the Board of the Independent Oracle User Group.She also co-authored another book, "

Oracle Database 11g: A Beginner's Guide"

She leads the DBA team at DRW, the same company I work for as a developer.

Published Monday, September 27, 2010 2:26 PM by Alexander Kuznetsov

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Jim R. said:

Hi all, in this globalized world for the professional dba is necesary domain two to more DBMS, and the enterprises choice is between MS SQL Server and Oracle.

Thanks for the recomendation, we dont must limit to one DBMS, and whether we can apply our mssql dba  knowledge with other DBMS will be great!

Greetings

Jim R.

September 29, 2010 12:10 PM
 

merrillaldrich said:

Just ordered my copy - thank you for the recommendation. I'm headed into cross-training with Oracle DBAs at my office, so this should be really useful.

October 4, 2010 2:28 PM
 

Alexander Kuznetsov said:

Merrill,

I hope you guys like it. Michelle is a talented mentor, she wrote a very clear and useful book. Enjoy!

October 8, 2010 10:56 AM

Leave a Comment

(required) 
(required) 
Submit

About Alexander Kuznetsov

Alex Kuznetsov has been working with object oriented languages, mostly C# and C++, as well as with databases for more than a decade. He has worked with Sybase, SQL Server, Oracle and DB2. He regularly blogs on sqlblog.com, mostly about database unit testing, defensive programming, and query optimization. Alex has written a book entitled "Defensive Database Programming with Transact-SQL" and several articles on simple-talk.com and devx.com. Currently he works at DRW Trading Group in Chicago, where he leads a team of developers, practicing agile development, defensive programming, TDD, and database unit testing.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement