Create bookmark
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant
Notes
Please login to add notes
- + Cover
- Table of Contents
- Acknowledgments
- Introduction
-
+
Chapter 1: SQL Server 2008 Administration Overview
-
+
Chapter 2: Deploying SQL Server 2008
-
+
Chapter 3: Managing the Surface Security, Access, and Network Configuration
- Managing SQL Server Component Feature Access
- + Configuring SQL Server Services
-
+
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
- Configuring the TCP/IP Native Client Configuration
-
+
Chapter 4: Configuring and Tuning SQL Server 2008
-
+
Chapter 5: Managing the Enterprise
- + Using SQL Server Management Studio
- + Managing SQL Server Groups
-
+
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
- Deleting a Server Registration
- Using Windows PowerShell for SQL Server Management
- Starting, Stopping, and Configuring SQL Server Agent
- Starting, Stopping, and Configuring Microsoft Distributed Transaction Coordinator
- + Managing SQL Server Startup
- + Managing Server Activity
-
+
Chapter 6: Implementing Policy-Based Management
- Introducing Policy-Based Management
- Working with Policy-Based Management
-
+
Managing Policies Throughout the Enterprise
- Importing and Exporting Policies
- Configuring Central Management Servers
- Executing Statements Against Multiple Servers
- Configuring and Managing Policy Facets
- Creating and Managing Policy Conditions
- Creating and Managing Policies
- Managing Policy Categories and Mandating Policies
- Evaluating Policies
- Troubleshooting Policy-Based Management Policies
-
+
Chapter 7: Configuring SQL Server with SQL Server Management Studio
- + SQL Server Management Studio Essentials
- + 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
- Adding and Removing Active Directory Information
- + Troubleshooting Configuration Problems
-
+
Chapter 8: Core Database Administration
- Database Files and Logs
- + Database Administration Basics
- + Creating Databases
-
+
Altering Databases and Their Options
- Setting Database Options in SQL Server Management Studio
- Modifying Databases Using ALTER DATABASE
- Configuring Automatic Options
- Controlling ANSI Compliance at the Database Level
- Configuring Parameterization
- Configuring Cursor Options
- Controlling User Access and Database State
- Setting Online, Offline, or Emergency Mode
- Managing Cross-Database Chaining and External Access Options
- Configuring Recovery, Logging, and Disk I/O Error Checking Options
- Viewing, Changing, and Overriding Database Options
- + Managing Database and Log Size
- + Manipulating Databases
- + Tips and Techniques
-
+
Chapter 9: Managing SQL Server 2008 Security
-
+
Chapter 10: Manipulating Schemas, Tables, Indexes, and Views
-
+
Chapter 11: Importing, Exporting, and Transforming Data
-
+
Chapter 12: Linked Servers and Distributed Transactions
-
+
Chapter 13: Implementing Snapshot, Merge, and Transactional Replication
-
+
Chapter 14: Profiling and Monitoring SQL Server 2008
-
+
Chapter 15: Backing Up and Recovering SQL Server 2008
- + Chapter 16: Database Automation and Maintenance
-
+
Chapter 17
: Managing Log Shipping and Database Mirroring
-
+
Log Shipping
- Log Shipping: How It Works
- Preparing for Log Shipping
- Upgrading SQL Server 2000 Log Shipping to SQL Server 2008 Log Shipping
- Enabling Log Shipping on the Primary Database
- Adding Log Shipping Secondary Databases
- Changing the Transaction Log Backup Interval
- Changing the Copy and Restore Intervals
- Monitoring Log Shipping
- Failing Over to a Secondary Database
- Disabling and Removing Log Shipping
- + Database Mirroring
- Using Mirroring and Log Shipping
-
+
Log Shipping
- Index
- About the Author
From the author and series editor of the immensely popular ADMINISTRATOR'S POCKET CONSULTANT series from Microsoft Press®-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals.
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you'll want with you at all times as you deal with Microsoft® SQL Server® 2008 and SQL Server® 2008 R2 administration. Whether you handle administration for 50 users or 5000, this hands-on, fast answers guide focuses on what you need to do to get the job done quickly. With extensive easy-to-read tables, lists, and step-by-step instructions, it's the portable, readable guide that you consistently save you time and minimize system downtime by giving you the right information right now.
Get fast facts to:
- Plan, deploy, and configure SQL Server® 2008 R2
- Administer server and surface security, access, and network configuration
- Import, export, transform, and replicate data
- Use SQL Server® Management Studio for core administrative tasks
- Manipulate schemas, tables, indexes, and views
- Automate maintenance and implement policy-based management
- Monitor server activity and tune performance
- Manage log shipping and database mirroring
- Perform backups and recovery
Test the closed alpha on paperc.com
Book Details
Authors
Categories
Computers > Desktop Applications > Databases
Publishers
Publication year : 2010
License: All rights reserved ©
Times read: 197

