Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

Description

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!

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.