Microsoft SQL Server 2008 Step by Step

by Hotek, Mike

• ISBN13: 9780735626041
• ISBN10: 0735626049
• Edition: 1st
• Format: Paperback
• Copyright: 2008-11-12
• Publisher: Microsoft Press

Summary

Teach yourself SQL Server 2008one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems.Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply tuning plus optimization techniques to generate high-performing database applications Optimize availability through clustering, database mirroring, and log shipping Tap business intelligence toolsReporting, Analysis, and Integration ServicesCD features: Practice exercises and code samples Fully searchable eBook

Author Biography

Mike Hotek is a SQL Server expert with three decades' experience as a consultant and solution developer. He has written several books, including Microsoft SQL Server 2008 Step by Step.

Table of Contents

Overview of Microsoft SQL Server	p. 3
Installing and Configuring SQL Server 2008	p. 15
Using the Tools in SQL Server 2008	p. 31
Creating Databases	p. 51
Designing Tables	p. 63
Indexes	p. 87
Partitioning	p. 103
Data Retrieval	p. 121
Advanced Data Retrieval	p. 137
Data Manipulation	p. 153
Views	p. 179
Stored Procedures	p. 185
Functions	p. 199
Triggers	p. 213
Database Snapshots	p. 219
Service Broker	p. 225
Full-Text Indexing	p. 247
Security	p. 259
Policy-Based Management	p. 289
Data Recovery	p. 301
SQL Server Agent	p. 319
Dynamic Management Views	p. 333
High Availability	p. 345
SQL Server Integration Services	p. 377
SQL Server Reporting Services	p. 413
SQL Server Analysis Services	p. 451
Table of Contents provided by Blackwell. All Rights Reserved.