Dummies.com
  • Print
  • Share
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies (0470179546) cover image

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

ISBN: 978-0-470-17954-3
Paperback
768 pages
September 2008
US $39.99 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

Other Available Formats: E-book

Introduction 1

Book I: Essential Concepts 7

Chapter 1: Introducing SQL Server 2008 9

Chapter 2: SQL Server Architecture and Key Concepts 15

Chapter 3: Getting Started, Getting Around 23

Chapter 4: Setting Up SQL Server 2008 35

Chapter 5: Using SQL Server Management Studio 59

Book II: Designing and Using Databases 73

Chapter 1: Setting Up a Database 75

Chapter 2: Care and Feeding of Your Database 89

Chapter 3: Data Types and How to Use Them 99

Chapter 4: Constructing New Tables 121

Chapter 5: Looking After Your Tables 141

Chapter 6: Understanding Relationships 155

Book III: Interacting with Your Data 175

Chapter 1: Using Proper Normalization Techniques 177

Chapter 2: The SQL Server Optimizer 187

Chapter 3: Using the Query Designer 201

Chapter 4: Setting Query Options 213

Chapter 5: Searching for Information 231

Chapter 6: Organizing Query Results 257

Chapter 7: Modifying Your Data 265

Chapter 8: Taking Advantage of Views 273

Chapter 9: Advanced Query Topics 291

Book IV: Database Programming 313

Chapter 1: Understanding Transact-SQL 315

Chapter 2: Stored Procedures and Functions 331

Chapter 3: Triggers 349

Chapter 4: Working with Visual Studio 361

Chapter 5: Web Services 375

Chapter 6: Developing Remote Applications 385

Chapter 7: Advanced Development Topics 401

Book V: Reporting Services 419

Chapter 1: Introduction to SQL Server Reporting Services 421

Chapter 2: Creating Reports with Report Builder 435

Chapter 3: Creating Reports with Report Designer 449

Chapter 4: Integrating Reports 469

Book VI: Analysis Services 477

Chapter 1: Introduction to SQL Server Analysis Services 479

Chapter 2: Creating Business Intelligence Solutions with BIDS 493

Chapter 3: Data Mining and Maintaining Analysis Services Objects 517

Book VII: Performance Tips and Tricks 529

Chapter 1: Working with the SQL Server Optimizer 531

Chapter 2: Using Performance Monitoring Tools 541

Chapter 3: Data Access Strategies 569

Chapter 4: Tuning SQL Server 587

Book VIII: Database Administration 601

Chapter 1: Configuring SQL Server 603

Chapter 2: Performing Major Administrative Tasks 619

Chapter 3: Security: Keeping SQL Server Safe 647

Chapter 4: Integration and Your Database 661

Chapter 5: Replication 677

Chapter 6: Spreading the Load with Partitioning 693

Book IX: Appendixes 701

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

Appendix B: Troubleshooting SQL Server 2008 707

Appendix C: Glossary 715

Index 725

  • Print
  • Share