Microsoft SQL Server 2008 For Dummies

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

Spis treści:
Introduction.
Part I: Welcome to SQL Server 2008.
Chapter 1: Introducing SQL Server 2008.
Chapter 2: Building Your SQL Server.
Chapter 3: Working with SQL Server Tools.
Part II: Building SQL Server 2008 Databases.
Chapter 4: Planning Your Database.
Chapter 5: Creating Databases and Tables.
Chapter 6: Imposing Constraints and Relationships.
Part III: Retrieving Data from Databases.
Chapter 7: Constructing Simple Database Queries.
Chapter 8: Joins and Other Advanced Queries.
Chapter 9: Turning Data into Information with SQL Server Reporting Services.
Part IV: Inserting and Manipulating Your Data.
Chapter 10: Inserting, Updating, and Deleting Data.
Chapter 11: Saving Time with Functions, Stored Procedures, and Triggers.
Part V: SQL Server Administration.
Chapter 12: Keeping Your SQL Server Running Smoothly.
Chapter 13: Automating SQL Server 2008 Administration.
Chapter 14: Troubleshooting SQL Server 2008 Problems.
Chapter 15: Replicating Data across Multiple Servers.
Part VI: Protecting Your Data.
Chapter 16: Protecting Your Data from Prying Eyes.
Chapter 17: Preserving the Integ rity of Your Transactions.
Chapter 18: Preparing for Disaster.
Chapter 19: Staying Alive: High Availability in SQL Server 2008.
Chapter 20: Implementing Policy–Based Management with the Declarative Management Framework.
Part VII: The Part of Tens.
Chapter 21: Ten Ways to Keep Your SQL Server 2008 Databases Humming.
Chapter 22: Ten Database Design Tips.
Index.

Nota biograficzna:
Mike Chapple, MCDBA, CISA, CISSP, is an IT professional at the University of Notre Dame, where he teaches a computer applications course. He is a coauthor of the CISSP Study Guide.

Okładka tylna:

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