Overview
Main description
An expert guide to working with SQL Server in a mixed-database environment
Microsoft 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
Table of contents
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
Author comments
Mark Anderson is a data platform technical specialist in the enterprise and partner division at Microsoft in the UK. Integrating with or migrating Oracle databases and applications forms are part of his daily role.
James Fox is the principal technical consultant at Skyline Managed Services, an Oracle and Microsoft partner providing database administration, support and consulting services to enterprise customers using primarily Oracle databases. He delivers SQL Server training to experienced Oracle DBAs.
Christian Bolton is a director and database architect for Coeo Ltd, a Microsoft Gold Partner focused on large-scale and complex SQL Server projects in EMEA. He is a Microsoft Certified Architect and MVP for SQL Server.
