Sign in
|
Register
|
Mobile
Home
Browse
About us
Help/FAQ
Advanced search
Home
>
Browse
>
Microsoft SQL Server 2008 Administration for Oracle DBAs
CITATION
Anderson, Mark;
Fox, James; and
Bolton, Christian
.
Microsoft SQL Server 2008 Administration for Oracle DBAs
.
US
: McGraw-Hill Osborne Media, 2010.
Add to Favorites
Email to a Friend
Download Citation
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
Book Description
Table of Contents
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