SQL Server 2008 Administration Instant Reference
by Michael Lee; Mike MansfieldEdition: 1st
Format: Paperback
Pub. Date: 2009-09-01
Publisher(s): Sybex
Other versions by this Author
List Price: $31.49
Buy New
Usually Ships in 8 - 10 Business Days.
$29.99
Rent Book
Select for Price
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
SQL Server 2008 Instant Reference is a concise guide of the product and database topics. The material is aimed for IT professionals who want the essentials in administering SQL Server 2008. The book's features like tables, lists, and step-by-step instruction make this book a quick reference. SQL Server 2008 Instant Reference addresses a host of critical topics, including- Installing and configuring SQL Server- Managing and maintaining SQL Server- Data storage and optimizing the database engine- Optimizing server performance and troubleshooting- SQL Server security- Going beyond the relational engine by working with spatial data and distributed data- SQL Server 2008 data transfer mechanisms- Database mirroring- Clustering- Business intelligence
Author Biography
Michael Lee, MCT, MCITP, MCPD, SCJP, has been teaching SQL Server since 1995, providing training and consulting services in SQL Server and Enterprise Data Architecture to companies across the U.S. and Europe. Mike Mansfield is a Senior Technical Trainer for signal learning in Indianapolis, Indiana, and holds many 2008 products certifications. Mike began teaching at Missouri State University in 2003. Prior to 2003, he worked in production environments and as a consultant for nearly two decades. Mike has authored or designed many courses and specialized training.
Table of Contents
| SQL Server Basics | |
| Installing SQL Server 2008 | |
| Configuring SQL Server 2008 | |
| Creating Databases, Files, and Tables | |
| Executing Basic Queries | |
| Data Integrity and Security | |
| Managing Data Integrity | |
| Managing Transactions and Locking | |
| Managing Security | |
| Data Administration | |
| Implementing Availability and Replication | |
| Extracting, Transforming, and Loading Data | |
| Managing Data Recovery | |
| Performance and Advanced Features | |
| Monitoring and Tuning SQL Server | |
| Planning and Creating Indexes | |
| Implementing Policy-Based Administration | |
| Automating with the SQL Agent Service | |
| Table of Contents provided by Publisher. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.