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 Dummiescan 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 Dummiesis 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!

Table of Contents

Book I Essential Concepts
Chapter 1: Introducing SQL Server 2008
Chapter 2: SQL Server Architecture and Key Concepts
Chapter 3: Getting Started, Getting Around
Chapter 4: Setting Up SQL Server 2008
Chapter 5: Using SQL Server Management Studio

Book II Designing and Using Databases
Chapter 1: Setting Up a Database
Chapter 2: Care and Feeding of Your Database
Chapter 3: Data Types and How to Use Them
Chapter 4: Constructing New Tables
Chapter 5: Looking After Your Tables
Chapter 6: Understanding Relationships

Book III Interacting with Your Data
Chapter 1: Using Proper Normalization Techniques
Chapter 2: The SQL Server Optimizer
Chapter 3: Using the Query Designer
Chapter 4: Setting Query Options
Chapter 5: Searching for Information
Chapter 6: Organizing Query Results
Chapter 7: Modifying Your Data
Chapter 8: Taking Advantage of Views
Chapter 9: Advanced Query Topics

Book IV Database Programming
Chapter 1: Understanding Transact-SQL
Chapter 2: Stored Procedures and Functions
Chapter 3: Triggers
Chapter 4: Working with Visual Studio
Chapter 5: Web Services
Chapter 6: Developing Remote Applications
Chapter 7: Advanced Development Topics

Book V Reporting Services
Chapter 1: Introduction to SQL Server Reporting Services
Chapter 2: Creating Reports with Report Builder
Chapter 3: Creating Reports with Report Designer
Chapter 4: Integrating Reports

Book VI Analysis Services
Chapter 1: Introduction to SQL Server Analysis Services
Chapter 2: Creating Business Intelligence Solutions with BIDS
Chapter 3: Data Mining and Maintaining Analysis Services Objects

Book VII Performance Tips and Tricks
Chapter 1: Working with the SQL Server Optimizer
Chapter 2: Using Performance Monitoring Tools
Chapter 3: Data Access Strategies
Chapter 4: Tuning SQL Server

Book VIII Database Administration
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

Book IX Appendixes
Appendix A: Ten Sources of Information on SQL Server 2008
Appendix B: Troubleshooting SQL Server 2008
Appendix C: Glossary