Critical.
Authoritative.
Strategic.
Subscribe to CIO Magazine »

Microsoft SQL Server 2008 All-In-One Desk Reference for Dummies®

If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You’ll discover how to:
  • Build and maintain tables
  • Design a database and communicate with it
  • Retrieve, analyze, and report data
  • Build solid, robust database applications
  • Use the SQL Server Optimizer and Query Designer
  • Navigate SQL Server with Visual Studio
  • Develop useful reports with the Report Builder and Report Designer
  • Create Business Intelligence solutions with Business Intelligence Development Studio
  • Configure your server and perform major administrative tasks

To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks:

  • Essential Concepts
  • Designing and Using Databases
  • Interacting With Your Data
  • Database Programming
  • Reporting Services
  • Analysis Services
  • Performance Tips and Tricks
  • Database Administration
  • Appendixes

Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!

Biography

Robert D. Schneider is a database optimization consultant who has been delivering software solutions for 15 years. Darril Gibson is a professional trainer specializing in certification and Microsoft technologies.

Table of Contents

Introduction.

Chapter 1: Configuring SQL Server.

Chapter 2: Performing Major Administrative Tasks.

Chapter 3: Security: Keeping SQL Server Safe.

Chapter 4: Integration and Your Database.

Chapter 5: Replication.

Chapter 6: Spreading the Load with Partitioning.

Appendix A: Ten Sources of Information on SQL Server 2008.

Appendix B: Troubleshooting SQL Server 2008.

Appendix C: Glossary.

Index.

rhs_login_lockGet exclusive access to Invitation only events CIO, reports & analysis.
Recent comments