Book description
Get the practical, pocket-sized guide for IT professionals who need
to administer, maintain, and optimize SQL Server 2008. Written by
award-winning author William Stanek, this portable reference
delivers essential details for using SQL Server 2008 to help
protect and manage your company s data whether automating tasks,
creating indexes and views, performing backups and recovery,
replicating transactions, tuning performance, managing server
activity, importing and exporting data, or performing other key
tasks. Featuring quick-reference tables, lists, and step-by-step
instructions, this handy, one-stop guide provides fast, accurate
answers on the spot whether you re at your desk or in the
field!
Key Book Benefits
Provides fast facts and immediate reference for administering SQL
Server 2008 Delivers must-know details for taking advantage of the
improved scalability, security features, and management tools in
SQL Server 2008 Features concise tables, easy-to-scan lists, and
step-by-step instructions for fast answers, wherever you need them
Table of contents
-
Microsoft® SQL Server® 2008 Administrator’s Pocket Consultant
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- Acknowledgments
- Introduction
-
I. Microsoft SQL Server 2008 Administration Fundamentals
- 1. Microsoft SQL Server 2008 Administration Overview
- 2. Deploying Microsoft SQL Server 2008
-
3. Managing the Surface Security, Access, and Network Configuration
- Managing SQL Server Component Feature Access
- Configuring SQL Server Services
-
Managing the Network and SQL 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
- 4. Configuring and Tuning Microsoft SQL Server 2008
-
II. Microsoft SQL Server 2008 Administration
-
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
- Starting, Stopping, and Configuring SQL Server Agent
- Starting, Stopping, and Configuring Microsoft Distributed Transaction Coordinator
- Managing SQL Server Startup
- Managing Server Activity
-
6. Configuring Microsoft SQL Server with SQL Server Management Studio
- Managing the Configuration with SQL Server Management Studio
- Determining System and Server Information
- 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
-
7. 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
-
8. Full-Text Search Administration
- Full-Text Catalogs and Indexes
- Managing Full-Text Catalogs
- Managing Full-Text Search
- 9. Managing SQL Server 2008 Security
-
5. Managing the Enterprise
-
III. Microsoft SQL Server 2008 Data Administration
-
10. Manipulating Schemas, Tables, Indexes, and Views
- Working with Schemas
- Getting Started with Tables
- Table Essentials
- Working with Tables
- Managing Table Values
- Using Views
- Creating and Managing Indexes
- Column Constraints and Rules
- Creating Partitioned Tables and Indexes
- Compressing Tables, Indexes, and Partitions
- 11. Importing, Exporting, and Transforming Data
- 12. Linked Servers and Distributed Transactions
- 13. Implementing Snapshot, Merge, and Transactional Replication
-
10. Manipulating Schemas, Tables, Indexes, and Views
-
IV. Microsoft SQL Server 2008 Optimization and Maintenance
- 14. Profiling and Monitoring Microsoft SQL Server 2008
-
15. Backing Up and Recovering Microsoft SQL Server 2008
- 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
-
16. Database Automation and Maintenance
- Overview of 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
-
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
-
18. 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
- About the Author
- Index
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
Product information
- Title: Microsoft® SQL Server® 2008 Administrator's Pocket Consultant
- Author(s):
- Release date: September 2008
- Publisher(s): Microsoft Press
- ISBN: 9780735625891
You might also like
book
Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant
Here’s the utterly practical, pocket-sized reference for IT professionals who need to administer, optimize, and maintain …
book
Beginning, Microsoft® SQL Server® 2008 Administration
SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will …
book
MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide
This ebook does not provide access to the CD-ROM files. Covering Microsoft's brand-new SQL 2005 administrator …
book
Microsoft® SQL Server® 2008 Bible
Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing …