
Microsoft SQL Server 2008 Administration for Oracle DBAs
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Cover Page
- Microsoft® SQL Server® 2008 Administration for Oracle® DBAs
- Copyright Page
- Dedication
- Contents at a Glance
- 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
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.