Sign in  |  Register
Advanced search
Publication Cover

CITATION

Anderson, Mark; Fox, James; and Bolton, Christian. Microsoft SQL Server 2008 Administration for Oracle DBAs. US: McGraw-Hill Osborne Media, 2010.

Microsoft SQL Server 2008 Administration for Oracle DBAs

Authors: Mark Anderson, James Fox and Christian Bolton

Published:  October 2010

eISBN: 9780071700658 007170065X | ISBN: 9780071700641
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Chapter 1 Introduction to the SQL Server Platform
  • SQL Server Editions
  • Premium Editions
  • Core Editions
  • Specialized Editions
  • Free Editions
  • SQL Azure (SQL Server in the Cloud)
  • Data Warehousing with SQL Server
  • SQL Server—What’s in the Box?
  • RDBMS Features
  • SQL Server Tools
  • Business Intelligence with SSIS, SSRS, and SSAS
  • Complex Event Processing with StreamInsight
  • Operating System Platforms
  • SQL Server Documentation and Sample Databases
  • SQL Server Books Online
  • AdventureWorks Sample Databases
  • SQL Server Resources, Support, and Software Patches
  • Online Resources
  • Official Microsoft Support and Software Patches
  • Chapter 2 SQL Server Architecture
  • High-Level Architecture Overview
  • Database Architecture
  • Database Storage Model
  • Physical Implementation
  • System Databases
  • master/Resource
  • tempdb
  • msdb
  • model
  • distribution
  • Database Snapshots
  • Instances
  • Inside the Instance
  • Client/Server Communication
  • Chapter 3 Installing and Configuring SQL Server
  • Installing SQL Server
  • Media and Licensing
  • Software Prerequisites
  • SQL Server Components
  • Instance Objects
  • Installation Locations and Conventions
  • Security Considerations
  • Software Installation
  • Configuring SQL Server
  • Networking Overview
  • Network Configuration
  • Basic Administration Tasks
  • Server Configuration
  • Chapter 4 Database Objects
  • Schemas
  • Working with Schemas
  • Synonyms
  • Schema Objects
  • Programmatic Objects
  • Tables, Indexes, and Views
  • Data Types
  • Working with Data Objects
  • Creating Tables
  • Creating Constraints
  • Creating Indexes
  • Rebuilding and Reorganizing Indexes
  • Creating Relationships
  • Creating Views
  • Filegroups and Partitioning
  • Creating Files and Filegroups
  • Partitioning
  • Chapter 5 Security
  • Security Objects
  • Server Security
  • Database Security
  • Protecting SQL Server Databases
  • Proxy Accounts
  • Encryption
  • Auditing
  • Policy-Based Management and Security
  • Chapter 6 Data Access and Transaction Control
  • The T-SQL Language
  • Query Execution
  • Parsing
  • Optimization
  • Execution
  • Fetching
  • Execution Plans
  • Optimizer Hints
  • Plan Guides
  • Monitoring Query Execution
  • Transaction Management
  • Auto-Commit Transactions
  • Implicit Transactions
  • Explicit Transactions
  • Distributed Transactions
  • Errors During Transaction Processing
  • Rollback Behavior
  • Transaction Isolation
  • Locking
  • Lock Granularity
  • Lock Types
  • Lock Compatibility
  • Lock Hints
  • Lock Escalation
  • Deadlocks
  • Monitoring Locking
  • Chapter 7 Backup and Recovery
  • Recovery Models
  • FULL
  • BULK_LOGGED
  • SIMPLE
  • Backup
  • Logical Backups
  • Physical Backups
  • Performing Backups
  • Backup History
  • Backup Permissions
  • Securing Backups
  • Backup Scheduling
  • SQL Server Maintenance Plans
  • Back Up Using SSMS
  • Backup of System Databases
  • Example Backup Scenarios
  • Restore and Recovery
  • Restoring and Recovering a Database
  • Restore—With Options
  • Restore Permissions
  • Restore History Tables
  • Restoring System Databases
  • Restoring Using SSMS
  • Example Restore Scenarios
  • Further Reading
  • Chapter 8 Performance Tuning and Optimization
  • Windows Performance Monitor
  • Overview
  • Getting Started
  • What to Look For
  • Going Beyond the Built-in Functionality
  • SQL Server Activity Monitor
  • Processes
  • Resource Waits
  • Data File I/O
  • Recent Expensive Queries
  • Dynamic Management Views
  • What Is SQL Server Waiting For?
  • Viewing I/O Latency by Database File
  • Finding Missing Indexes
  • SQL Server Profiler and SQL Trace
  • Event Hierarchy: Categories, Classes, and Columns
  • How to Reduce the Impact of Tracing
  • Analyzing SQL Traces
  • Database Engine Tuning Advisor
  • The Management Data Warehouse
  • What MDW Doesn’t Do
  • MDW Architecture
  • Chapter 9 High Availability and Disaster Recovery
  • Evaluating Business Continuity Solutions
  • Cold Standby Solutions
  • Warm Standby Solutions
  • Log Shipping
  • Database Mirroring (High-Performance Mode)
  • Replication
  • Hot Standby Solutions
  • Failover Clustering
  • Database Mirroring (High-Safety Mode with Automatic Failover)
  • Database Mirroring Walkthrough
  • Chapter 10 Scheduling, Automation, and Alerting
  • SQL Server Agent
  • Database Mail
  • Operators
  • Jobs
  • Job Execution Context
  • Job Categories
  • Shared Schedules
  • Job Monitoring and Execution History
  • Alerts
  • Maintenance Plans
  • Policy-Based Management
  • Policy Evaluation
  • Exporting and Importing Policies
  • Chapter 11 Data Movement
  • Importing and Exporting Data
  • Bulk Copy Program
  • BULK INSERT Statement (T-SQL)
  • SQL Server Integration Services
  • Import and Export Wizard
  • SQL Server Management Studio
  • Performance Considerations for Importing and Exporting Data
  • Moving or Copying an Entire Database
  • Detach-Copy/Move-Attach Method
  • Scripting the Database
  • Copy Database Wizard
  • Backup and Restore
  • Querying Across Servers and Data Sources
  • Data Replication
  • Replication Architecture
  • Replication Types
  • Peer-to-Peer Replication
  • Chapter 12 Upgrading and Migrating to SQL Server
  • Upgrading from Older Versions
  • Upgrade Considerations
  • SQL Server Upgrade Advisor
  • The Upgrade Process
  • Migrating from Other Databases
  • Migration Tasks
  • SQL Server Migration Assistant
  • Index