Limit search to available items
Book Cover
Author Stanek, William

Title Microsoft SQL Server 2012 Pocket Consultant
Published Sebastopol : Microsoft Press, 2012
Online access available from:
Safari O'Reilly books online    View Resource Record  


Description 1 online resource (590 pages)
Contents Cover Page; Copyright Page; Dedication Page; Contents at a Glance Page; Contents Page; 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; Errata; We Want to Hear from You; Stay in Touch; Part I: Microsoft SQL Server 2012 Essentials; Chapter 1: Managing Your SQL Servers; Using SQL Server Management Studio; Getting Started with SQL Server Management Studio; Connecting to a Specific Server Instance; Connecting to a Specific Database; Managing SQL Server Groups
Configuring the TCP/IP Native Client ConfigurationUnderstanding the Services Configuration; Configuring SQL Server Services; Managing Service State and Start Mode; Setting the Startup Service Account; Setting Up File Streaming; Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting; Part II: Microsoft SQL Server 2012 Management and Security; Chapter 3: Implementing Policy-Based Management; Introducing Policy-Based Management; Working with Policy-Based Management; Configuring Central Management Servers; Registering Central Management Servers
Deleting a Server RegistrationUsing Windows PowerShell for SQL Server Management; Starting, Stopping, and Configuring SQL Server Agent; Starting, Stopping, and Configuring MSDTC; Managing SQL Server Startup; Enabling or Preventing Automatic SQL Server Startup; Setting Database Engine Startup Parameters; Managing Services from the Command Line; Managing the SQL Server Command-Line Executable; Managing Server Activity; Examining Process Information; Tracking Resource Waits and Blocks; Troubleshooting Deadlocks and Blocking Connections; Tracking Command Execution in SQL Server
Introducing SQL Server Groups and the Registered Servers ViewCreating a Server Group; Deleting a Server Group; Editing and Moving Server Groups; Adding SQL Servers to a Group; Managing Servers; Registering a Connected Server; Registering a New Server in the Registered Servers View; Registering Previously Registered SQL Server 2000 Servers; Updating Registration for Local Servers; Copying Server Groups and Registration Details from One Computer to Another; Editing Registration Properties; Connecting to a Server; Disconnecting from a Server; Moving a Server to a New Group
Killing Server ProcessesChapter 2: Managing SQL Server Services and Clients; Managing SQL Server Component Feature Access; Managing the Network and SQL Server Native Client Configuration; Managing the Connections Configuration; Specifying the Shared Memory Network Configuration; Specifying the Named Pipes Network Configuration; Specifying the TCP/IP Network Configuration; Configuring Security for Native Client Configurations; Configuring the Native Client Protocol Order; Configuring the Shared Memory Native Client Configuration; Configuring the Named Pipes Native Client Configuration
Summary Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. 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 done--whether at your desk or in the field!Get fast facts to:Manage SQL Server services and clientsConfigure, manage, and tune serversImplement policy-based managementAdminister security and accessMonitor server activity and tune performanceAutomate maintenancePerform backups and recovery
Notes Registering Subordinate Servers and Groups
Bibliography Includes bibliographical references and index
Notes Print version record
Subject SQL server -- Handbooks, manuals, etc.
Client/server computing -- Handbooks, manuals, etc.
Genre/Form Handbooks and manuals.
Handbooks and manuals.
Form Electronic book
ISBN 0735663769