Microsoft SQL Server 2012 Unleashed

Format:

Book

Author/Creator:

Rankins, Ray, Author.

Contributor:

Rankins, Ray

Language:

English

Subjects (All):

SQL server.

Database management.

Physical Description:

1 online resource (1 v.) : ill.

Edition:

1st edition

Place of Publication:

[Place of publication not identified] Pearson Education 2013

Language Note:

English

System Details:

text file

Summary:

Buy the print version of¿ Microsoft SQL Server 2012 Unleashed and get the eBook version for free! eBook version includes chapters 44-60 not included in the print. See inside the book for access code and details. ¿ With up-to-the-minute content, this is the industry’s most complete, useful guide to SQL Server 2012. ¿ You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and samples you’ll need to create and manage complex database solutions. The additional online chapters add extensive coverage of SQL Server Integration Services, Reporting Services, Analysis Services, T-SQL programming, .NET Framework integration, and much more. ¿ Authored by four expert SQL Server administrators, designers, developers, architects, and consultants, this book reflects immense experience with SQL Server in production environments. Intended for intermediate-to-advanced-level SQL Server professionals, it focuses on the product’s most complex and powerful capabilities, and its newest tools and features. Understand SQL Server 2012’s newest features, licensing changes, and capabilities of each edition Manage SQL Server 2012 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell Use Policy-Based Management to centrally configure and operate SQL Server Utilize the new Extended Events trace capabilities within SSMS Maximize performance by optimizing design, queries, analysis, and workload management Implement new best practices for SQL Server high availability Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery Leverage new business intelligence improvements, including Master Data Services, Data Quality Services and Parallel Data Warehouse Deliver better full-text search with SQL Server 2012’s new Semantic Search Improve reporting with new SQL Server 2012 Reporting Services features Download the following from informit.com/title/9780672336928: Sample databases and code examples ¿ ¿

Contents:

Intro

About This eBook

Title Page

Copyright Page

Contents at a Glance

Table of Contents

About the Authors

About the Contributing Author

Dedication

Acknowledgments

We Want to Hear from You!

Reader Services

Introduction

Who This Book Is For

What This Book Covers

Conventions Used in This Book

Good Luck!

Part I: Welcome to Microsoft SQL Server

Chapter 1. SQL Server 2012 Overview

SQL Server Components and Features

SQL Server 2012 Editions

SQL Server Licensing Models

Summary

Chapter 2. What's New in SQL Server 2012

New SQL Server 2012 Features

SQL Server 2012 Enhancements

Deprecated Features

Chapter 3. Examples of SQL Server Implementations

Application Terms

OLTP Application Examples

DSS Application Examples

Part II: SQL Server Tools and Utilities

Chapter 4. SQL Server Management Studio

What's New in SSMS

The Integrated Environment

Administration Tools

Development Tools

Chapter 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

The SqlLocalDB Command-Line Utility

Chapter 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

Chapter 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

Chapter 8. Installing SQL Server 2012

What's New in Installing SQL Server 2012

Installation Walkthrough

Installing SQL Server Using a Configuration File

Installing Service Packs and Cumulative Updates

Chapter 9. Upgrading to SQL Server 2012

What's New in Upgrading SQL Server

Identifying Products and Features to be Upgraded

Using the SQL Server Upgrade Advisor (UA)

Destination: SQL Server 2012

Installing Product Updates (Slipstreaming) During Upgrades

Upgrading Using a Configuration File

Upgrading Other SQL Server Components

Chapter 10. Client Installation and Configuration

What's New in Client Installation and Configuration

Client Installation

Client Configuration

Client Data Access Technologies

Chapter 11. 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

Chapter 12. 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

Chapter 13. SQL Server Agent

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.

Chapter 14. Administering SQL Server 2012 with PowerShell

What's New with PowerShell

Overview of PowerShell

PowerShell Scripting Basics

PowerShell in SQL Server 2012

Step-by-Step Examples

Chapter 15. SQL Server Policy-Based Management

What's New in 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: SQL Server Security Administration

Chapter 16. Security and Compliance

Exposure and Risk

Across the Life Cycle

The Security Big Picture

Identity Access Management Components

Data Security Compliance and SQL Server

SQL Server Auditing

Setting Up Auditing via T-SQL

SQL Injection Is Easy to Do

Chapter 17. 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 Server Roles

Managing SQL Server Permissions

The Execution Context

Chapter 18. 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

Part V: Database Administration

Chapter 19. 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

Contained Databases

Chapter 20. Creating and Managing Tables

What's New in SQL Server 2012

Creating Tables

Defining Columns

Defining Table Location

Defining Table Constraints

Modifying Tables

Dropping Tables

Using Partitioned Tables

Using FILESTREAM Storage

Using FileTables

Creating Temporary Tables

Chapter 21. 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

Chapter 22. Implementing Data Integrity

What's New in Data Integrity

Types of Data Integrity

Enforcing Data Integrity

Using Constraints

Rules

Defaults

When a Default Is Applied

Chapter 23. Creating and Managing Views

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

Chapter 24. 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

Chapter 25. 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

Chapter 26. 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

Chapter 27. 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

Distributed Transactions

Chapter 28. 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

Database Snapshots Maintenance and Security Considerations

Chapter 29. 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

Part VI: SQL Server Performance and Optimization

Chapter 30. Data Structures, Indexes, and Performance

What's New for Data Structures, Indexes, and Performance

Understanding Data Structures

Database Files and Filegroups

Database Pages

Space Allocation Structures

Data Compression

Understanding Table Structures

Understanding Index Structures

Data Modification and Performance

Index Utilization

Index Selection

Evaluating Index Usefulness

Index Statistics

SQL Server Index Maintenance

Index Design Guidelines

Indexed Views.

Indexes on Computed Columns.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on publisher supplied metadata and other sources.

ISBN:

9780133408515

0133408515

9780133408508

0133408507

9780672336928

0672336928

OCLC:

869748015