9780470289044

Mastering SQL Server 2008 continues the approach of the previous editions by providing complete, accurate, and expert coverage of the product. The material is aimed at IT professionals who need coverage of the basics with a quick ramp up to intermediate and advanced database topics. Mastering SQL Server 2008 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

Michael Lee, MCT, MCITP, MCPD, SCJP, has been teaching SQL Server since 1995. Over the last 13 years, Michael has provided trainingand consulting services in SQL Server and Enterprise Data Architecture to companies across the U.S. and Europe. Gentry Bieker, MCT, MCITP, MCDBA, MCSE, has been a consultant, mentor, and trainer since 1998. He has been architecting, developing, and administering SQL Server databases since version 6.0.

Overview of Microsoft SQL Server 2008
Understanding SQL Server Architecture
Databases, Files, and Resource Management
Tables and CRUD Operations
Procedural programming
Managing Data Integrity
SQL Server and XML
Managing User Security
Data Recovery
Monitoring SQL Server Activity
Using the SQL Server Agent Service
Data Availability and Distribution
SQL Server Data Security
Indexing Strategies for Query Optimization
Transactions and Locking Strategies
Using Resource Governor and Policy-Based Management
SQL Server and the .NET Client
Leveraging the SQL Server .NET CLR
Using Spatial Data
Service Oriented Architecture and the Service Broker
Full Text Search Services
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Mastering SQL Server 2008

Mastering SQL Server 2008

047028904X

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review