Microsoft SQL Server 2008 For Dummies

  • 4h 32m
  • Mike Chapple
  • John Wiley & Sons (US)
  • 2008

The fun and easy way to build powerful databases

See how to administer, troubleshoot, and report like a pro in SQL Server

Are you ready to unleash the power hidden within your organization's data to meet business objectives? This book will help you build the skills that SQL Server database administrators must have to succeed. You'll find out how to develop and maintain a SQL Server system, design databases, manipulate data, and much more.

Discover how to:

  • Build your first SQL Server databases
  • Insert, manipulate, and retrieve data
  • Keep your database server running smoothly
  • Protect data from prying eyes
  • Improve performance with database snapshots

About the Author

Mike Chapple, MCDBA, CISA, CISSP is an IT professional with over ten years’ experience with SQL Server. He currently serves as an IT professional with the University of Notre Dame, where he also teaches an undergraduate computer applications course. Mike actively participates as a subject matter expert in the SQL Server community and writes extensively on SQL Server at the Guide to Databases. He also serves on the Center for Internet Security SQL Server security standard development team.

Mike is a technical editor for Information Security Magazine and is author of several books, including Information Security Illuminated and the CISSP Prep Guide. Mike holds a BS in computer science from the University of Notre Dame, an MS in computer science from the University of Idaho, and an MBA from Auburn University.

In this Book

  • Introduction
  • Introducing SQL Server 2008
  • Building Your SQL Server
  • Working with SQL Server Tools
  • Planning Your Database
  • Creating Databases and Tables
  • Imposing Constraints and Relationships
  • Constructing Simple Database Queries
  • Joins and Other Advanced Queries
  • Turning Data into Information with SQL Server Reporting Services
  • Inserting, Updating, and Deleting Data
  • Saving Time with Functions, Stored Procedures, and Triggers
  • Keeping Your SQL Server Running Smoothly
  • Automating SQL Server 2008 Administration
  • Troubleshooting SQL Server 2008 Problems
  • Replicating Data across Multiple Servers
  • Protecting Your Data from Prying Eyes
  • Preserving the Integrity of Your Transactions
  • Preparing for Disaster
  • Staying Alive—High Availability in SQL Server 2008
  • Implementing Policy-Based Management with the Declarative Management Framework
  • Ten Ways to Keep Your SQL Server 2008 Databases Humming
  • Ten Database Design Tips