Microsoft SQL Server 2008 Step by Step

  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Paperback
  • Copyright: 2008-11-12
  • Publisher: Microsoft Press
  • View Upgraded Edition

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99 Save up to $48.99
  • Rent Book $4.99
    Add to Cart Free Shipping


Supplemental Materials

What is included with this book?

  • 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.


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 Serverp. 3
Installing and Configuring SQL Server 2008p. 15
Using the Tools in SQL Server 2008p. 31
Creating Databasesp. 51
Designing Tablesp. 63
Indexesp. 87
Partitioningp. 103
Data Retrievalp. 121
Advanced Data Retrievalp. 137
Data Manipulationp. 153
Viewsp. 179
Stored Proceduresp. 185
Functionsp. 199
Triggersp. 213
Database Snapshotsp. 219
Service Brokerp. 225
Full-Text Indexingp. 247
Securityp. 259
Policy-Based Managementp. 289
Data Recoveryp. 301
SQL Server Agentp. 319
Dynamic Management Viewsp. 333
High Availabilityp. 345
SQL Server Integration Servicesp. 377
SQL Server Reporting Servicesp. 413
SQL Server Analysis Servicesp. 451
Table of Contents provided by Blackwell. All Rights Reserved.

Rewards Program

Write a Review