Microsoft SQL server 2008 administration for Oracle DBAs

Leverage your Oracle DBA skills on Microsoft SQL Server 2008 Microsoft SQL Server 2008 Administration for Oracle DBAs shows you how to use your experience as an Oracle DBA to get up to speed quickly on the Microsoft SQL Server platform. Authors with real-world expertise in both Oracle and SQL Server introduce you to fundamental concepts, such as SQL Server architecture and core administration, before guiding you through advanced techniques, including performance optimization, high availability and disaster recovery. Platform comparisons, on-the-job examples, and answers to questions raised by Oracle DBAs learning the SQL Server environment help build your skills. This practical guide shows you how to: Identify the components of the SQL Server platform Understand SQL Server architecture Install and configure SQL Server software and client components Define and manage database objects Implement and administer database security Monitor, identify, and resolve performance issues Design and implement high availability, system backup, and disaster recovery strategies Automate SQL Server using built-in scheduling and alerting capabilities Import and export data to and from SQL Server and other RDBMS platforms Upgrade existing SQL Server installations and migrate Oracle databases to SQL Server "An expert guide to working with SQL Server in a mixed-database environmentMicrosoft SQL Server Administration for Oracle DBAs is the ideal resource for experienced Oracle database professionals looking to expand their knowledge and skill set into the Microsoft database platform. The book compares and contrasts the platform architectures and shows how to perform everyday database administrator tasks. Screenshots, script examples, and step-by-step labs are included in this practical guide. This book is not designed to be a "SQL Server is better than Oracle" or vice versa. It will enable experienced Oracle database administrators to get up to speed on the Microsoft SQL Server platform by building on existing relational database skills. The authors' combination of expertise in both technologies ensures technical accuracy and real-world experiences. Interviews with members of the Oracle DBA community are included in this practical guide. Microsoft SQL Server Administration for Oracle DBAs is co-written by a data platform technical specialist at Microsoft, UK who works daily with large customers integrating SQL Server into Oracle Teaches dual skills using real-world examples based on authors' vast experience Quickly explains how to perform everyday database admin tasks on SQL Server Focuses on making both platforms work together successfully Includes step-by-step labs and interviews with members of the Oracle DBA community Leverage your Oracle DBA skills on SQL Server SQL Server Architecture; Installing and Configuring SQL Server; Database Objects; Security; Data Access and Transaction Control; Backup and Recovery; Performance Tuning and Optimization; High Availability and Disaster Recovery Options; Scheduling, Automation and Alerting; Data Movement; Upgrading and Migrating to SQL Server"-- "Microsoft SQL Server 2008 Administration for Oracle DBAs shows you how to use your experience as an Oracle DBA to get up to speed quickly on the Microsoft SQL Server platform. Authors with real-world expertise in both Oracle and SQL Server introduce you to fundamental concepts, such as SQL Server architecture and core administration, before guiding you through advanced techniques, including performance optimization, high availability and disaster recovery. Platform comparisons, on-the-job examples, and answers to questions raised by Oracle DBAs learning the SQL Server environment help build your skills"-- For example, as you would expect, both platforms have the concept of an entity known as a "database," and although the comparison of a "database" in both platforms may initially seem to be logical, you will soon realize that the comparison is not so straightforward and the feature or function is not comparable. [...] The first two chapters give you an overview of the components and toolset of the SQL Server platform and an understanding of the relational engine architecture. [...] We recommend that you begin by reading the first two chapters to give you an overview of the components and toolset of the SQL Server platform and an understanding of the relational engine architecture. [...] However, you will need to have read Chapters 1 and 2 for an introduction to the tools and concepts discussed in Chapter 7. After reading this book, when you are tasked with a SQL Server job, you will have enough understanding of the tools and skills required to complete the task and how they relate to your existing Oracle skills and experience. [...] Chapter 1 Introduction to the SQL Server Platform In This Chapter SQL Server Editions SQL Server Documentation SQL Server-What's in and Sample Databases the Box? Machine generated contents note: 1. Introduction to the SQL Server Platform 2. SQL Server Architecture 3. Installing and Configuring SQL Server 4. Database Objects 5. Security 6. Data Access and Transaction Control 7. Backup and Recovery 8. Performance Tuning and Optimization 9. High Availability and Disaster Recovery Options 10. Scheduling, Automation and Alerting 11. Data Movement 12. Upgrading and Migrating to SQL Server. Experienced Oracle database administrators looking to get up to speed quickly on working with SQL Server in a mixed-database environment will find all the answers they need in this hands-on reference