Microsoft SQL Server 2008 Administration for Oracle DBAs

  • 8h 10m
  • Christian Bolton, James Fox, Mark Anderson
  • McGraw-Hill/Osborne
  • 2011

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

About the Authors

Mark Anderson is a data platform technical specialist for Microsoft in the UK working with its largest enterprise customers. He holds certifications in both the SQL Server and Oracle platforms and has trained Oracle DBAs in SQL Server administration.

James Fox is an independent consultant providing database administration, support, and consulting services to enterprise customers using primarily Oracle databases. He has delivered SQL Server training to experienced Oracle DBAs.

Christian Bolton is the Technical Director 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.

In this Book

  • Introduction to the SQL Server Platform
  • 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
  • Scheduling, Automation, and Alerting
  • Data Movement
  • Upgrading and Migrating to SQL Server
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Oracle on Docker: Running Oracle Databases in Linux Containers
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Course An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)