Microsoft SQL Server 2008

Microsoft SQL Server 2008

This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and...

Descripción completa

Detalles Bibliográficos
Otros Autores: Rankins, Ray, author (author), Rankins, Ray Contributor (contributor)
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] Sams 2010
Edición:1st edition
Colección:Unleashed
Materias:
SQL server.
Client/server computing
Database management
Engineering & Applied Sciences
Computer Science
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628871706719
Tabla de Contenidos:
  • Cover
  • Table of Contents
  • Introduction
  • Part I: Welcome to Microsoft SQL Server
  • 1 SQL Server 2008 Overview
  • SQL Server Components and Features
  • SQL Server 2008 R2 Editions
  • SQL Server Licensing Models
  • Summary
  • 2 What's New in SQL Server 2008
  • New SQL Server 2008 Features
  • SQL Server 2008 Enhancements
  • Summary
  • 3 Examples of SQL Server Implementations
  • Application Terms
  • OLTP Application Examples
  • DSS Application Examples
  • Summary
  • Part II: SQL Server Tools and Utilities
  • 4 SQL Server Management Studio
  • What's New in SSMS
  • The Integrated Environment
  • Administration Tools
  • Development Tools
  • Summary
  • 5 SQL Server Command-Line Utilities
  • What's New in SQL Server Command-Line Utilities
  • The sqlcmd Command-Line Utility
  • The dta Command-Line Utility
  • The tablediff Command-Line Utility
  • The bcp Command-Line Utility
  • The sqldiag Command-Line Utility
  • The sqlservr Command-Line Utility
  • Summary
  • 6 SQL Server Profiler
  • What's New with SQL Server Profiler
  • SQL Server Profiler Architecture
  • Creating Traces
  • Executing Traces and Working with Trace Output
  • Saving and Exporting Traces
  • Replaying Trace Data
  • Defining Server-Side Traces
  • Profiler Usage Scenarios
  • Summary
  • Part III: SQL Server Administration
  • 7 SQL Server System and Database Administration
  • What's New in SQL Server System and Database Administration
  • System Administrator Responsibilities
  • System Databases
  • System Tables
  • System Views
  • System Stored Procedures
  • Summary
  • 8 Installing SQL Server 2008
  • What's New in Installing SQL Server 2008
  • Installation Requirements
  • Installation Walkthrough
  • Installing SQL Server Using a Configuration File
  • Installing Service Packs and Cumulative Updates
  • Slipstream Installations
  • Summary
  • 9 Upgrading to SQL Server 2008.
  • What's New in Upgrading SQL Server
  • Using the SQL Server Upgrade Advisor (UA)
  • Destination: SQL Server 2008 or SQL Server 2008 R2
  • Upgrading Using a Configuration File
  • Slipstreaming Upgrades
  • Upgrading Other SQL Server Components
  • Summary
  • 10 Client Installation and Configuration
  • What's New in Client Installation and Configuration
  • Client/Server Networking Considerations
  • Client Installation
  • Client Configuration
  • Client Data Access Technologies
  • Summary
  • 11 Security and User Administration
  • What's New in Security and User Administration
  • An Overview of SQL Server Security
  • Authentication Methods
  • Managing Principals
  • Managing Securables
  • Managing Permissions
  • Managing SQL Server Logins
  • Managing SQL Server Users
  • Managing Database Roles
  • Managing SQL Server Permissions
  • The Execution Context
  • Summary
  • 12 Data Encryption
  • What's New in Data Encryption
  • An Overview of Data Security
  • An Overview of Data Encryption
  • SQL Server Key Management
  • Column-Level Encryption
  • Transparent Data Encryption
  • Column-Level Encryption Versus Transparent Data Encryption
  • Summary
  • 13 Security and Compliance
  • Exposure and Risk
  • Across the Life Cycle
  • The Security Big Picture
  • Identity Access Management Components
  • Compliance and SQL Server
  • SQL Server Auditing
  • Setting Up Auditing via T-SQL
  • SQL Injection Is Easy to Do
  • Summary
  • 14 Database Backup and Restore
  • What's New in Database Backup and Restore
  • Developing a Backup and Restore Plan
  • Types of Backups
  • Recovery Models
  • Backup Devices
  • Backing Up a Database
  • Backing Up the Transaction Log
  • Backup Scenarios
  • Restoring Databases and Transaction Logs
  • Restore Scenarios
  • Additional Backup Considerations
  • Summary
  • 15 Database Mail
  • What's New in Database Mail
  • Setting Up Database Mail.
  • Sending and Receiving with Database Mail
  • Using SQL Server Agent Mail
  • Related Views and Procedures
  • Summary
  • 16 SQL Server Scheduling and Notification
  • What's New in Scheduling and Notification
  • Configuring the SQL Server Agent
  • Viewing the SQL Server Agent Error Log
  • SQL Server Agent Security
  • Managing Operators
  • Managing Jobs
  • Managing Alerts
  • Scripting Jobs and Alerts
  • Multiserver Job Management
  • Event Forwarding
  • Summary
  • 17 Administering SQL Server 2008 with PowerShell
  • What's New with PowerShell
  • Overview of PowerShell
  • PowerShell Scripting Basics
  • PowerShell in SQL Server 2008
  • Step-By-Step Examples
  • Summary
  • 18 SQL Server High Availability
  • What's New in High Availability
  • What Is High Availability?
  • The Fundamentals of HA
  • Building Solutions with One or More HA Options
  • Other HA Techniques That Yield Great Results
  • High Availability from the Windows Server Family Side
  • Summary
  • 19 Replication
  • What's New in Data Replication
  • What Is Replication?
  • The Publisher, Distributor, and Subscriber Magazine Metaphor
  • Replication Scenarios
  • Subscriptions
  • Replication Agents
  • Planning for SQL Server Data Replication
  • SQL Server Replication Types
  • Basing the Replication Design on User Requirements
  • Setting Up Replication
  • Scripting Replication
  • Monitoring Replication
  • Summary
  • 20 Database Mirroring
  • What's New in Database Mirroring
  • What Is Database Mirroring?
  • Roles of the Database Mirroring Configuration
  • Setting Up and Configuring Database Mirroring
  • Testing Failover from the Principal to the Mirror
  • Client Setup and Configuration for Database Mirroring
  • Migrate to Database Mirroring 2008 as Fast as You Can
  • Using Replication and Database Mirroring Together
  • Using Database Snapshots from a Mirror for Reporting
  • Summary.
  • 21 SQL Server Clustering
  • What's New in SQL Server Clustering
  • How Microsoft SQL Server Clustering Works
  • Installing SQL Server Clustering
  • Summary
  • 22 Administering Policy-Based Management
  • Introduction to Policy-Based Management
  • Policy-Based Management Concepts
  • Implementing Policy-Based Management
  • Sample Templates and Real-World Examples
  • Policy-Based Management Best Practices
  • Summary
  • Part IV: Database Administration
  • 23 Creating and Managing Databases
  • What's New in Creating and Managing Databases
  • Data Storage in SQL Server
  • Database Files
  • Creating Databases
  • Setting Database Options
  • Managing Databases
  • Summary
  • 24 Creating and Managing Tables
  • What's New in SQL Server 2008
  • Creating Tables
  • Defining Columns
  • Defining Table Location
  • Defining Table Constraints
  • Modifying Tables
  • Dropping Tables
  • Using Partitioned Tables
  • Creating Temporary Tables
  • Summary
  • 25 Creating and Managing Indexes
  • What's New in Creating and Managing Indexes
  • Types of Indexes
  • Creating Indexes
  • Managing Indexes
  • Dropping Indexes
  • Online Indexing Operations
  • Indexes on Views
  • Summary
  • 26 Implementing Data Integrity
  • What's New in Data Integrity
  • Types of Data Integrity
  • Enforcing Data Integrity
  • Using Constraints
  • Rules
  • Defaults
  • Summary
  • 27 Creating and Managing Views in SQL Server
  • What's New in Creating and Managing Views
  • Definition of Views
  • Using Views
  • Creating Views
  • Managing Views
  • Data Modifications and Views
  • Partitioned Views
  • Indexed Views
  • Summary
  • 28 Creating and Managing Stored Procedures
  • What's New in Creating and Managing Stored Procedures
  • Advantages of Stored Procedures
  • Creating Stored Procedures
  • Executing Stored Procedures
  • Deferred Name Resolution
  • Viewing Stored Procedures
  • Modifying Stored Procedures.
  • Using Input Parameters
  • Using Output Parameters
  • Returning Procedure Status
  • Debugging Stored Procedures Using SQL Server Management Studio
  • Using System Stored Procedures
  • Startup Procedures
  • Summary
  • 29 Creating and Managing User-Defined Functions
  • What's New in SQL Server 2008
  • Why Use User-Defined Functions?
  • Types of User-Defined Functions
  • Creating and Managing User-Defined Functions
  • Rewriting Stored Procedures as Functions
  • Creating and Using CLR Functions
  • Summary
  • 30 Creating and Managing Triggers
  • What's New in Creating and Managing Triggers
  • Using DML Triggers
  • Using DDL Triggers
  • Using CLR Triggers
  • Using Nested Triggers
  • Using Recursive Triggers
  • Summary
  • 31 Transaction Management and the Transaction Log
  • What's New in Transaction Management
  • What Is a Transaction?
  • How SQL Server Manages Transactions
  • Defining Transactions
  • Transactions and Batches
  • Transactions and Stored Procedures
  • Transactions and Triggers
  • Transactions and Locking
  • Coding Effective Transactions
  • Transaction Logging and the Recovery Process
  • Long-Running Transactions
  • Bound Connections
  • Distributed Transactions
  • Summary
  • 32 Database Snapshots
  • What's New with Database Snapshots
  • What Are Database Snapshots?
  • Limitations and Restrictions of Database Snapshots
  • Copy-on-Write Technology
  • When to Use Database Snapshots
  • Setup and Breakdown of a Database Snapshot
  • Reverting to a Database Snapshot for Recovery
  • Setting Up Snapshots Against a Database Mirror
  • Database Snapshots Maintenance and Security Considerations
  • Summary
  • 33 Database Maintenance
  • What's New in Database Maintenance
  • The Maintenance Plan Wizard
  • Managing Maintenance Plans Without the Wizard
  • Executing a Maintenance Plan
  • Maintenance Without a Maintenance Plan
  • Database Maintenance Policies.
  • Summary.

Ejemplares similares