Microsoft® SQL Server® 2012 Pocket Consultant

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 don...

Full description

Bibliographic Details
Main Author: Stanek, William
Format: eBook
Language:English
Published: Sebastopol Microsoft Press 2012
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 04948nmm a2200481 u 4500
001 EB001935068
003 EBX01000000000000001097970
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9780735670303 
020 |a 9780735663763 
020 |a 9780735670273 
020 |a 0735670277 
020 |a 0735670307 
050 4 |a QA76.9.C55 .S889 2012 
100 1 |a Stanek, William 
245 0 0 |a Microsoft® SQL Server® 2012 Pocket Consultant 
260 |a Sebastopol  |b Microsoft Press  |c 2012 
300 |a 590 pages 
505 0 |a Includes bibliographical references and index 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
653 |a Client/server computing / fast 
653 |a Architecture client-serveur (Informatique) / Guides, manuels, etc 
653 |a SQL server / fast 
653 |a Client/server computing / Handbooks, manuals, etc 
653 |a SQL server / Handbooks, manuals, etc 
653 |a Computer Science / hilcc 
653 |a Engineering & Applied Sciences / hilcc 
653 |a SQL server / blmlsh 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
500 |a Registering Subordinate Servers and Groups 
015 |a GBB1D1469 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780735670273/?ar  |x Verlag  |3 Volltext 
082 0 |a 500 
082 0 |a 005.7585 
082 0 |a 620 
520 |a 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