Microsoft SQL Server 2008 Administration for Oracle DBAs
By Mark Anderson, James Fox & Christian Bolton
- Release Date: 2010-10-22
- Genre: Databases
Description
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
