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:
To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummiesis divided into nine minibooks:
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!
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
