Microsoft SQL Server 2012 Pocket Consultant

by Stanek, William

• ISBN13: 9780735663763
• ISBN10: 0735663769
• Edition: 1st
• Format: Paperback
• Copyright: 2012-02-15
• Publisher: Microsoft Press

Summary

Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server Code Name "Denali". Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You'll get the focused information you need to save time and get the job donewhether at your desk or in the field! Get fast facts to: Manage SQL Server services and clients Configure, manage, and tune servers Implement policy-based management Administer security and access Import, export, transform, and replicate data Manage log shipping and database mirroring Monitor server activity and tune performance Automate maintenance Perform backups and recovery

Author Biography

William R. Stanek is a Microsoft MVP with 20+ years of experience in systems management and advanced programming. He is an award-winning author who’s written more than 100 books, including Windows Server 2012 Pocket Consultant and Microsoft SQL Server 2012 Pocket Consultant.

Table of Contents

Introduction

Who Is This Book For?

How Is This Book Organized?

What Is SQL Server 2012?

System Requirements

Conventions Used in This Book

Other Resources

Support and Feedback

Microsoft SQL Server 2012 Essentials

Managing Your SQL Servers

Using SQL Server Management Studio

Managing SQL Server Groups

Managing Servers

Using Windows PowerShell for SQL Server Management

Starting, Stopping, and Configuring SQL Server Agent

Starting, Stopping, and Configuring MSDTC

Managing SQL Server Startup

Managing Server Activity

Managing SQL Server Services and Clients

Managing SQL Server Component Feature Access

Managing the Network and SQL Server Native Client Configuration

Understanding the Services Configuration

Configuring SQL Server Services; Microsoft SQL Server 2012 Management and Security

Implementing Policy-Based Management

Introducing Policy-Based Management

Working with Policy-Based Management

Configuring Central Management Servers

Managing Policies Throughout the Enterprise

Configuring and Tuning Your SQL Servers

Accessing SQL Server Configuration Data

Techniques for Managing SQL Server Configuration Options

Configuring SQL Server with Stored Procedures

Tuning and Linking Your SQL Servers

SQL Server Management Studio Essentials

Working with Linked Servers and Distributed Data

Configuring Authentication and Auditing

Tuning Memory Usage

Configuring Processors and Parallel Processing

Configuring Threading, Priority, and Fibers

Configuring User and Remote Connections

Managing Server Settings

Managing Database Settings

Managing Linked Servers

Troubleshooting Configuration Problems

Database Administration Essentials

Database Files and Logs

Database Administration Basics

Creating Databases

Altering Databases and Their Options

Managing Database and Log Size

Manipulating Databases

Tips and Techniques

Implementing SQL Server 2012 Security

Overview of SQL Server 2012 Security

SQL Server 2012 Authentication Modes

Special-Purpose Logins and Users

Permissions

Roles

Managing Server Logins

Configuring Server Roles

Controlling Database Access and Administration

Managing Database Permissions; Microsoft SQL Server 2012 Data Management

Manipulating Schemas, Tables, and Views

Working with Schemas

Getting Started with Tables

Table Essentials

Working with Tables

Managing Table Values

Using Views

Using Indexes, Constraints, and Partitions

Creating and Managing Indexes

Working with Columnstore Indexes

Column Constraints and Rules

Creating Partitioned Tables and Indexes

Compressing Tables, Indexes, and Partitions; Microsoft SQL Server 2012 Optimization, Maintenance, and Recovery

Automating and Maintaining SQL Server 2012

Database Automation and Maintenance

Using Database Mail

Using SQL Server Agent

Managing Alerts

Managing Operators

Scheduling Jobs

Automating Routine Server-to-Server Administration Tasks

Multiserver Administration

Database Maintenance

SQL Server 2012 Backup and Recovery

Creating a Backup and Recovery Plan

Selecting Backup Devices and Media

Using Backup Strategies

Creating a Backup Device

Performing Backups

Restoring a Database

Restoring the master Database

SQL Server 2012 Profiling and Monitoring

Monitoring Server Performance and Activity

Working with Replication Monitor

Working with the Event Logs

Monitoring SQL Server Performance

Configuring a Management Data Warehouse

Solving Performance Problems with Profiler

About the Author

About the Technical Reviewer

Table of Contents provided by Publisher. All Rights Reserved.