9780735663763

Microsoft SQL Server 2012 Pocket Consultant

by
  • ISBN13:

    9780735663763

  • ISBN10:

    0735663769

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2/15/2012
  • Publisher: Microsoft Press
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $39.99 Save up to $1.60
  • eBook
    $38.39
    Add to Cart

    DURATION
    PRICE

Supplemental Materials

What is included with this book?

  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

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.

Rewards Program

Write a Review