Microsoft® SQL Server® 2008 Administrator's Pocket Consultant.

Format:

Book

Author/Creator:

Stanek, William R.

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Database management.

Local Subjects:

Client/server computing.

Database management.

SQL server.

Physical Description:

1 online resource (1732 p.)

Edition:

1st edition

Other Title:

Administrator's pocket consultant

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

Portable and precise, this pocket-sized guide delivers ready answers for administering SQL Server 2008. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You'll get the focused information you need to solve problems and get the job done-whether at your desk or in the field! Get fast facts to: Plan, deploy, and configure SQL Server 2008Administer server and surface security, access, and network configurationImport, export, transform, and replicate dataUse SQL Server Management Studio for core

Contents:

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant; Introduction; How Is This Book Organized?; Conventions Used in This Book; Support; I. Microsoft SQL Server 2008 Administration Fundamentals; Microsoft SQL Server 2008 Editions; SQL Server and Windows; SQL Server Logins and Authentication; Service Accounts for SQL Server; Using the Graphical Administration Tools; Using the Command-Line Tools; SQLCMD; Other Command-Line Tools; Using the SQL Server PowerShell; Running and Using the SQL Server PowerShell; Working with SQL Server Cmdlets; 2. Deploying Microsoft SQL Server 2008

Using SQL Server 2008 for Relational Data WarehousingUsing SQL Server 2008 for Multidimensional Databases and Data Mining; Using SQL Server 2008 for Managed Reporting; Planning for Your SQL Server 2008 Deployment; Configuring the I/O Subsystem; Ensuring Availability and Scalability; Ensuring Connectivity and Data Access; Managing SQL Server Configuration and Security; Running and Modifying SQL Server Setup; Installing a SQL Server Instance; Adding Components and Instances; Repairing a SQL Server 2008 Installation; Upgrading Your Edition of SQL Server 2008; Uninstalling SQL Server

3. Managing the Surface Security, Access, and Network ConfigurationConfiguring SQL Server Services; Managing Service State and Start Mode; Setting the Startup Service Account; Configuring File Streaming; Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting; Managing the Network and SQL Native Client Configuration; Specifying the Shared Memory Network Configuration; Specifying the Named Pipes Network Configuration; Specifying the TCP/IP Network Configuration; Using Static TCP/IP Network Configurations; Using Dynamic TCP/IP Network Configurations

Configuring Security for Native Client ConfigurationsConfiguring the Native Client Protocol Order; Configuring the Shared Memory Native Client Configuration; Configuring the Named Pipes Native Client Configuration; Configuring the TCP/IP Native Client Configuration; 4. Configuring and Tuning Microsoft SQL Server 2008; Working with System Stored Procedures; Techniques for Managing SQL Server Configuration Options; Working with SET Options; Working with Server Options; Working with Database Options; Managing Database Compatibility; Configuring SQL Server with Stored Procedures

Executing Queries and Changing SettingsChecking and Setting Configuration Parameters; Changing Settings with ALTER DATABASE; II. Microsoft SQL Server 2008 Administration; Connecting to a Specific Server Instance; Connecting to a Specific Database; Managing SQL Server Groups; Creating a Server Group; Deleting a Server Group; Editing and Moving Server Groups; Adding SQL Servers to a Group; Managing Servers; 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

Notes:

Description based upon print version of record.

ISBN:

9780735636019

073563601X

OCLC:

609857107