Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

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

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

ISBN: 978-1-118-05194-8
E-book
768 pages
February 2011
US $25.99 Purchase This E-book

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

How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your 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