Microsoft SQL Server 2008

Format:

Book

Author/Creator:

Rankins, Ray, author.

Contributor:

Rankins, Ray, Contributor.

Series:

Unleashed

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Database management.

Physical Description:

1 online resource (xlvi, 2451 p.) : ill.

Edition:

1st edition

Place of Publication:

[Place of publication not identified] Sams 2010

Language Note:

English

System Details:

text file

Summary:

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 much more. Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance. The accompanying CD-ROM contains an extraordinary library of practical tools and information including sample databases and all code examples. Whether you’re responsible for SQL Server 2008 analysis, design, implementation, support, administration, or troubleshooting, no other book offers you this much value. Understand the Microsoft SQL Server 2008 environment, R2’s newest features, and each edition’s capabilities Manage SQL Server 2008 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell Efficiently manage security, users, backup/restore, replication, Database Mail, and database objects—from tables and indexes to stored procedures and triggers Increase availability with clustering, database mirroring, and other features Use new Policy-Based Management to centrally configure and operate SQL Server throughout the organization Use SQL Server Profiler to capture queries and identify bottlenecks Improve performance by optimizing queries, design more effective databases, and manage workloads with the new Resource Governor Develop applications using SQL Server 2008’s enhancements to T-SQL and SQLCLR, .NET integration, LINQ to SQL, XML, and XQuery Make the most of Analysis Services, Integration Services, and Reporting Services—especially Microsoft’s new R2 reporting improvements Improve data security using Column-level and Transparent Data Encryption CD-ROM includes: 15 additional chapters Code samples, scripts, and databases utilized within the book Free version of SQL Shot (performa...

Contents:

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

3 Examples of SQL Server Implementations

Application Terms

OLTP Application Examples

DSS Application Examples

Part II: SQL Server Tools and Utilities

4 SQL Server Management Studio

What's New in SSMS

The Integrated Environment

Administration Tools

Development Tools

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

26 Implementing Data Integrity

What's New in Data Integrity

Types of Data Integrity

Enforcing Data Integrity

Using Constraints

Rules

Defaults

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

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

29 Creating and Managing User-Defined Functions

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

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

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

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

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.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on publisher supplied metadata and other sources.

ISBN:

9786612768101

9781282768109

1282768107

9780768696530

0768696534

OCLC:

1027199692