Oracle Database Administration for Microsoft SQL Server DBAs (Osborne ORACLE Press Series)

Written by an Oracle ACE, this Oracle Press guide helps experienced Microsoft SQL Server database administrators (DBAs) work seamlessly with the Oracle Database in a mixed-database environment. Oracle Database Administration for Microsoft SQL Server DBAs takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments. This is not designed to be an “Oracle is better than SQL Server” book or vice versa. With step-by-step examples throughout as well as code listings, this unique resource takes a practical, day-to-day approach to job functionality as opposed to attempting a feature-by-feature comparison of Oracle versus SQL Server. Oracle Database Administration for Microsoft SQL Server DBAs: Includes realistic, step-by-step procedures for tasks such as database installation plus practical code examples to back up content; Explains how to perform everyday administration tasks on the Oracle Database; Shows how to optimize existing SQL Server skills in the Oracle environment, and teaches the most compelling features unique to Oracle; Includes coverage of working with different operating systems. Full coverage of Oracle DBA skills. The Database Administrator; Oracle Internals; Installations; Servers, Databases, Instances or Schemas; DBA Tools; Backup Database; Database Maintenance; Performance and Tuning; PL/SQL; High Availability Architecture

Customer Reviews:

Practical and Useful

By Alex Kuznetsov - October 22, 2010

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... read more

Very far from SQL Server and Oracle concepts

By A. Taveras "A Taveras" - October 23, 2011

This book merely regurgitates the freely available documentation from Oracle and MS SQL Server. However, this book is even worse since its space limitations means that the author is forced to be even more cryptic than the already difficult to understand product documentation. I could not find anything useful in this book - the book doesn't explain anything. Nothing at all. Aren't books like these supposed to simplify concepts for nonexperts or beginners? You think you will find a chart explaining orcl and sql svr concepts? No. Forget about this book.